WooCommerce store with large amount of variations

WP Intense Q & ACategory: Scalability ProWooCommerce store with large amount of variations
Alex Murphy asked 3 months ago

Hi Dave, I watched over you Wordcamp Brighton video (from some years back) and i've read a few of your blog posts in relation to Woocommerce sites with products with tons of variations. Just thought i'd reach out to you. My client is an Apple reseller, we built his site using WP / WC and we are encoutering the same issue. Once a prodyct gets over 500+ variations it's starting to slow down. We have built out 1 product (Mac Pro) that have around 12000 variations and we used object caching and this worked in terms of making the page load - although still pretty slow (https://www.wearesync.co.uk/product/apple-mac-pro/). So i had a few questions really. Do you have any tips in speeding up these processes without caching? Not sure if it's of any help but all the main mac products don't appear on any 'shop' type pages so it's onlt the main WC product pages we are concerned about. I noticed you have a plugin for scalabilty - will this help at all? It does mention: WooCommerce runs some slow code to count the variations on the product detail page. By disabling this, it forces some Ajax code to run when the user clicks the variation option which is far faster. This sounds promising. We are also currently using WP Rocket for general site caching etc. I'm sure your a busy guy so any of your time is grealy appreciated. Thanks, Alex

1 Answers
Dave Hilditch Staff answered 2 months ago

I’m still working on a major fix for product variations which will be built into Scalability Pro, but as yet it’s still not complete. The current speed boost for variations is fairly limited in Scalability Pro.

One thing I would highly recommend is if there’s any way you can avoid having this many variations then do so. For example – each variation has its own image and its own price – if you have some selectable options which don’t actually change the price then change them to product options (many plugins for this functionality) instead of product variations.

Similarly, if you have any variation options which do change the price but change it consistently then you can use Product Addons here – for example, if Medium adds £10 to the price and Large adds £25 to the price then you could use Product Addons (and some other product options plugins too) instead of variations.

The variations multiply quite quickly – the difference between having 6 options and 4 options configured in your variations is significant. For example, if each configurable option has 5 choices, then with 4 of these you’d have 625 variations but with 6 you’d have 15,625 variations.

Black Friday!

This is the only time of year when we have our biggest discount ever!

Use coupon code BF2020 for a massive 50% discount.

Get 50% off any plugins or plugin packs! Use coupon BF2020. First 100 only.

We use cookies

We use cookies for various things on our site, including our on-site chat bubble (if you use it), our comment forms (if you use them) and for session handling (if you log in).

Other than that, we use cookies to identify where traffic came from to help us understand which traffic turns into sales, we use a cookie for Google Analytics traffic analysis and we use a cookie to customise adverts for our own products we think you'll be interested in.

You can read more detail in our privacy policy page. Please click 'Accept' or 'Decline' to continue.