How to build a WooCommerce product database optimized for conversions
The layout of your e-commerce site plays a key role in improving both customer engagement and sales. For some sites, such as those selling technical products or offering a wide variety of items, standard product layouts aren't the best way to do this. Enter WooCommerce product database.
By using a WooCommerce product database, you can show off your merchandise to best advantage. Plus, enabling your customers to search, sort, and filter items will help them find what they're looking for quickly. As an added bonus, features such as Add to Cart buttons and product quick views can enhance customer engagement.
In this article, we'll share some reasons why you might want to include a product database on your WooCommerce site, as well as a product database example for two different websites. Then we'll explain how to build one with our WooCommerce Product Table plugin, and how to add a quick view function to it. Let's dive in!
Why include a product database on your WooCommerce store?
The default layout of the traditional WooCommerce shop page and product category pages works well for some stores. This mostly applies to ecommerce stores which sell visual products where the customer is happy to spend time browsing and looking at large images. Clothing is a good example of this.
But what about other types of product? What about stores selling large quantities and a wide variety of merchandise?
With a WooCommerce product database, on the other hand, your customers can search, sort, and filter items in the table to find what they need quickly. This is key to providing a positive User Experience (UX), and can even increase sales. Conversely, a difficult-to-navigate website may deter your visitors from converting. If they can't find what they are looking for in a couple of clicks, it won't be long before they decide to look elsewhere.
Additionally, a large image isn't always the best way to show customers your merchandise. Some products, such as e-books or very simple items, are digital or simply aren't very interesting to look at. In these cases, a short description or technical product data may be more appropriate.
While this list is by no means exhaustive, here are a few examples of products that may sell better in a database format:
- Spare machine and car parts
- Storage bins, boxes, and other containers
- Gift cards
- Tickets to or registrations for events
- Services such as cleaning, pet sitting, and hauling
- Digital products such as music and e-books
Seeing a WooCommerce product database in action may give you a better idea of what it's capable of and how you might use one on your own site. With that in mind, let's look at a few product database examples on actual sites that use product databases made with the WooCommerce Product Table plugin.
Case study #1 - Yarn Gate's wholesale product database example
Yarn Gate is a wholesale store selling premium yarn and wool to B2B customers. Its product database includes images and a quick view feature with variation swatches, so customers can see all the available colors:
Since yarn isn't all that visually interesting, individual product pages aren't really relevant. Plus, using a WooCommerce product database significantly improves Yarn Gate's website UX. Its customers can easily view and purchase multiple colors of yarn without having to navigate to several different pages. They can select the options for variable products in the quick view lightbox. With this system, customers see more products at one time than they would in a typical WooCommerce layout.
By speeding up and simplifying the purchasing process, Yarn Gate is on the road towards maximizing sales. Its customers generally buy in bulk, so using a product database is the best way to streamline its customers' experience and encourage them to buy more.
Case study #2 - First Kitchen's database of parts & accessories
First Kitchens sells cabinet doors and other accessories for kitchens, and doesn't need to display product images at all. Its database features dimensions instead, which is more useful information for its customers:
This company is using product databases in a unique way, in order to cross-sell its products. Each of this site's product pages includes a table that lists related items, so customers can buy everything they need on a single page. It's basically a list of related products, displayed in a database-style format.
Additionally, the tables of related products act as order forms. Customers can select product variations and add items to their carts right from the database. That way, just like the previous product database example we featured, visitors don't have to navigate between pages.
We'll discuss how to implement this technique on your own site next.
How to build a WooCommerce product database with search, sort, and filter features (in 4 steps)
While there are many ways to create a WC product database in WordPress, the simplest and most flexible option is to pick up our WordPress plugin, WooCommerce Product Table:
This tool includes a variety of useful features, such as:
- The ability to list products in a searchable table and add filters and custom fields to it
- Multi-select Add to Cart buttons to help customers make fast purchases
- Lazy load feature so that you can quickly list thousands of products in a single table
In the tutorial below, we'll show you how to use this plugin to build your own WooCommerce products database and give you some tips to keep in mind.
Step 1: Install and activate the WooCommerce Product Table plugin
First, you'll need to purchase WooCommerce Product Table. You can choose from a variety of license options:
Once you have the plugin, download the .zip file and make sure you have your license key on hand. Then, in your WordPress dashboard, navigate to Plugins and select Add New. Click on Upload Plugin at the top of the page, and choose the WooCommerce Product Table .zip file to upload and install it on your site:
Click the Activate Now button on the next screen to finish the process. Now you're ready to start customizing its settings to create your WooCommerce product database.
Step 2: Create a WooCommerce database
The Product Table pljgin comes with an easy table builder which lets you create a WooCommerce product database in minutes. This launches automatically when you first activate the database plugin, or you can access it later at Products → Product Tables.
The table builder takes you through the process of setting up your first product database, step-by-step. There are a wide range of settings which you can adjust to create the perfect product database for your merchandise. I'll talk you through some of the most important ones.
2a. Choose where to display the WooCommerce product database
You can specify whether you want your database to include all of your products, or only items from a certain category. This can be useful if you want to use product pages for some items, and display the rest in an organized table.
Alternatively, you can enable the WooCommerce database layout automatically on your main shop and category pages.
2b. Customize your database's columns
One of the best things about an ecommerce database created with WooCommerce Product Table is that you can customize what columns are displayed for your products.
First, you'll want to determine what information your WC product database will include. The default columns are each product's name, a short description, the price, and an Add to Cart button. However, there are many more columns you can choose to include, such as sku, custom taxonomies, images and reviews:
When choosing which columns to include, try putting yourself in your visitor's shoes. Consider: Is this column going to help them find the product they're looking for? User experience is the name of the game here, so make sure you customize your database to make it easily searchable. As part of this, include columns that will help your customers make the right buying decision.
If you do choose to feature images, you can specify their size and enable lightbox displays as well.
Some columns link to the single product page. If you're using a product database in place of product pages, then click the 'Advanced' toggle for each column to disable the product page links.
2c. Add search, sort, and filter features to your WooCommerce product database
A long database can be intimidating to customers and difficult to sort through, especially if you offer a lot of products. To improve your database's ease of use, you'll want to add features that make it simple for users to search the database and find what they're looking for quickly.
The search box will appear above the product database automatically. You can also add as many filter dropdowns as you like, and select the initial sort order for the products. Customers will be able to re-order the database by clicking on the column headers.
Pro tip: for WooCommerce Product Table with the WooCommerce Product Filters plugin for even more advanced filtering options. This filter plugin supercharges the filtering throughout the store, with a wide range of filter types and filter widgets.
With all of these settings enabled, your customers will be able to find their desired products in your database quickly.
2b. List large numbers of products in the database
You can also enable lazy loading, which can help improve your site's UX if your database includes hundreds or even thousands of products. This can prevent slow loading times that cause frustration for customers. Just be aware that this particular feature will disable some of the plugin's other functionality, in order to maximize speed.
If you want, you could even turn the WooCommerce database into a convenient order form where customers can select product variations and product add-ons right from the table. Combined with Add to Cart buttons and checkboxes, these features enable your users to customize their products and checkout without leaving the WooCommerce database page.
Step 3: Add the database to your site
Finally, you'll want to add your database to a page on your WordPress website. You can skip this step if you chose the option to enable the database layout on your main shop and category pages.
The easiest option is to insert a 'Product Table' block wherever you want the table to appear. If you're not using the WordPress block editor then you can copy a shortcode from the final page of the table builder and insert this instead. You can find the shortcode at any time by going to Products → Product Tables. For example, you'll need this method if you're using a page builder plugin such as Elementor.
Either way, your WooCommerce product database will now be visible to customers on the front end 🚀
Adding quick view links to your product database
If you have high-quality images of your products, adding a 'quick view' feature to your Woo product database may be useful. Quick views have been shown to increase conversions, and they display your products in their best light.
As we've seen in our first product database example, Yarn Gate provides their visitors with an easy way to browse their products. Their customers don't need to waste time going back and forth between pages. This is a smart way to boost user experience for any similar website with numerous available items.
Additionally, by keeping customers on your database's page, you'll encourage them to browse more products. Quick view and add-to-cart options enable easy browsing and purchases right from your database. Check out our complete guide to WooCommerce quick view.
To add quick view functionality to your WooCommerce product inventory, you can use the WooCommerce Quick View Pro plugin:
All you have to do is install and activate the plugin, and then add quick-view to the list of database columns in the WooCommerce Product Table settings (as we described above). After that, you can customize your quick view layout in the WooCommerce Quick View Pro plugin settings.
Add advanced filtering to your product database
While WooCommerce Product Table is a great way to enhance the user experience, it doesn't offer the same advanced filtering capabilities as the WooCommerce Product Filters plugin.
By using WooCommerce Product Filters alongside Product Table, you can provide your customers with even more sophisticated ways to navigate your product database. With advanced filters such as color, size, price, and ratings, your customers can easily narrow down their search to find the exact product they are looking for.
In addition, the WooCommerce Product Filters plugin offers a variety of display options, including dropdown lists, checkboxes, radio buttons, and more. This allows you to customize the look and feel of your product filters to match the style of your online store, creating a seamless user experience.
Where to get the WooCommerce plugin
Including a WooCommerce product database on your WordPress site can help improve your customer experience and your sales. Our WooCommerce Product Table plugin makes it easy to add custom databases to your online store, and you can make them even better by combining them with WooCommerce Quick View Pro or WooCommerce Product Filters.
To build a product database for your WooCommerce site, you can:
-
- Install and activate the WooCommerce Product Table plugin.
- Configure the plugin's settings
- Customize your database's columns.
- Add the database to your site.
Do you have any additional questions about building a WooCommerce product inventory with search, sort, and filter options? Leave them in the comments section below!