loader image

Author: mayank

What if your WooCommerce site has 15K products? or 60K products? or more than 100K products?

If you are a WooCommerce developer or as a business owner having a WooCommerce website running with a large inventory then at some point in time above question might have come to your mind.

Speed is in the important matrix for any site to grow to the top, remain in popularity, and for higher sales conversion. And for sites with larger inventory e.g. the jewelry and diamond websites, the problem becomes hard to solve when the number of diamonds goes in thousands in some instances above 100K.

To understand the problem we have run some benchmarks. We did that to define the problem based on proof and to create a foundation to solve it in the right direction.

Benchmarks we did

We have run a variety of benchmarks covering the stock installations, with the optimization plugins like caching, etc enabled including our optimization plugin. You will come across these variants of benchmarks as you go further in this article.

Details of the number of products, categories, attributes, etc. in the database

– The number of products — ~68.3K

– The number of categories — 36

– The number of products in the category — ~68.3K

– The number of attributes — 12

– The number of values in the attribute-249/6/10/401/4/4/7/4/41/5/401/4

– The number of attributes of the product — 12

– The number of variable products — ~361К

– The number of rows in wp_postmeta table — ~9Million

– The number of product options — 1–5

– The number of photos of each product — 3

Plugins used and the philosophy we believe in

We are trying to recognize the problem that a WooCommerce store might have when the number of products is quite larger. And to solve the same problem we believe in using available plugins that are solving the specific problem and develop our solution as a plugin where we think the community lacks a certain plugin solving a particular problem. So it is obvious that to get the best performance one needs to use a combination of 2–3 plugins fitting with the content, data, and kind of traffic the site is serving to. For this benchmark, we have used a combination of the external plugin and our plugin, whenever you read below a mention of external plugins then it means W3TC plugin, Cloudflare service, and image compression plugins for image compression here it is necessary to note that we are not endorsing any of the external plugins mentioned here neither we say that this is the only good option but we find it good enough to help us solve the problem. You can use any plugin that you think can fit better to your site structure,

Server & Hardware

AWS EC2 Instance

2GB RAM

SSD

Front end benchmark results at 68K products

Note: The benchmarks mentioned below are for the shop page. And you can access here the actual shop page running the demo used in this benchmark.

Google PageSpeed Insights

  • Mobile (without any optimizations enabled)
  • Desktop (without any optimizations enabled)
  • Mobile (with our Free plugin and extension solution enabled)
  • Desktop (with our Free plugin and extension solution enabled)
  • Mobile (with external optimization plugin + our Free plugin and extension solution enabled)
  • Desktop (with external optimization plugin + our Free plugin and extension solution enabled)

GTmetrix

On the first test

On the second attempt as re-test

On the third attempt as re-test

On the first test (with our Free plugin and extension solution enabled)

On the second attempt as re-test (with our Free plugin and extension solution enabled)

On the third attempt as re-test (with our Free plugin and extension solution enabled)

On the first test (with external optimization plugin + our Free plugin and extension solution enabled)

On the second attempt as re-test (with external optimization plugin + our Free plugin and extension solution enabled)

On the third attempt as re-test (with external optimization plugin + our Free plugin and extension solution enabled)

Load test

With 20VUs at a time, for 5 mins. With roughly 3.5K requests made in 5 minutes.

Without any optimizations enabled

(It caused the server to went down and even ssh connection wasn’t working, needed a reboot!)

With our Free plugin and extension solution enabled

With external optimization plugin + our Free plugin and extension solution enabled

Woo product inserts speed benchmarks

The problem of front-end speed is not significant for sites with 5–10K products but it becomes highly significant when the sites are loaded by admin operations such as product insert/update and when there are some users online and bots are doing crawls etc. At such times the site becomes quite slow on the front end. Below are some different observations while product inserts are in progress.

1 These readings are for variational and simple products, It is noticed that at 27.9K products in woo catalog site’s front end becomes unusably slow so much that it takes 25 seconds to load the shop page while the continuous 1 product at a time insert in progress and the caching plugins was disabled.

