January 21 2019

One, ten, one hundred, one thousand products. How to understand the limit of products manageable by WooCommerce.

How many products can WooCommerce handle? Here are some practical considerations and a real case.

Managed WooCommerce Hosting

From active users in the various WordPress groups on Facebook, as well as among the various email and telephone requests that we usually receive, one of the most popular questions we are asked is the one regarding the number of products that WooCommerce can manage.

It sounds something like this: "I should do an ecommerce with n-thousand products, is WooCommerce okay?"
Another variation to the question sounds like: "I should do an ecommerce with n-thousand products. Can I use WooCommerce or should I use Magento or Prestashop?"

Following on social networks the most colorful answers of more or less skilled users with each his opinion. Among those who recommend Magento because they use Nike, to those who do not recommend Magento why There is an article online that also says WooCommerce can manage stores with over half a million products.

As a rule, these threads on WooCommerce in social media always end up in wine and tarallucci with banal and childish comments that even go down in flame with mutual insults, and usual "You don't know who I am."

Taking for granted that such conversations don't help anyone, we thought about writing this article which does not necessarily want to be absolute truth, but at least a substitute for personal considerations and technical experiences derived from those who from 2005 to 2019 had the opportunity to do systems engineering for companies that work at high levels on Magento, as well as other companies and developers who are more or less experienced (or absolutely novices and "runaway") with the creation of WooCommerce stores.

We personally believe that an ecommerce platform should be chosen especially for the features it offers rather than relying on the number of products it can handle.
For example, if we needed to manage a multistore type shop (where for example each store responds to a different domain or even where each store is verticalized only on a certain product, for example one for glasses and one for shoes) surely Magento or at least Prestashop would be solutions ready to meet our needs, while a WooCommerce should be extended and integrated with additional plugins with the relative pros and cons.

The fact remains that WooCommerce is able to offer excellent potential to those who have the desire to develop profitable ecommerce as we can see for example from this screenshot of one of our customers:

However, regardless of the irrevocable decision of wanting to use WooCommerce, let's try to answer the simple question above: "How many products can WooCommerce handle?"

Read in this way, the question may sound misleading, as the quantity of manageable products should be at least inherent to the pleasantness of navigation, the fluidity of the same and in short, give a very nice and comfortable user experience.

So that a concept is clear, no one is interested in having an ecommerce with 100 products if the navigation is slow and takes 10 seconds for each page to load.
Otherwise, it could be if the loading time is less than 2 seconds even in the face of 1000 users connected simultaneously.

Strictly speaking, we therefore try to make considerations that are in line with the expectations of the client but above all of the end customer who may be comfortably browsing the site while sipping a hot chocolate in cheerful company, perhaps from his new iPhone.

The plausible answer therefore to those who ask us "can a WooCommerce store handle 100 products with fluidity and a satisfying user experience?" would be : "Yes, but under certain conditions."

