WooCommerce – Convert Attributes to Categories or Tags, and Viceversa

Sometimes you create a bunch of products and want to see how the products will look, but you realize that you made a mistake.

You created the products using Color or Size Attributes, but those attributes don’t appear on the site menu. So you needed to use Product Categories instead of Attributes.

Or you made the opposite mistake, you created Color Categories, but now you want to convert the categories into Product Attributes to allow the users to select the color when adding the product to the cart.

Having to edit all the products again manually is painful! But don’t worry.

In this tutorial we’ll show you how to Convert Product Attributes into Product Categories or Tags, and Viceversa.

1- Meet WP Sheet Editor

WP Sheet Editor is a plugin that allows you to Bulk Edit Products easily.

You can view all the products at once in a spreadsheet, you can edit the products quickly, make advanced searches, and a cool feature is that you can update hundreds of products at once using Formulas.

You can download the plugin here:

- or - Read more about it

The first step in this tutorial is to install and activate WP Sheet Editor. If you already installed it you can go to the next step.

2- Setup the spreadsheet

When you install WP Sheet Editor, you´ll see a quick setup page. This is very easy, you just need to enable the “Products” spreadsheet, then you need to select the fields that you want to edit in the spreadsheet by drag and dropping them to the left column.

You can follow this tutorial for more information.

3- Open the Sheet Editor Plugin

Once opened, you will see a spreadsheet that contains all your products with all their information…

For example, if you want to copy the blue color attribute to create a category from it, you can do it this way:

a) Use the “Bulk Edit” tool

This tool helps you apply changes to hundreds of products at once.

b) Search for the products you want to edit.

You can do this by selecting “I want to search rows to update” in the “Search the rows that you want to update” dropdown and then looking for the product keyword, attribute, tag, category, etc.

You can easily filter your products by keyword, category, attribute, or tag.

  • If you want to filter them by keyword, you need to write the keyword in the “Contains keyword” field.
  • If you want to look for all products within a category or containing an attribute or tag, you need to write it in the “Enter Product category…” field. Then just hit the Run search button.

c) Set the values to copy from attribute to category.

  • Check the “I understand it will update the posts from my current search”.
  • Choose “Product category” as the field you’ll edit.
  • Choose “Copy from other columns” as the type of edit you’ll make.
  • Write “$pa_color$” in the “Copy from this column field.”
  • Hit the “Execute now” button.

This will be exactly the opposite of copying product an attribute to a category. Let’s suppose you have a category called high-quality, and you want to copy it to the product quality column. This is what you need to do:

a) Use the “Bulk Edit” tool.

This tool will help you edit thousands of products at once.

b) Search for the products you want to edit.

You can do this by selecting “I want to search rows to update” in the “Search the rows that you want to update” dropdown and then looking for the product keyword, attribute, tag, category, etc.

You can easily filter your products by keyword, category, attribute, or tag.

For example, if you want to filter them by keyword, you need to write the keyword in the “Contains keyword” field.

If you want to look for all products within a category or containing an attribute or tag, you need to write it in the “Enter Product category…” field. Then hit the Run search button.

c) Set the values to copy from attribute to category.

  • Check the “I understand it will update the posts from my field”.
  • Choose “Product Color” as the field you’ll edit. (You can also choose product size or whatever attribute you have).
  • Choose “Copy from other columns” as the type of edit you’ll make.
  • Write “$product_cat$” in the “Copy from this column field.”
  • Hit the “Execute now” button.

If you want to copy product tags to categories, it’s really easy. All you need to do is to follow these simple steps.

a) Use the “Bulk Edit” tool.

It helps you find and edit thousands of products in a few clicks.

b) Search for the products you want to edit.

You can do this by selecting “I want to search rows to update” in the “Search the rows that you want to update” dropdown and then looking for the product keyword, attribute, tag, category, etc.

You can easily filter your products by keyword, category, attribute, or tag.

For example, if you want to filter them by keyword, you need to write the keyword in the “Contains keyword” field.

If you want to look for all products within a category or containing an attribute or tag, you need to write it in the “Enter Product category…” field.

Then hit the “Run search” button.

c) Set the necessary values to edit your products.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Product category” as the field you want to edit.
  • Select “Copy from other columns” in “Type of edit”.
  • Select “$product_tag$ (Product tags)” in “Copy from this column”.
  • Run the “Execute now” button.

If you want to do the opposite, just change the field you want to edit to “Product tags” and the column from which you’re copying to “$product_cat$ (Product category)”.

Easy, right?

With sheet editor, you won’t have to spend lots of hours to copy attributes to categories or vice-versa for thousands of products.

You can download the plugin here:

- or - Read more about it

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