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.
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.
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.
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.
Here we provide you some articles on how to find and edit your variations. Just click on them to open the articles in a new tab.