Hi @lhtan,
That is a great question. While WooCommerce doesn’t have a built-in limit on the number of variations you can have, loading them all is an expensive operation for the server. It takes lots of resources to construct the list of variations.
Here are a few ways you can speed this up.
Thread Starter
lhtan
(@lhtan)
Hi Three Sons,
Thanks for the advice.
1. I’ll try to increase the server resources as much as I can for the moment.
2. Due to the nature of business, I can’t split the product into different main variations as I think the user shopping experience might not be great. For example, one of the product “Flyer”, people would want an immediate comparison of prices for different size and finishing with simple clicks there.
3. I did try to use add-ons, but sadly, my products cost from suppliers comes in the form of excel and csv, I don’t have the formula to put them into product add-ons as there are many elements affecting the price changes.
Is it possible for the product page not to load the whole list of variable product CSV at one go? Example, the website first load up the product page in the fastest time possible. Then, only collect and read the CSV list after the user has selected the attributes they wanted. I believe that will be able to split the loading into 2 time, user wont feel the slow loading speed.
Plugin Support
John Coy a11n
(@johndcoy)
Automattic Happiness Engineer
Hi @lhtan
If you don’t have to track inventory for each variation combination than you can use Product Add-ons, however, any other changes to the number of variations that are loaded will require customizations.
We recommend one of the services listed on this page who can assist with any custom development work:
https://woocommerce.com/customizations/