WooCommerce – How to Append Category to Product Titles Globally

In this tutorial, learn some ways to append each category to the product titles in bulk.

If your client asks you to show the product category on its title for customers to have a clearer idea about the product they’re seeing, then you need to append the category to it.

However, that’s a problem if you do it with the normal WP editor because it doesn’t give any option, so you have to go product by product and write the category name into the product title, or worse you might need to use some weird PHP code.

However, in this article, we’ll show how easy it is to append the product category to its title using a spreadsheet.

Install WP Sheet Editor

WP Sheet Editor provides a Products Spreadsheet where you can see all the product information and edit freely.

You can skip this step if you already have the plugin installed and activated.

Open the spreadsheet

This spreadsheet shows you all the products and their detailed information.

1- Append category to all product titles at once

Your client may ask you to append categories to all products, so in that case you need to take two simple steps.

a) Open the Bulk Edit tool

This tool is really important. It helps you apply changes to all your products quickly. No matter if you have 200 or 2,000. It’s located on the plugin’s toolbar, so click on it to open.

b) Append category to product titles

You need to use these values to append product categories to their titles.

• Select the rows that you want to update: Edit all the rows from my current search (Even non-visible rows).
• What field do you want to update: Title
• Select type of edit: Append
• Enter the value to append to the existing value: $product_cat$
• Click on Execute now.

2- Append category to product titles by keyword, status, category, attribute, tag, etc.

Sometimes you may want to append product categories to their titles on products containing a keyword. For that, you need to take some simple steps.

a) Open the Bulk Edit tool

With this tool, you can easily filter your products by keyword, status, category, attribute, etc., in order to apply changes to them quickly. It’s on the plugin’s toolbar, just click on it.

b) Filter your products

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

For this, you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Now, you’ll find the following fields to filter your products:

• Contains keyword – Enter a specific keyword to filter all the products containing it.
• Status – Draft, Private, Published, Scheduled, etc.
• Enter Tags – Enter categories, attributes, tags, shipping classes.

After selecting the search method you’ll use, click on Run search to filter your products.

c) Append category to product titles

After filtering your products, you need to use these values to append product categories to their titles.

• Select the rows that you want to update: I want to search rows to update
• What field do you want to update: Title
• Select type of edit: Append
• Enter the value to append to the existing value: $product_cat$
• Click on Execute now.

3- Append product category to all discounted products

If you want to apply changes to products on sale, then you need to follow these simple steps.

a) Open the Bulk Edit tool

This tool will allow you to apply changes to thousands of products at once. You just need to filter them and then apply the changes you wish.

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

b) Filter your discounted products

You need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Then, tick the Enable advanced filters and use these values:

• Field key: Sale Price
• Operator: >
• Value: 0

Finally, click on Run search to filter your discounted products.

c) Append category to product titles

After filtering your products, you need to use these values to append product categories to their titles.

• Select the rows that you want to update: I want to search rows to update
• What field do you want to update: Title
• Select type of edit: Append
• Enter the value to append to the existing value: $product_cat$
• Click on Execute now.

A piece of cake!

As you can see, it’s a piece of cake to append categories to product titles with WP Sheet Editor.