WooCommerce – How to Create Product Variations Faster

Product variations are really important. They give your customers the possibility to order exactly what they want: the color they want in the size they want it, for example.

However, if you want to create product variations for a hundred products, it’s going to take you some time, or you’ll possibly have to use any PHP snippet you found on Google. But please don’t worry.

In this quick tutorial, we want to show you how to create product variations in seconds and how to edit them. For this, we’ll use the Sheet Editor Products Spreadsheet plugin.

Install the plugin

Sheet Editor Products Spreadsheet is designed to simplify your life by helping manage your WooCommerce store in an intuitive spreadsheet. All you have to do is to use some clicks and fields to apply all kinds of changes to thousands of your products.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Once installed and activated, go to Sheet Editor > Edit products to open the plugin. You’ll see a spreadsheet containing all your products and their complete information.

Video Guide

Text Guide

With WP Sheet Editor, you don’t have to use any codes to create hundreds of variations for hundreds of products. You can do it in seconds.

Just follow these simple steps.

1- Convert the products from simple into variable

You need to convert all the products into variable. For that, you need to open the Bulk Edit tool, which is on the toolbar.

After that, open the Search tool by selecting I want to search rows to update.

Once there, you can filter the products by keyword, status, category, attribute, tag, etc.

  • Contains keyword: Enter any keyword to filter all posts containing it on their titles.
  • Status: Published, Draft, Private, etc.
  • Enter tags: Enter any category, attribute, tag or shipping class.

Once you decide how you’ll filter your products, just click on Run search to filter them.

After that, you need to select these values to convert the products from simple into variable:

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to edit: Type
  • Select type of edit: Set value
  • Replace existing value with this value: Select Variable
  • Click on Execute now.

2- Enable the product attributes for variations

You need to enable the product attributes of these products for variations. For that, just open the Bulk Edit tool again and select these values:

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to update: Product Attributes
  • Select type of edit: Change attribute settings
  • What setting do you want to change? Used for variations
  • New value: Yes
  • What attribute do you want to edit? All
  • Click on Execute now.

3- Create the variations for the products

This plugin includes the Create variations tool, which you need to open in order to create variations in seconds. It’s located on the plugin’s toolbar, so just click on it to open.

Once you’ve opened the Variations Manager, you need to select the Create variations button.

After that, in the Create variations section, you need to enter the products for which you’ll create the variations in The variations are for these products.

Now you have to decide between the two options the plugin gives you:

  • Create variations for every combination of attributes: Tick this checkbox
  • Create this number of variations: Enter the number of variations you want to create. With this option you can CREATE 100 VARIATIONS for each of your selected products.

Finally, you need to click on the Execute button to create the variations.

With this plugin you can quickly configure hundreds of variations. For example, if one of your products has 100 variations, you can set values for 10 of them and then just copy that info to the other 90. This will help you save lots of hours because you won’t have to edit the rows one by one.

Just follow these simple steps:

a) Sort the columns you’ll use

Not all the columns will be available to be copied because some of them are just for the parent products. Fortunately, you can sort the columns in by going to Top toolbar > Settings > Hide/Display/Sort columns.

Once there, just disable all the columns you won’t need by moving the columns from the left side to the right side.

Finally, click on Apply settings.

b) Copy the info from 10 columns to the other 90

Now you need to select the cells from the 10 good variations, right click and Copy.

Then, just select the 90 empty variation cells and Paste using CTRL + V.

Finally, just click on Save to apply the changes.

With the Sheet Editor Products Spreadsheet plugin, you can easily copy variations from one product to 100. It takes only some seconds and you don’t need to use any PHP snippets.

Here you have an interesting and useful article about it.

READ: WooCommerce – Copy Variations from One Product to 100 Products with a Few Clicks

It’s really simple!

With Sheet Editor Products Spreadsheet, it’s really simple to create hundreds of variations in seconds.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu