View the web version

CommerceGurus

Hi there, hope you're having a great Friday!

This is Colm and Simon from CommerceGurus, with a handpicked weekly roundup of eCommerce articles.


WooCommerce Database Optimization Guide

WooCommerce by default uses both WordPress database tables and custom tables to store data.

However, it’s important to note that WooCommerce doesn’t have a dedicated table to store customer data.

Customer data is stored in different database tables which makes it difficult to find and retrieve.

But finally, WooCommerce are planning to implement custom tables and replace the legacy, chunky tables that make the WooCommerce database slow. This should dramatically improve database performance and make it easier to remove and edit unused database tables.

Learn more about WooCommerce Data Optimization


6 Tips for Product Photos on Listing Pages

The Nielsen Norman Group have published an excellent article on how to optimize Product Photos on Listing or Catalog Pages.

Showing items in the context in which they’ll be used helps shoppers get a sense of the scale and look of the product. For example, this might mean showing:

  • Furniture in a room
  • Clothes on a model
  • Toys next to a child

Product images should be big enough and detailed enough for users to get a sense of the product.

Providing multiple images of each product on listing pages gives users additional details to help them decide what to click on.

See 6 Tips on Improving Product Photos on Listings Pages


WordPress 6.0: Performance increase for sites with large user counts

In WordPress 6.0 (due to be released on May 24th), websites with more than 10,000 users will see improvements in handling users.

Prior to this release sites with more than 10,000 users would suffer from slow page loading time in the user and post list screens.

This is an important performance step, particularly for those of us running WooCommerce stores. As each order automatically creates a new user, it's likely many stores have exceeded the 10,000 point, especially if you have been running a business for a couple of years.

Read about the user count performance increase coming in WordPress 6.0


WooCommerce Snippet: Retain Field Values on Checkout Reload

Rodolfo from Business Bloomer has come up with another code snippet which you might find handy for your own WooCommerce-powered online store.

Go to your WooCommerce checkout page as a logged out user and fill out the billing name, surname, address, email and phone fields. If you leave this page and return later, everything you filled out (apart from the address) are gone!

This annoying WooCommerce flaw is about to go away with a few lines of code. Either reload the Checkout page or go back to it later – your information will still be there.

Discover the Retain Field Values Code Snippet


Pika – Create screenshots and browser mockups quickly

If you've ever wanted to create more professional looking screenshots for landing pages or blog posts, you might be interested in Pika.

Pika is a free web app to transform RAW screenshots into beautiful images, which you would be proud to share on your landing pages, emails, Twitter or marketing pages.

The main goal behind Pika is to fasten this process of designing screenshots.

You can add gradient backgrounds, a browser frame, rounded corners and more.

Take a closer look at Pika, a free tool for better looking screenshots


That's it for this edition. Simply reply to this email if you have any questions or suggestions, we read every message. Have a great week and best of luck with your projects!

Colm and Simon from CommerceGurus

MadeInContext Ltd., 13 Baggot Street Upper, Dublin 4, D04 W7K5, Ireland. Would you rather not receive these emails? Unsubscribe here.