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.
Comments (2)
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.