If we take the site for example intershop (https://www.inter-shop.gr/) we can say that this ecommerce developed with WooCommerce could be a clear example of how a WooCommerce can handle around 170 products without any problems.

Intershop.gr with its 160 thousand products.

InterShop is an electronic shop that imports and markets products from various Greek companies. Their online store is based on the WooCommerce platform and has over 158.000 products which vary in categories like electronic gadgets, electrical items, automobile tools, etc. The Inter store runs out of Greece and caters to consumers all over the world. Although, shipping costs vary from country to country.

Their website inter-shop.gr is based on Flatsome WordPress Theme. According to statistics from WPThemeDetector, this WordPress theme from UXThemes is ranked # 13 in the list of top WordPress themes. FlatSome is a highly customizable theme, very well designed primarily for WooCommerce users.

According to WhoIsHostingThis, Inter Shop is using CloudFlare which is popular for its speed and performance related services thus making it a reliable web performance and security company and giving us more reason to believe that WooCommerce is easily scalable if you have adequate hosting support and lean and well done application development.

Inter Shop uses W3 Total Cache, a plugin that helps improve website speed and performance, thus giving the user a better overall experience of the site with loading times of less than two seconds.

So once again the answer is yes. Yes, it is possible to manage large stores with WooCommerce.

Why does it go slow with just a few products?

One of the objections of those who do not recommend the use of WooCommerce is that having tried and tested the use on a site with few products (even a few hundred), the experience was so slow, negative and traumatic that WooCommerce was considered a choice. very bad (even not recommended) for all those who had decided to use it. Obviously they did not ask themselves in the least if everything had been done correctly and if the cause (or causes) of a bad final result there could be more reasons attributable to them.

Because there is a big difference in noting that a site built with WooCommerce can be tremendously slow, and also knowing how to explain why. Throwing out the cousin's made WooCommerce are all good, bringing the site to analysis and profiling tools such as New Relic and understanding the bottlenecks (and perhaps even solving them) is a matter of course. Just as it is few to choose a hosting like ours which provides adequate technologies to host a WooCommerce site. Starting from a correct mounting of the partitions, to a correct tuning of the system and services, to the use of multiple cache layers (Redis.io, Memcached, Zend OpCache, W3 Total Cache, Varnish, NGINX Cache), to the use of InnoDB tables rather than the antiquated MyISAM in a global context where performance is really everything.

In most cases, however, a good system tuning even with all the precautions in the world and the best good will, it will not be able to solve structural problems derived from themes or plugins "Killer Killer" that should be effectively prohibited on WordPress as they overload the DB or processes with queries, making everything extremely slow and unusable. A good system tuning and a good hosting with good caches may perhaps lower the initially unsatisfactory user experience from 10 seconds to 3. A good debug with an application resolution (perhaps by deleting or replacing a plugin), on the other hand, can eliminate the problem by allowing a loading in just 1 second.

Slow plugins. An example with WPML.

One of the examples we always mention when a client decides to plan the translation of his current site into languages ​​other than the current ones is that of don't use WPML.

However well publicized and widespread, WPML (the best-known plugin for WordPress site translations) it certainly can't be said that it shines for performance. In fact, by implementing personal solutions to translate the various languages, such as proprietary tables, multiple joins and so on, the only result that is obtained (in addition to the obvious multilingual translation of the WordPress and WooCommerce pages) is that of significantly slow down page loading speed.

While it is true that on a fast site increasing the loading speed to 100% can mean having a site that uses WPML that still loads in 2 seconds instead of 1, on slower sites it can mean that a site loads in six seconds instead. of 2 or 3 and this is not tolerable.

A real experience we had with one of our clients was to give a really important frontend optimization, bringing the loading from about 6 seconds to less than 1 as the user not logged in was served the previously generated page in cache. However, the problem remained when the user (for example a retailer with his reserved price lists) decided to log in and therefore browse without benefiting from the static Varnish cache. At that point all the server optimization failed and the site was once again irremediably slow.

What to do then?

The site was simply still in one language and while using WPML with Italian as the main language it still had not been translated into the other languages, so the wisest and most sensible solution was to extrapolate all the articles, pages and products from WPML and insert them outside of it for later disable and finally delete WPML. 

Here is where the site is back lightning even for logged in users.

The only viable alternative to the very slow WPML is Multilingual press (https://multilingualpress.org), a choice also recommended by other Performance Based hosting such as WP Engine, as its structure is based on the feature WordPress native multisite (instead of the spaghetti code and proprietary tables of WPML) allows you to get the maximum performance and functionality without inventing strange and very slow tricks as does WPML, now at the end of a dishonored career.

It costs about $ 200 a year for each single site, but you sure don't screw up your guts like WPML does.

Obviously we wanted to focus on WPML, because it is common practice to notice a noticeable slowdown at the time of translation into the language, but it is not the only plugin capable of killing ecommerce by making you slow as snails. As a rule, all those who make use of AJAX calls to the backend are advisable to avoid, as well as all those who have non-primary functions and are left unpunished to massacre the DB with queries.

Other negative factors for a performing WooCommerce store?

Other negative factors for a performing WooCommerce that may not be able to handle a good number of products or a good traffic spike are:

Unsuitable shared hosting solutions.

What would be the sense of lending economy and thrift in spending 100 euros a year rather than 100 euros a month for an optimized managed and managed dedicated server if in fact your business is worth hundreds of thousands of euros a year or a month? It seems absurd but it has happened to see companies with slow sites in shared hosting with turnover of a few hundred thousand euros a year that did not want to switch to dedicated servers because according to the administrator it was too expensive. In this case, change jobs and close the business. Go to the beach rather than pretend to be an entrepreneur.

Lack of SSD or nVME disks in RAID.

Always inherent to the point mentioned as "Unsuitable shared hosting solutions", too the lack of adequate SSD or nVME disks can cause slowdowns in reading and writing with an increase in latencies such as to create important bottlenecks and a general slowness. It is not even necessary to dwell too much with words or technical virtuosity, just take a look at the following benchmark to understand the importance of an SSD disk or better nVME rather than the classic mechanical HDD Hard Disks.

Lack of adequate software technologies.

Let's be clear once and for all, if you think hosting means buying an account with CPanel and Plesk from iron (hardware) vendor companies without doing any software tuning and optimization, unfortunately for you they are scamming you.
To seriously host a WooCommerce project, you need a stack based on these software components: NGINX with http / 2, PHP-FPM with Zend OpCache, REDIS.IO and Memcache together with Varnish in reverse proxy and an adequate configuration to work in synergy with WordPress and WooCommerce. If these points are not satisfied and your supplier is not able to provide you with these services, run away because your supplier is not able to do his job very well or to push your store to the maximum. The names of the software mentioned above are not our exclusive recipe because "it is beautiful and we like it", but the recommended requirements and best practices of all high performance hosting.

A real test of one of our customers with over 10 thousand products in WooCommerce

Wanting to stay in reality and not just tell what other ecommerce that we have seen online and documented in this article with our research do, we wanted to give a practical demonstration of an ecommerce made with WooCommerce that has over 10 thousand products published.

Unlike the usual clichés that WooCommerce is only suitable for small sites and with few products otherwise it starts to be extremely slow, in the video you can see with your eyes the fluidity of navigation of a WooCommerce which uploaded over 10 thousand products.

 

https://youtu.be/SF9UxqlztpQ

 

Conclusions

We can therefore conclude this overview on the possibility of being able to build large ecommerce with WooCommerce, with the affirmation that WooCommerce gives the possibility to do it in an efficient and elegant way, but it is up to both the developer and the system engineer to make careful choices so that all the problems under construction that would penalize performance, and (as far as the system engineer is concerned) to implement all the best practices by sizing the best ad-hoc solution for the project both on the hardware side and on the software side.

If you need to evaluate the possibility of optimizing your site and increasing the speed considerably, do not hesitate to contact us.

 

Do you have doubts? Don't know where to start? Contact us!

We have all the answers to your questions to help you make the right choice.

Chat with us

Chat directly with our presales support.

0256569681

Contact us by phone during office hours 9:30 - 19:30

Contact us online

Open a request directly in the contact area.

INFORMATION

Managed Server Srl is a leading Italian player in providing advanced GNU/Linux system solutions oriented towards high performance. With a low-cost and predictable subscription model, we ensure that our customers have access to advanced technologies in hosting, dedicated servers and cloud services. In addition to this, we offer systems consultancy on Linux systems and specialized maintenance in DBMS, IT Security, Cloud and much more. We stand out for our expertise in hosting leading Open Source CMS such as WordPress, WooCommerce, Drupal, Prestashop, Joomla, OpenCart and Magento, supported by a high-level support and consultancy service suitable for Public Administration, SMEs and any size.

Red Hat, Inc. owns the rights to Red Hat®, RHEL®, RedHat Linux®, and CentOS®; AlmaLinux™ is a trademark of AlmaLinux OS Foundation; Rocky Linux® is a registered trademark of the Rocky Linux Foundation; SUSE® is a registered trademark of SUSE LLC; Canonical Ltd. owns the rights to Ubuntu®; Software in the Public Interest, Inc. holds the rights to Debian®; Linus Torvalds holds the rights to Linux®; FreeBSD® is a registered trademark of The FreeBSD Foundation; NetBSD® is a registered trademark of The NetBSD Foundation; OpenBSD® is a registered trademark of Theo de Raadt. Oracle Corporation owns the rights to Oracle®, MySQL®, and MyRocks®; Percona® is a registered trademark of Percona LLC; MariaDB® is a registered trademark of MariaDB Corporation Ab; REDIS® is a registered trademark of Redis Labs Ltd. F5 Networks, Inc. owns the rights to NGINX® and NGINX Plus®; Varnish® is a registered trademark of Varnish Software AB. Adobe Inc. holds the rights to Magento®; PrestaShop® is a registered trademark of PrestaShop SA; OpenCart® is a registered trademark of OpenCart Limited. Automattic Inc. owns the rights to WordPress®, WooCommerce®, and JetPack®; Open Source Matters, Inc. owns the rights to Joomla®; Dries Buytaert holds the rights to Drupal®. Amazon Web Services, Inc. holds the rights to AWS®; Google LLC holds the rights to Google Cloud™ and Chrome™; Microsoft Corporation holds the rights to Microsoft®, Azure®, and Internet Explorer®; Mozilla Foundation owns the rights to Firefox®. Apache® is a registered trademark of The Apache Software Foundation; PHP® is a registered trademark of the PHP Group. CloudFlare® is a registered trademark of Cloudflare, Inc.; NETSCOUT® is a registered trademark of NETSCOUT Systems Inc.; ElasticSearch®, LogStash®, and Kibana® are registered trademarks of Elastic NV Hetzner Online GmbH owns the rights to Hetzner®; OVHcloud is a registered trademark of OVH Groupe SAS; cPanel®, LLC owns the rights to cPanel®; Plesk® is a registered trademark of Plesk International GmbH; Facebook, Inc. owns the rights to Facebook®. This site is not affiliated, sponsored or otherwise associated with any of the entities mentioned above and does not represent any of these entities in any way. All rights to the brands and product names mentioned are the property of their respective copyright holders. Any other trademarks mentioned belong to their registrants. MANAGED SERVER® is a trademark registered at European level by MANAGED SERVER SRL, Via Enzo Ferrari, 9, 62012 Civitanova Marche (MC), Italy.

JUST A MOMENT !

Would you like to see how your WooCommerce runs on our systems without having to migrate anything? 

Enter the address of your WooCommerce site and you will get a navigable demonstration, without having to do absolutely anything and completely free.

No thanks, my customers prefer the slow site.
Back to top