Complex Variations, please help.

Hello @bathroo,

Such an impressive website. Well designed! There are a couple of things to address here.

1. WooCommerce will not show/change price/qty/SKU after certain number of variations in the front-end. This simply because, when user is clicks on a particular product Woo does pre-load certain number of variation. This is obvious, because, when you’ve let say 200 different variations, it may take awhile to preload all of them at once. I’m not sure the exact, but I guess the number of pre-loaded variation is something like 30.

2. But fortunately, you can override the number by adding the below code on your themes functions.php. Alternatively, you can use this plugin in order to add safely.

/**
 * Fix for issue where too many variations causes the front end to not pre-load
 * all variations and rely on AJAX.
 */

function custom_wc_ajax_variation_threshold( $qty, $product )
{
    return 200;
}
add_filter( 'woocommerce_ajax_variation_threshold', 'custom_wc_ajax_variation_threshold', 10, 2 );

As I mentioned above, There’s a caveat to the above code and that is performance. This may slowdown your website. So use with caution.

Hope this helps,
Naz.

Hello @bathroo,

Such an impressive website. Well designed! There are a couple of things to address here.

1. WooCommerce will not show/change price/qty/SKU after certain number of variations in the front-end. This simply because, when user is clicks on a particular product Woo does pre-load certain number of variation. This is obvious, because, when you’ve let say 200 different variations, it may take awhile to preload all of them at once. I’m not sure the exact, but I guess the number of pre-loaded variation is something like 30.

2. But fortunately, you can override the number by adding the below code on your themes functions.php. Alternatively, you can use this plugin in order to add safely.

/**
 * Fix for issue where too many variations causes the front end to not pre-load
 * all variations and rely on AJAX.
 */

function custom_wc_ajax_variation_threshold( $qty, $product )
{
    return 200;
}
add_filter( 'woocommerce_ajax_variation_threshold', 'custom_wc_ajax_variation_threshold', 10, 2 );

As I mentioned above, There’s a caveat to the above code and that is performance. This may slowdown your website. So use with caution.

Hope this helps,
Naz.

Thanks for you reply! At the moment it’s not a combination limit issues but more a functional one.

Do you think a composite product plugin would solve this better?

Well, Yes. A composite plugin makes sense when you have two products that you wish sell together. However, the same given in the blue space site can be achieved just with Woocommerce attributes out of the box. Let me know if you want me to show an example on this.

Naz.

Hello everyone,

Please refer to this documentation for more details about the number of variations on your site (the default is 30):
https://woocommerce.com/document/variable-product/#functionality-behavior-for-more-than-30-variations

For more information about how to implement the code provided previously by @nazreenexe please check: How to add custom code.

Let us know how it goes.

Yes, this will end up creating hundreds of variations and it’s going to be difficult to manage.

Do you think it’s worth using one of those combination plugins because as you can see on that website customers build the product as they go?

I’ll create a shaving cabinet product now using the traditional method and post the link to get feedback and would love thoughts on how it can be done better in WordPress so we can be better than Shopify (that website runs on Shopify)

Hi there ??

It sounds like the Composite Products plugin might do the job for you. Here is a direct link to this plugin:

https://woocommerce.com/products/composite-products/

For Pre-Sales questions, please contact us at:

https://woocommerce.com/contact-us/#sales-form

From there, click on the tab “I have a question about a specific extension or theme I’d like to purchase.”

I hope this helps.

OK, I’ve uploaded it. I found creating the attributes in the backend then exporting it to excel then importing with changes the fastest way to make the changes. Can you please have a look and give feedback on how it can be better https://bathroomhut.com.au/marquis-frameless-shaving-cabinet/. I’ve always been a WordPress fan, not a Shopify fan and I want to beat them.

Hi @bathroo

I found creating the attributes in the backend then exporting it to excel then importing with changes the fastest way to make the changes.

Great job! The product is set up well and is working normally when changing variations.

give feedback on how it can be better https://bathroomhut.com.au/marquis-frameless-shaving-cabinet/. I’ve always been a WordPress fan, not a Shopify fan and I want to beat them.

If you’d like to add more functionalities then you can let us know and we’ll try to offer suggestions/solutions accordingly. Also, if you need help with troubleshooting – we’re here for you. ??

Cheers!

OK, I’ve created the variations, please see here https://bathroomhut.com.au/marquis-frameless-shaving-cabinet/

I’m ok doing this now but I’ve run into a major issue which is page speed. The load time is VERY VERY slow and slow load time impacts conversion, big time.

From the research, I’ve done using options could help the speed but some of the vanities, for example, any variation change will change the price. I’m pretty sure a product with 2000 variations in WordPress will die or load time will be way over 5 seconds.

What are our options here?

• This reply was modified 2 years, 12 months ago by bathroo.
• This reply was modified 2 years, 12 months ago by bathroo.
• This reply was modified 2 years, 12 months ago by bathroo.

I found an example of the complexity I need to implement https://www.idealbathroomcentre.com.au/products/marquis-cove-wall-hung-vanity

I think variation will kill my site? any suggestion is greatly appreciated.

Question on the composite plugin. When you have a lot of options to compose for a product, does it slow the site down like variations?

Hi @bathroo

I’m ok doing this now but I’ve run into a major issue which is page speed.

As a general guide for slow sites, please refer to these docs below for performance tips and tricks:

* Troubleshooting a Slow Site
* Why is My WooCommerce Site Slow? And How To Fix It

Question on the composite plugin. When you have a lot of options to compose for a product, does it slow the site down like variations?

We have separate support channel for customers of Premium extensions.

Please contact us at:
https://woocommerce.com/contact-us/#sales-form

From there, click on the tab “I have a question about a specific extension or theme I’d like to purchase.”

Best,

Hi Berg, the site is optimised but the technical architecture around large variation is sub-optimal so my question is especially around how we technically solve it. Any help would be great.

Hi @bathroo,

I suggest getting feedback from your hosting company regarding the appropriate resources to have for what you want to accomplish.

Generally, you’d want to increase the WordPress memory limit and PHP max input vars values. Also, having the store set up on shared hosting isn’t ideal, although it’s a cheaper option.

Best regards.

I’m not sure what PHP max input vars have to do with Database reads and the slow SQL to retrieve variations in Woocommerce? for example, the SQL which is fired off to retrieve variations is a separate query for

each

variation and is sub-optimal.

If someone has 1000 variations with is 1000 separate database calls. How can this be optimised?