WooCommerce – Convert Tags into Categories and Vice-versa

In this tutorial, you’ll learn how to convert thousands of WooCommerce product categories into tags and vice-versa in bulk.

Imagine you have a product category, but then you just stop selling all the products in that category and just sell one of them.

In that case, you may want to integrate that product to a more general category and just use the category as a product tag.

Or maybe you have a tag that becomes so important that you need to dedicate a complete category to it.

Now, if you try to do it in WooCommerce, you’re likely to have to use a PHP snippet.

However, that’s not what you want! But please don’t worry.

With the WP Categories, Tags, Product Attributes, Taxonomies Spreadsheet plugin, you can apply changes to thousands of taxonomies in seconds.

It contains a powerful Bulk Edit tool that allows you to apply changes with just a few clicks.

Whether it be categories, attributes or tags, the plugin displays all your content in a spreadsheet like this.

1- Convert product categories into tags

The first step to take this is to go to Sheet Editor > Edit Product Categories.

You have two options: convert them individually in the spreadsheet, or convert hundreds of them at once.

a) Individually

For this, just go to the Taxonomy column and change the values.

You can quickly convert many categories into tags using the spreadsheet.

For this, just select product_tag in that column.

Then, just hit the Save button to save the changes. It’s that simple!

b) In Bulk

To convert hundreds of product categories into tags, you just need to open the Bulk Edit tool.

It’s located on the plugin’s toolbar, so just click on it.

Once there, you can filter the categories you’ll convert into tags.

This is optional; however, if you don’t do it, you’ll apply the changes to all the categories.

Therefore, select the I want to search rows to update option in the I want to search rows to update dropdown.

Once in the search tool, you can search for all the categories containing a specific keyword.

Just enter it in the Contains keyword field. Then, click on Run search to filter your categories.

Once back in the Bulk Edit tool, use these values to convert the categories you’ve filtered into product tags:

• Select the rows that you want to update: I want to search rows to update
• What field do you want to update: Taxonomy
• Select the type of edit: Set value
• Replace existing value with this item: product_tag
• Click on Execute now

2- Convert product tags into categories

The first step for this is to go to Sheet Editor > Edit Product Tags.

You have two options: convert them individually in the spreadsheet, or convert hundreds of them at once.

a) Individually

For this, just go to the Taxonomy column and change the values. Just select product_cat in that column.

Then, just hit the Save button to save the changes.

b) In Bulk

To convert hundreds of product tags into categories, you just need to open the Bulk Edit tool.

It’s located on the plugin’s toolbar, so just click on it.

 

Once there, you can filter the tags you’ll convert into categories.

This is optional; however, if you don’t do it, you’ll apply the changes to all the tags, that is, you’ll convert them all.

Therefore, select the I want to search rows to update option in the I want to search rows to update dropdown.

Once in the search tool, you can search for all the tags containing a specific keyword.

Just enter it in the Contains keyword field. Then, click on Run search to filter your tags.

Once back in the Bulk Edit tool, use these values to convert the tags you’ve filtered into product categories:

• Select the rows that you want to update: I want to search rows to update
• What field do you want to update: Taxonomy
• Select the type of edit: Set value
• Replace existing value with this item: product_cat
• Click on Execute now

So simple!

You have many advantages if you use WP Sheet Editor.

You can convert thousands of WooCommerce product categories into tags or vice-versa in seconds, and the best part is that you don’t need any PHP snippets.