WooCommerce – Activate “Used for variations” for All Product Attributes at Once

Use all your WooCommerce product attributes to create variations by activating the “Used for variations” option in bulk.

Imagine your customer asks you to edit the 5,000 WooCommerce products by the end of the day. He wants you to activate the “Used for variations” option for all product attributes.

Surely it is an idea that just by imagining it will stress you out since it will take you a lot of time to do it. You will have to open the products one by one, activate the option, save changes, close the product, open another product, edit the option, save changes, close the product, and so on until you finish the 5k products.

We’re sure you don’t want that. That’s why we want to show you how to activate the “Used for variations” option for all your product attributes at once using the WooCommerce Products Spreadsheet plugin.

This is a great tool that simplifies your store management by displaying and allowing you to edit your products on a spreadsheet.

Once installed and activated, open the spreadsheet by going to Sheet Editor > Edit Products.

1- Open the “Bulk Edit” tool

This is an easy-to-use tool that allows you to edit thousands of products in just some minutes, saving a lot of clicks. You can save thousands of hours editing products in bulk. In this case, you’ll be able to activate the Used for variations option for all product attributes at once.

2- Activate “Used for variations” for all product attributes

After opening the Bulk Edit tool, you need to select the following values to edit the Used for variations option for your product attributes.

You’ll have these two options.

Option 1: Activate “Used for variations” in all attributes

• Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
• What field do you want to edit: Product attributes
• Select type of edit: Change attribute settings
• What settings do you want to change: Used for variations
• New value: Yes
• What attribute do you want to edit: All
• Click on Execute now to apply the changes.

Option 2: Activate “Used for variations” in specific attributes

• Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
• What field do you want to edit: Product attributes
• Select type of edit: Change attribute settings
• What settings do you want to change: Used for variations
• New value: Yes
• What attribute do you want to edit: You can edit the product colors by choosing pa_color, the product sizes by pa_size, etc.
• Click on Execute now to apply the changes.

That was easy!

After these really simple steps, you’ll have enabled the “Used for variations” option for all your product attributes in WooCommerce. It’s really simple because you need to do that process once only and with that single process, you’ll edit all your products, no matter how many they are.