1.1 with all above settings except now the simple products are continuously inserting 1 product at a time and so now around 75% products are of the simple type and this time in incognito mode and total DB at 41.5K products the shop page load time is ~60 seconds for 3 page-load tests.

2 It is noticed that for simple items insertions speed is ~5 sec per item while DB has

35K items/products

3 And it is noticed that the server CPU usage is going beyond 99% while the mem usage is around ~40% when even the simple products are being added and they are also one at a time but yeah repeatedly. So maybe putting some delay before repeating would help. The speed was 239 inserts per hour after testing for 3 hours.

3.1 After setting the delay of 3 seconds after each product insert. The speed was 359.6 inserts per hour after testing for ~3 hours while the total products in the database stand at ~65K. And the shop page load time is as given below while the product insert was in progress as per the pace and settings specified here:

Google PageSpeed Insights

Google PageSpeed Insights was showing timeout error when tried 2 times

GTMetrix

On the first attempt

On the second attempt as re-test

4 With the same settings as specified in point 3 above but with caching and optimization plugins enabled the W3TC and our plugin, the speed was 356.46 inserts per hour after testing for 1.5 hours while the total products in the database stand at ~65K. And the shop page load time is as given below while the product insert was in progress as per the pace and settings specified here:

Google PageSpeed Insights

Google PageSpeed Insights had timed out around 4–5 times out of 12 requests made and when it displayed the analysis the result was average once and good on for the rest but since it had timed out it is not worthy to show the result here.

GTMetrix

On the first attempt

On the second attempt as re-test

Findings

As can be seen in the above snaps it is quite clear that Woo is capable of handling more than 50K products if the right optimization plugin combinations are installed on the WooCommerce site. As you can see with our solution there is a large jump in the performance which is because of the optimized indexing layer and the independent DB layer that we use and it is critical to note here that these large jumps in performance can help hugely when your pages are not cached or when you need to rebuild caches quite frequently. However, I notice that merely with our solution the performance is not at its best and that is why we believe in the right combo and so after applying that you can see that the performance is very good when applied to the optimizations of the external plugin and our solution. But anyway there is one problem that is not addressed yet which is the insert speed which becomes quite slow once you start going past 15K products on your website. The solution is proposed in the below section.

Pain points

From the above stats, the one problem that is quite devastating is the insert speed of products at the backend and of course, it makes website front ends so slow that it almost becomes unusable. That is one of the major problems that is not met with any plugin solution yet. And it is a key problem not only for the backend but for front-end users also because when the backend operations are in progress our benchmarks stats above show that the frontend becomes slow. So for the sites with the larger inventory, this problem needs to be fixed because in the general case scenario such sites would be needing quite a frequent insert & updates of products which would affect front-end traffic no matter at which time the backend operations are run.

Our solutions

Free Plugin

In our free plugin, the fundamental feature that we provide is the basic DB layer which is quite helpful to increase the speed of searches, shop & category pages if your site is having a large inventory starting from 15K products.

The other key feature that we have provided is a detailed, advanced and schedulable preload cache mechanism that we think is missing so far in the WordPress community. Usually, all websites preload cache of all pages with many different plugins available that are doing this but the search filters are missed and that is where the users notice slowness occasionally. There are options in our plugin to preload a combination of search filters(our plugin will make sure everything is cached including deep search filters) with the scheduler in place so that you can let the plugin preload caches in a specified period only as well as you can set frequency this will let you preload cache for critical filters which otherwise would make your site look slow and the scheduler here helps in doing it in quite a time so that your frontend users don’t notice slowness while the preload cache is in progress. Here it is important to note that without our plugin users would need to create a detailed sitemap containing all search filter combination links which is a tedious task.

Extension DB Layer

If you have looked at the front-end benchmarks above it is quite evident that our solution made a huge difference after being applied to the stock installation. With our solution, there is a large jump in the performance and as said above it is critical to note that this performance gain can help hugely when your pages are not cached or when you need to rebuild caches quite frequently. Once again, merely with our solution, the performance is not at its best and so of course, you will need to keep using other caching and optimization plugins.

