Problem with woocommerce variations

You can increase the variations threshold from the default 30 so that all the variations data is loaded in the page, then there is no need for that ajax call to find out if a particular variation exists. Will be a better customer experience. The dropdowns will be correct.

But that’s 8,000+ variations, so it would be a huge page to download. And 8,000 variations would be very difficult in admin as well. AT 50 variations per run, that’s 160 runs. I feel unwell just thinking about it.

Consider restructuring your product or making it as several products, and look at add-on or product-options plugins so some attributes can be removed, so reducing the number of variations to a more manageable number.

Hi

My problem is not with increasing the variations my problem is excluding/hide product that doesn’t go with the first attribute.

When a customer selects quantity, for example, if the customer select 1 bottle the second attribute should exclude/hide anything that doesn’t go with bottle 1 as this is normal behaviour.

No, I didn’t say increasing the number of variations, I said increasing the variations threshold.

The variations threshold is normally 30. If you have less variations than the threshold, all the variations data will be loaded in the user’s browser at the same time as the page. The code on the page will make sure that unavailable variations cannot be selected. This is the best experience for the user.

If you have more variations than the threshold, then the available variations are not loaded at the same time as the page. This keeps the page smaller and keeps page load time low. However, all possible combinations can be selected. Then an ajax call is made so the page can check with the server to see if that combination is available. If its not, the customer gets the unsatisfactory message that the variation is not available.

So, to ensure only available variations can be selected, you can increase the threshold to more than the number of variations. This is better for the user, but the downside is the page gets bigger at first load. This might be a problem for users on slow connections who may just give up waiting for the page to load and go somewhere else.

Its a trade-off.

You can increase the variations threshold using this snippet in functions.php for your child theme:
https://gist.github.com/mohsinoffline/f06c66259e667d6b16bb

I’ve had feedback from people who have increased the threshold to 50 or maybe 100 and have found the page load time is still acceptable. But you have 8000+ variations, so that’s never going to be satisfactory.

Also, Woo only allows us to make 50 variations in one run. So 8000+ variations would be 160 runs, and that’s not practical from a shop management perspective. We can only see 15 variations at one time on the admin product page, ie 500+ page-fulls.

So I think the way forward for you is to restructure the product as two or more products, or you could use an add-on or product-option type plugin to expose one or more of the attributes as radios or checkboxes, and this will reduce the number of variations to a more manageable number.

Thank you so much, it’s working fine now