How to Bulk Update Categories of WooCommerce Products

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, you can use the Product import export plugin for WooCommerce which helps in categorizing products very easily. The plugin allows you to organize products in multiple categories, subcategories and even update existing categories of products.

Let us update the categories of these WooCommerce products.

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 with ‘>.

Once the changes are made, save the input file in CSV or XML format and move to the next step of updating the product categories.

Updating product categories in bulk 

To update the product categories in bulk, you have to 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.

Refer to our documentation and product page to know more about the product import export plugin.