Extension Solution to Slow insert Speed

We have been working on solving this problem and have come up with a solution that goes by depending on 2–3 different architectures that users can choose from based on their site structure and content. If you are interested then visit the link section below there you will find a link to the extension. This extension helps boost insert speed by around 20x to 30x and helps keep the front end smooth.

Links

Demo

A free plugin(coming soon, contact us at our contact page if you want to know more about the timeline).

Extension DB Layer

Extension Solution to Slow Insert Speed

Everything about Diamond APIs Integration

Today, we all live in a place where the internet is leading future businesses and generations. Whereas, e-commerce platforms are the new way to lead the online shopping business. And having a business on the digital platform is not enough. What more requires, is an effective and competent site with the right tools to enhance your business. If you are looking for it then you have come to the right place.

Today, I will talk about the technologies that might bring your attention towards some innovation for the diamond/ jewelry websites industry, or if you ask me to be more specific than about diamond APIs that are the backbone of most online diamond trades/businesses.

(So, First of all, those who don’t have an idea for what is an API? And what exactly API Integration is?

API stands for Application Programming Interface. An API is a set of programming code that allows transmitting data between software to software or simply, a software intermediary that allows two applications to talk to each other. API Integration refers to this seamless connectivity that allows organizations to automate business processes, and enhance the sharing and embedding of data between various applications and systems.)

After getting the ideas of API and API integration. Let’s move further, there are problems for the integrations of diamond APIs, which users have faced and are still facing. After analyzing the problems we bring solutions in the form of a plugin called “Woo Choice Plugin”, it’s a powerful and effective plugin for diamond/jewelry websites. This plugin allows Diamond API integration. (Within this plugin there is an extension “Diamond API Integration Extension” built in a way that supports any type of Diamond API extensions )

Now, with the Diamond APIs integrations, Diamond APIs are important when you are running a diamond site. So, this plugin(Woo Choice Plugin) allows Diamond API integration with one of our extensions, which helps to integrate with the services (like “instant inventory services” of rapnet API) and allows more customization features. Generally, every single time we have to work with different types of API, which needs different types of integrations to integrate smoothly with the website backend and make things complicated, this extension has benefits also for these kinds of problems. We try to look for business-level solutions and built an extension that allows all the APIs to runs under our single extension “Diamond API Integration Extension”. This extension allows websites to integrate with any kind of API service. (note: To use “Diamond API Integration extension” you need to first install “Woo Choice Plugin”)

So How many APIs do we support in our single extension?

This extension supports the integration of all popular APIs like RapnetIDEX (International Diamond Exchange API), GEMFIND Diamond Link APIJewelCloud APIMID House of Diamonds APIPOLYGON Virtual Inventory API, and VDB (Virtual Diamond Boutique API).

This extension also supports Direct API Providers like Glow Star Diamond APIJB Diamond APISRK Diamond API, and many more. You can also send us a request to have us support the missing API.

Apart from that if your diamond inventory is coming in CSV through the FTP folder, then we support the FTP-based integration too, we provide this kind of back automation as well as ensure that your website and its servers stay healthy and run smoothly, using minimal resources, we provide scheduler tools that help you set the frequency of checking updates which also helps you ensure real-time update.

What’s More To Know?

There are some characteristics of our extension that optimize back-ends to help you run your site smoothly even if the APIs or your inventory is very large. Of course, it helps in cutting the costs of servers as well. If that is not enough we have two other extensions that are specifically designed to help run sites smoothly even with beyond 100K diamonds or other products.

To run rites smoothly, speed is an important matrix for any site to grow in a huge market with lots of competition to remain in popularity and for higher sales conversions. We put our best effort to give the user a seamless experience when speed matters most and without any compromises, in the most popular CMS, we offer our best solutions for the database layers with all kinds of optimization.

What about Demos? Is there a Demo API available for services (like “instant inventory services” of rapnet API) for diamond jewelers?

