WooCommerce – How to Convert Categories into Global Attributes and Vice-versa

Have you ever tried to convert your product categories to global attributes? If you have, we’re sure you know that it’s difficult because some solutions people offer on the internet include long and confusing PHP snippets. And we sometimes just don’t have time to be dealing with them.

Therefore, we want to show you how easy it is to convert product categories into global attributes like colors, sizes, etc. You just need to install the WP Sheet Editor Taxonomies Spreadsheet plugin. It helps you apply changes to hundreds of categories in seconds.

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

This is just an example. But by following this method you can convert your categories into any other global attribute.

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. For example, you can convert them into colors. For this, just select pa_color in that column.

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

b) In Bulk

To convert hundreds of product categories quickly into global attributes, 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 colors.

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 colors:

  • 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: pa_color
  • Click on Execute now

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

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 colors 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 colors you’ll convert into categories.

This is optional; however, if you don’t do it, you’ll apply the changes to all the colors, 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 colors containing a specific keyword. Just enter it in the Contains keyword field. Then, click on Run search to filter your colors.

Once back in the Bulk Edit tool, use these values to convert the colors 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

It’s that simple!

Did you notice how easy it is? You can apply this and many other changes in seconds with the WP Sheet Editor Taxonomies Spreadsheet.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu