WooCommerce – How to Convert Tags into Categories and Vice-versa

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.

Here we’ll show you how to convert product tags into categories and vice-versa using the WP Categories, Tags, Product Attributes, Taxonomies Spreadsheet plugin.

With this 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.

You can download the plugin here:

- or - Read more about it

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

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 to do 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 make changes in seconds, and you don’t need any PHP snippets.

You can download the plugin here:

- or - Read more about it

Close Menu