WooCommerce – How to Append Category to Product Titles Globally

posted in: Guides | 0

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 on 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.

1- 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.

You can download the plugin here:

- or - Read more about it

2- Open the spreadsheet

This spreadsheet shows you the products and their detailed information.

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 “Apply changes in bulk” tool.

This tool helps you apply changes to all your products at once.

b) Append category to product titles

To append category to product titles, there are some values you need to set:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Choose “Title” as the field you want to edit.
  • In the “Type of edit” field, choose “Append”.
  • Write “ – $product_cat$” in the “Enter value to append to the existing value” field.
  • Hit the “Execute Now” button.

After that, you’ll see how your products titles have been modified to include the category.

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 “Apply changes in bulk” tool.

This tool helps you not only to apply changes to all products but also to apply changes to selected products. So you open it just by clicking it.

b) Hit the “Select rows” button.

This button is a search tool that helps you filter the products you want to edit. In this case, it’ll help you apply changes to all products containing the “Tablet” keyword.

c) Look for the keyword.

To filter the products by keyword, just write the product keyword in the “Contains keyword” field and then hit the “Run search” button.

d) Append category to product title.

To append category to product title, there are some values you need to set:

  • Check the “I understand it will update the posts from my search”.
  • Select “Title” as the field you want to edit.
  • In “Type of edit” select “Append”.
  • Enter ” – $product_cat$” in the “Enter value to append to the existing value” field.
  • Hit the “Execute now” button.

After that you’ll see how your products containing the keyword have been updated to include the category on their title.

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

a) Open the “Apply changes in bulk” tool.

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

b) Hit the “Select rows” button.

This button opens a search tool that allows you to filter your products in several ways. In this case you’re looking for products on sale.

c) Look for the products on sale.

In order to look for products on sale, you need to check the “Enable advanced filters” checkbox.

Once there you need to set these values:

  • In “Field key” you need to look for _sale_price.
  • In “Operator” select the > symbol to look for all the products with a sale price of more than 0.
  • In Value, write 0.
  • Hit the “Run search” button.

d) Append category to product title.

To append category to product title, there are some values you need to set:

  • Check the “I understand it will update the posts from my search”.
  • Select “Title” as the field you want to edit.
  • In “Type of edit” select “Append”.
  • Enter ” – $product_cat$” in the “Enter value to append to the existing value” field.
  • Hit the “Execute now” button.

After that, all your products on sale will be updated to show the category on their title.

6- A piece of cake!

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

You can download the plugin here:

- or - Read more about it

Leave a Reply