Discount Sale
  • Days
  • Hrs
  • Mins
  • Secs
30% Off

Use coupon code 'MDS30' Limited Offer!!

Star

Home > Docs > Product Import Export Plugin for WooCommerce > Bulk Update Categories Of WooCommerce Products

Bulk Update Categories Of WooCommerce Products

Last updated on May 14, 2025

Organizing the products categorically in an e-commerce platform can drive buyers to precisely what they are looking for. Shoppers often filter their searches to obtain the exact matches they want. Therefore, it is essential to organize your products under proper categories. To achieve this, use the Product import export plugin for WooCommerce, which helps categorize products easily. The plugin allows you to organize products in multiple categories and subcategories and even update existing categories of products.

Let us update the categories of these WooCommerce products.

View of products with existing categories
View of products with existing categories

Step 1: 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 ‘>’.

Altering category column in input file
Altering category column in input file

Once the changes are made, save the input file and move to the next step of updating the product categories.

Step 2: 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.

View of product categories updated in bulk
View of product categories updated in bulk