WooCommerce – How to Convert Variations into Products

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.

Install it now!

This plugin makes it easy to manage your WooCommerce store applying changes to hundreds of your products in a few clicks!

You can download the plugin here:

- or - Read more about 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, go to the Type column and select simple.

That way, your conversion will 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.

OPTIONAL

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.

Done

Did you see how easy it is to convert product variations into products using the WP Sheet Editor Products Spreadsheet plugin?

You should get it now and start saving time!

You can download the plugin here:

- or - Read more about it

Close Menu