You have created 500 variations for your WooCommerce products, and your client asks you to edit their prices because he’s putting them on sale for some time. Or maybe he asks you to delete all the large, black jeans because he’s not selling them anymore. Even more, he can ask you to make all kinds of changes to your product variations… You know how exigent clients are.
Of course, you know that normally you would have to edit each product style and size, for example. And that’s not good if you’ve been asked to save time and do it quickly for your client.
So here we want to show you how to quickly edit hundreds of thousands of product variations using a spreadsheet.
This is very helpful if:
- You are creating a new store and need to set up products quickly
- You are running a marketing campaign and need to edit product prices quickly
- You are updating product information
Let´s start 🙂
1- Install the “WP Sheet Editor” plugin
We love spreadsheets. They are amazing.
You can edit hundreds of rows and fields, you can view all the information in a single place, you can edit thousands of fields by executing formulas, you can copy information between fields, etc.
That´s why we created WP Sheet Editor.
WP Sheet Editor plugin provides a Spreadsheet that you can use to edit WordPress Posts, Pages, and WooCommerce products.
It was created to bring all the spreadsheet benefits into the WordPress platform, so we can save a lot of time and make your life much easier.
2- Setup the spreadsheet
After activating the plugin for the first time you will see the “quick setup page”.
In that page you can enable the products spreadsheet and select the spreadsheet columns.
The setup takes only 2 minutes.
3- Open the spreadsheet
The spreadsheet will open automatically after the setup step, or you can open the spreadsheet manually by going to “WP Sheet Editor > Edit products”.
Now you can see the spreadsheet and you can start editing.
By default, you will see a row for every simple product, downloadable product, external product, and variable product´s main information.
If you want to edit Product Variations, you need to click “Display variations” in the toolbar.
That way you will see one row for every product variation, so you can edit everything in the spreadsheet.
Done. You can start editing freely in the spreadsheet.
Bonus: Video tutorial
In this video tutorial we show you how to Edit Variable Products in the Spreadsheet, Create New Products and Variations Quickly, Edit Variation Attributes and Copy Variations Between Products.