Organizing the products categorically in an e-commerce platform can drive buyers to exactly what they are looking for. Shoppers often filter their searches to obtain the exact matches of what they want. Therefore, it is essential to organize your products under proper categories. In order to achieve this, use the Product import export plugin for WooCommerce which helps in categorizing products easily. The plugin allows you to organize products in multiple categories, subcategories and even update existing categories of products. To bulk update categories of WooCommerce products:
- Select the post type as Product.
- Select an import method.
- Map the import columns.
- Use advanced options and click on Import.
Let us update the categories of these WooCommerce products.
Alter the product category column in the input file
In the CSV file, let us add one more category for some of the products as highlighted below. If a product has multiple categories, separate them by ‘|’ and if a product has a category with a hierarchical structure, separate them by ‘>’.
Once the changes are made, save the input file and move to the next step of updating the product categories.
Bulk update categories
To update the product categories in bulk, begin with the import process. Follow the steps in How to import products and on reaching Step 4, choose Update for the option: If product exists in the store.
This action will update all the existing product details with the new one, which includes product categories.
Rowan
March 5, 2024
the plugin says it “organize products in multiple categories, subcategories and even update existing categories of products” – so it changes the category name, but I can’t see if it actually updates the title tag, which is different?
Hema
May 15, 2024
Hello Rowan,
Thanks for reaching out. We would like to apologize for the late reply, as our site was under maintenance.
It seems we need more information about your site to solve the issue you are facing. Kindly contact customer support for further assistance.
Michael
January 10, 2024
can you import (and then create) new categories in woo commerce
Vineetha
January 11, 2024
Hi Michael,
It is possible to import a new category. If you want to create a new category, you can just enter the category name in the tax:product_cat column and import, and the category will be created and the product will be assigned to the category.
Ali
May 1, 2024
How make Parent Child While uploading product category?
like Parent is “Men” and “T-Shirt” is Child
Hema
May 15, 2024
Hello Ali,
Thanks for reaching out. For updating parent-child categories, it is wise to use ‘>‘. So in your case It’s going to be Men > T-shirt. Make this changes in the CSV file. Once the changes are made, save the input file and move to the next step of updating the product categories.