Documentation/Product Import Export Plugin for WooCommerce/How to Bulk Update Product Category in WooCommerce

How to Bulk Update Product Category in WooCommerce

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

In this article we will be detailing on how the existing product category of a product can be updated using the product import export plugin:

Export products into a CSV

Let us begin with exporting the products of your store to identify the existing product categories assigned for each product.  To export, do the following:

  1. On successfully installing and activating the plugin, navigate to WooCommerce > Product Im Ex from your dashboard.
  2. By default the Product Export panel opens up as shown below:

    WooCommerce Product Export

    WooCommerce Product Export

  3.  The export product panel consists of several filters by which you can customize the output generated. Since additional export filters are not necessary in this case, let’s go ahead and click on Export Products (CSV) to export all the products from your store into a CSV file.
  4. Now that we have obtained the CSV file, the necessary changes can be made into it. As we are dealing with how the product category can be changed, we will update the tax:product_cat column of the product (Polo). Currently, it is assigned to the category Tshirt as shown below:
  5. Open the CSV file and update the category of the product from the tax:product_cat column of the CSV. We can update the category of the product Polo such that it will appear under both the category Tshirts and Clothing as shown below.

    • If you want your product to appear under multiple categories then separate them using the pipe (‘|’) symbol, for example, in the above case, ‘Tshirts|Clothing’. This will make the product Polo appear both in Tshirt and Clothing category.
    • If you want your product to appear as a subcategory, then separate the categories by using the ‘ > ‘ symbol. Learn More
  6. Save the updated CSV file. This file can be used to import the product categories back into the store.

Import products using updated CSV 

The products can be imported back with the updated category in the following manner:

  1. Navigate to WooCommerce > Product Im Ex
  2. Move on to the Import section. Attach the updated CSV file from your system.Import CSV with updated product category
  3. Enable the update products if exists checkbox to update the existing product details as shown above. Existing products are identified by their product ID/SKU.
  4. Proceed to upload file and import for moving to the mapping fields.
    Note: Optionally, while uploading the CSV for updating product category, either

    • Upload the CSV by deleting all other columns except the column to which the change is made or else
    • Choose Do not import for all other columns except the column to which the change is made from the Map field section.
  5. From the mapping page, submit to import the updated product price.
  6. On successfully merging products, you can see that the product category is updated to the latest category.Product Category updated

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





  • Was this article helpful?
  • YesNo