Sometimes (surprisingly), some variations get sold even more than our parent products. For example, some time ago we had a friend of us telling us that he started selling some shirts of different colors, but then he ended up selling only black shirts because those were his customers’ favorites.
If something like that is happening to you, and you’re considering converting some of your variations into main products, then you’re in the right place.
Continue reading and discover how to easily and rapidly convert variations into main products using the WP Sheet Editor Products Spreadsheet plugin.
The plugin will show you all your WooCommerce products in a spreadsheet after you open it.
To convert variations into products in the spreadsheet, you need to follow these simple steps:
a) Display the variations in the spreadsheet
To see all your variations, you need to hit the Display variations button on the plugin’s toolbar. This button will display all your variations in the products’ spreadsheet.
b) Convert them into products
After that, you need to locate the Product type column. Once there, select the product option. Repeat this procedure in all the variations you want to change into products.
c) Assign product type
After your variations have been converted into products, please save the changes and reload the spreadsheet.
Then go to the Type column and select simple.
That way, your conversion from variations to products will be complete.
To convert hundreds of variations into products in the spreadsheet, you need to follow these simple steps:
a) Open the Bulk Edit tool
Do it by clicking it on the plugin’s toolbar.
With this tool, you’ll be able to convert all your variations into main products.
b) Filter your variations
Once you’ve opened the Bulk Edit tool, select the I want to select rows to update option in the Select the rows that you want to edit field. This will open a search tool for you to filter the variations.
Tick the Search on variations checkbox. This will filter all your variations.
If you don’t want to edit all your variations, you can filter them by keyword, category, attribute, or tag. Just use these fields:
- Contains keyword: search all variations containing a specific keyword
- Enter tag: Here you can enter categories, attributes, or tags.
After you’ve chosen a search method, hit the Run search button to filter your products.
c) Convert them into products
After filtering your product variations, you need to use these values to convert them into main products.
- Select the rows that you want to edit: Edit all the rows from my current search (even non-visible rows)
- What field do you want to edit: Post type
- Select type of edit: Set value
- Replace existing value with this value: product
Finally, hit the Execute now button.
d) Assign product type
After your variations have been converted into products, go to the Type column and select simple.
That way, your conversion will from variations to products will be complete.