YES! It’s available and to get an experience with an optimized website you can visit our demo-01 or dem0–02 website. Otherwise, you can see the snap below in the first image, you can see diamond feed under filters in the grid/table view, that is where the diamonds fetched from any APIs will be published. UI is very simple to use and provides a perfect user experience, with the added benefits of full control over customization for website admins.

One of the important features here which you may like is the nice & efficient diamond feed pages with advanced filters with controls to customize them (which you can see in the below snapshot). These advanced filter tools make your work easier to create advanced ajax based woo-commerce product filters on any of your WooCommerce websites.

We also have plenty of features with different packages for Diamond/Jewelry websites to cover your requirements, you can visit here to choose your plugins packages. WooChoice plugin is easy to install, lightning-ready, and easy to use.

In addition to the API extension, we also have many other extensions that provide some of the best features and services for e-commerce websites which will give you and your customer the best level of experience. To know more about it click here.

We are compatible with any WooCommerce theme and compatible with all plugins.

9 Best WooCommerce Ajax Product Filter Plugins To Use In 2022

Ajax product filter is a type of WooCommerce product filter often used to filter products while searching for relevant products by different attributes such as Price, Colour, Shape, Size, etc. Ajax product filter goes the extra mile by providing relevant products with real-time filtration even without reloading the page.

There are many paid and free WooCommerce ajax product filter plugins available for online business owners.

But, I’ve listed the 9 best WordPress/WooCommerce ajax product filter plugins to help you choose the best suitable one for your e-commerce website.

Note: Plugins mentioned below are in no particular order.

YITH WooCommerce Ajax Product FIlter

YITH WooCommerce Ajax Product Filter is one of the popular ajax product filter plugins. It’s one of the most robust and powerful WooCommerce product addons. And user can also filter products by Category, Price, Size, Color, and so on by using the YITH addon.

In the free version, the product filter widgets support List, Dropdown, Color, and Label. They also provide a “Reset to all the applied filters” feature, and the reset button is also compatible with YITH WooCommerce Wishlist.

You can also create unlimited filters with lots of customization. Furthermore, you can place these filters on different products, shops, and category pages by using the YITH WooCommerce/WordPress search filter plugin.

YITH has both free and premium versions of their WooCommerce/WordPress search filter plugins, so there are limited features available with the free version.

Furthermore, you can make your website fully featured and functional by using the premium version.

Price:- $ 89.99/ year

Pros :

  1. Comes with live ajax search features.
  2. Support shortcodes. 
  3. There are many customization options available for search forms. 
  4. Comes with social media integration.
  5. Search results can be highlighted for certain products with badges or prices.

Cons :

  1. This plugin supports all themes, but the performance is not good with all of them.
  2. Advertisements in the admin dashboard.

Woo Choice Plugin is an Advanced WooCommerce Ajax Product Filter Plugin. This add-on offers a user-friendly interface with advanced and customizable features. WooChoice offers advanced and customizable UI/UX, so it’s highly recommended for users who’re looking for an advanced UI/UX customization filter.

It’s also compatible with Elementor. WooChoice Plugin is growing to perfection with the Diamond and Jewelry Industry still, it’s fully customizable and usable with many other categories(e.g. Clothing). So, you can use this ajax category filter WordPress plugin for any product inventory.

You can create unlimited filters for any different product pages, shop, or category page by using this WordPress ajax filter plugin. Woo Choice search filter plugin covers almost all the widgets for achieving any kind of layout style requirements.

For example  Slider, Buttons, Checkbox, Icons, Icons with text, and many more. So, you can create a filter with all these widgets with any type of combination and appearance setting.

Woo Choice Plugin covers almost all the filters which are mostly required for any site. This WooCommerce product addon offers advanced horizontal filters for free which is premium if considered filter-wise.

There is no other WooCommerce/WordPress search filter plugin that could offer this feature for free as other plugins are not evolved with Diamond and Jewellery industry filters.

