Variations in WooCommerce make life easier for us. We don’t have to be answering emails explaining what variety of products we have. We can create as many variations as we want so our customers can find exactly what they need.
The problem is that with the normal editor it is too difficult to handle thousands of variations. First, you can’t see them all to edit them. Second, if you try to apply bulk actions to them, you will have some problems because it is too difficult and your server may overload.
That’s why we want to show you how you can use a spreadsheet to manage your large numbers of variations. We’re talking about the WooCommerce Products Spreadsheet plugin.
Install the plugin now
It displays all your products on a spreadsheet where you can visualize all their variations and edit them quickly.
Once installed and activated, you need to go to Sheet Editor > Edit Products to open the spreadsheet, which will display all your products and their complete information.
1- Display all the variations on a spreadsheet
When you open the spreadsheet, you’ll see all your main products displayed on it. If you want to see the product variations, you just need to click on Display variations and all the variations will appear below the main products.
2- Filter variations by product category, attribute, tag, date, etc.
With this plugin you can find all your variations by product keyword, attribute, category, date, tag, etc. You just need to click on Search on the plugin’s toolbar and select the necessary values.
Here are some tutorials that can guide you to filter your product variations in WooCommerce:
3- Edit thousands of variations in minutes with the Bulk Edit tool
You can also apply changes massively using the Bulk Edit tool. The great advantage of this plugin is that you can edit thousands of products at once and your server won’t overload because the plugin applies the changes in batches.
Here are some tutorials about editing thousands of variations:
- Delete all Default Attributes from all Product Variations
- How to Edit Variation Descriptions Quickly
- How to Remove Duplicate Product Variations
- How to Upload Images to lots of Product Variations
- Remove SKU from Product Variations
- How to Delete Out of Stock Variations
- Delete Product Variations by Category, Attribute, Keyword
- Delete all Product Variations Quickly
4- Create many variations at once
You can create thousands of variations in some minutes for your products. For example, you can create a variation for every combination of attributes in just some minutes.
Here’s a tutorial on how to do it:
Start saving time!
As you can see, the WooCommerce Products Spreadsheet offers you a lot of options to manage thousands of variations without effort. You’ll see all your variations on a spreadsheet and be able to edit them all in some minutes.