WooCommerce – Bulk Append Product Category to Product Title

In this tutorial, we will show you how to bulk append product category to product title in WooCommerce.

Appending product category to product title in bulk can be useful for a variety of reasons. For example, you may want to append the product category to the product title for improved SEO. Search engines use product titles to understand the content of a page. Including the category in the title can help search engines better understand and index the product, potentially improving search rankings.

You may also need to append the product categories to the product titles for enhanced user experience. Customers can quickly understand the type of product they are viewing on your WooCommerce store. This is particularly useful in stores with a wide variety of products, helping users to quickly identify the relevance of a product to their needs.

Normally, this is not something you can do with WooCommerce without knowing how to code. But in this tutorial we will show you how to do it without coding, using the WP Sheet Editor – WooCommerce Products plugin.

With this plugin, you can view and manage your WooCommerce products in an intuitive spreadsheet inside the wp-admin dashboard. You can run advanced searches, edit any field in hundreds or thousands of products, export and import product data, etc.

After installing the plugin and activating your license, you need to follow the steps below in order to bulk append the product categories to the product titles in WooCommerce.

1- Open the spreadsheet

To open the products’ spreadsheet, go to WP Sheet Editor > Edit products.

You’ll see all your products and their data displayed on the spreadsheet.

2- Search for the products you’ll edit

If you do not want to append the category to the title of all products, you can select specific product groups.

For example, you can search for all products with the keyword “shirt” in the title, which also belong to the category “Clothing”.

This is just an example, as WP Sheet Editor allows you to filter your products by keyword, category, attribute, tag, product type, shipping class, date, regular price, sale price, etc.

You need to open the Search tool.

In this example, we will run a combined search to find products by keyword (shirt) and by category (clothing).

Once you’re in the Search tool, select these values:

• Contains keyword: Add the keyword here.
• Enter product categories: Add the category here.
• Click on Run search.

After running the search, you’ll see your WooCommerce products that match the search filters displayed on the spreadsheet.

You can also view the active search filters above the spreadsheet.

3- Append product category to product title in bulk

Now that you have filtered and selected the products you want to update, you need to open the Bulk Edit tool, which will allow you to append product category to product title in bulk.

You just need to select these values in the Bulk Edit tool:

• Select the rows that you want to update: Edit all the rows from my current search.
• What field do you want to edit: Title
• Select type of edit: Append
• Enter the value to append to the existing value: To append the values in the product categories column, you need to enter the column key: $product_cat$
  • Note – We recommend separating the product category so that it’s not appended without spaces. In this case, we’ll add SPACE HYPHEN SPACE before the column key.
• Select the Edit only parent products option.
• Click on Execute now.

After running the bulk edit, you’ll see that the product category has been appended to the product title.

As you can see, adding the product category to the product title is an easy process with the WP Sheet Editor – WooCommerce Products plugin.