Here is the fact to prove that Diamond and Jewellery has one of the best horizontal filters in the eCommerce industry.

It’s not that Woo Choice Plugin doesn’t have premium features. Apart from Woo Choice Plugin free feature, there are premium extensions, like Dependent Hierarchical Filters($32.00) and Custom Attribute Filters($39.00)

You can create Parent-Child filters with the help of Dependent Hierarchical Filters, and various filters like Delivery Date with Custom Attribute Filters. Visit here to know more about these premium extensions.

And we developed them to fulfill specific requirements like Diamond API Integrated- WooCommerce extension($150), this extension provides support and helps to integrate Diamond and Jewellery Inventory from a host. It’s also useful to manage inventory from 10K to over 100K with XLS or CSV files via FTP. 

To read more about Woo Choice Plugin features visit here.

Price:- Free and Paid

Pros : 

  1. Availability of all the necessary features for free.
  2. Comes with Live ajax search features.
  3. Powerful backend.
  4. Elementor supported.
  5. Elegant UI/UX.
  6. Comes with a perfect user experience.

Cons :

  1. Without Woo Choice Plugin, premium extensions will not work
  2. Not all features are free
Advanced Ajax product filters

Advanced Ajax Product Filter is also among the top advanced WooCommerce ajax product filter plugins for e-commerce websites. This WooCommerce product addon offers drag and drops features with many advanced and customizable features.

You can create filters for your product by Category, Attributes, Custom Taxonomies, Price, and Tags. It provides different filter types like checkboxes, dropdown menu, radio buttons, range slider, tag cloud for tags, checkboxes with color or image.

You can also customize widgets. It also allows placing unlimited numbers of Filter options. It offers Ajax Filters, pagination, and sorting. They also have more features with free and premium versions.

Price:- $44 for a Single Site

Pros :

  1. Set up product filters on your WooCommerce store with filters by categories, tags, attributes, price, and even custom taxonomies.
  2. Different field types such as checkbox, radio buttons, dropdown, range slider, etc.
  3. Multiple layout options including slider color and image.
  4. Smooth page loading.

Cons :

  1. The Premium version is a little expensive.
Themify WooCommerce Product Filter

Themify is a powerful and effective WooCommerce ajax products filter plugin. This WordPress ajax filter plugin allows users to filter products by categories, attributes, price, tags, and so on. Every feature in this WordPress search filter plugin is available for free.

However, this WordPress search filter plugin is designed with features to help make your website better. And, that includes features like live search results, drag and drop form builder, multiple filter combinations, and so on.

Moreover, Drag and drop builder helps easily create new filters and apply them instantly without reloading the page. Additionally, you can add an Apply Filters button. And these filters are available in both horizontal and vertical layouts.

Themify WooCommerce ajax product filter plugin provides a lot of customization to create a filter for free.

Pros :

  1. Easy and quick to create Filters.
  2. User-friendly Interfaces.
  3. Comes with a Drag-drop form builder.

Cons :

  1. Limited features
Ultimate WooCommerce Ajax product FIlter

Ultimate WooCommerce Ajax Product Filter plugin is easy to set up and simple. You can easily set it up with simple WooCommerce filter widgets and shortcodes.

It also filters products by color, size, attributes, category, and tag including smart product search and smart table format/view.

Also, it provides filter products by Color, Size, attributes, category, and tag including a smart product search and smart table format/view.

So, the WooCommerce product add-on comes with both free and premium features. Whereas, in the premium features, they offer many advanced features like Display filter attributes under shop page thumbnails (e.g. adjacent to the rating stars), Visual indication with details for each product without visiting the product page. Specific layout options for filters (color, size, attributes, categories, and tags). The additional feature of price slider and attributes in the table format. Customize the filtering functionality and labeling options.

Price:- $39 for single-site, $119 for 5 sites, and $199 for 10 sites.

Pros :

  1. Simple to use.
  2. Easy and quick to create Filters.
  3. Comes with live ajax search features.

Cons :

  1. High premium rates.
Search & Filter

Search & Filter is a simple filter plugin. And, it provides features to create general filters for your website.

This plugin is used to create product filters by Category, Tag, Custom Taxonomies, Post Type, Post Date, and combine search also. Also, it provides input types for filters as dropdowns, checkboxes, radio buttons, and multi-selects. In the free version, they provide only basic features. And in the premium version, they provide many features and where you can customize your websites with many other features.

It can work without installing WooCommerce, but it’s more compatible with WooCommerce.

Price:- $20 for single-site and $75 for Developer

Pros :

  1. The free version offers a simple, quick filtering solution.
  2. A new user who wants simple filters can be used easily.

Cons :

  1. A limited number of features in the free versions.
  2. Many features are available in the premium versions.
  3. Advanced features like AJAX, multiple forms, the drag-and-drop, and others, will come in the pro version.
WOOF products filter

WOOF Ajax Category Filter WordPress Plugin is one of the best WordPress search filter plugins available. And, it also comes in the list of Advanced Ajax Category filter plugins for WordPress and WooCommerce.

It provides product filters by category, custom taxonomies, attributes, price, and tags, and even with shortcodes. Furthermore, this addon provides filter input types like Drop-Down menu, Radio Buttons, Radio buttons in the drop-down, drop-down, multiple drop-down, and checkbox. The exciting part is all these features are free to use.

In their premium version, they also provide inputs as color, image, label, hierarchy drop-down, attributes/taxonomy range-slider, and checkbox buttons in the drop-down, and many more. So with all these features, you can make your sites fully accessible while searching and filtering products.

This feature provides a smooth user experience, and this is how this plugin made it to our list of best WooCommerce Ajax Product Filter Plugins.

Price:- Regular license $39 and Extended license $139.

Pros :

  1. Products shortcode
  2. Comes with Live ajax search features
  3. Step by step products filter
  4. Dynamic products recount

Cons :

  1. Many Advanced Features are available in the premium version.
  2. The issue with supporting other plugins.
WooBeWoo Ajax product filter plugin

WooBeWoo is an advanced WooCommerce ajax product filter Plugin. It comes with easy setup, customization, and is also compatible with Elemontor.

It provides Filters by price, price range, categories, tags, and more. Also, their plugin is already integrated with WooCommerce options and uses the product’s taxonomy elements( e.g attributes and categories). For filtration, the plugin uses data from WooCommerce products tab settings. And, to set up nothing specifically, it is available there. They provide many features in the free version but they also have a premium version.

It provides Filters by price, price range, categories, tags, and more. Their plugin is already integrated with WooCommerce options and uses the product’s taxonomy elements( e.g attributes and categories). For filtration, the plugin uses data from WooCommerce products tab settings. And, to set up nothing specifically, it is available there.

There are many features that come with a free version, and you can always upgrade to premium to get more features.

Pro Price:- One Site – $49, Five Sites – $99, Unlimited Sites – $199

Pros :

  1. Easy to set up and customize.
  2. Product table with variations.
  3. Filter category, tags, attributes, price, and custom taxonomy.
  4. Compatible with Elementor.

Cons :

  1. Many advanced features are available in the premium version.
JetSmartFilters Ajax filter

JetSmartFilters is an ajax category filter WordPress plugin that is easy to set up and use but it’s not free. It also comes with Elementor compatibility. There are many types of filter widgets available like CheckBoxes, Select, Range, Check Range, Date Range, Radio, Search, Rating, and many more. All search filter widgets have extensive style and easy-to-use.

Note that you will also need JetEngine or JetWooBuilder plugins to use JetSmartFilters.

Note that you will also need JetEngine or JetWooBuilder plugins to use JetSmartFilters.

Price:- $24 per year for a single site,  All-inclusive set from $130

Pros : 

  1. Easy-to-use
  2. Easy Customizable
  3. Supports Elementor

Cons :

  1. Poorly configured settings
  2. Tricky Visual filter

Visit the link for some of the best filters plugins for the WordPress and WooCommerce website


0