Array ( [0] => GDPR Cookie Consent [1] => CCPA [2] => Getting Started [3] => Changelog [4] => GDPR [5] => Add and Categorise Cookies [8] => Auto-block cookies with Script Blocker [13] => Create Privacy Policy Page [15] => Customize Cookie Notice [18] => Customize Settings Pop up [19] => Change Toggle button color [21] => Display Cookie List [22] => FAQ [23] => Getting Started [24] => Multilingual Support [25] => Overview [26] => Import Export Suite for WooCommerce [28] => Order / Coupon / Subscription Export Import Plugin for WooCommerce [29] => PayPal Express Checkout Payment Gateway for WooCommerce [30] => Changelog [31] => Getting Started [32] => Issue Refund [34] => Video Tutorial [35] => Print Invoice, Packing Slip, Delivery Note & Label for WooCommerce [36] => Address Label [39] => Changelog [41] => Credit Note [43] => Delivery Note [45] => Dispatch Label [47] => FAQ [48] => Invoice [49] => Adding meta data [50] => Customizations [51] => Email PDF Invoice [52] => FAQ [53] => Getting Started [54] => Invoice Number [55] => Multilingual Support [56] => Overview [57] => Packing Slip [58] => Customizations [59] => Getting Started [60] => Pick List [62] => Proforma Invoice [65] => Shipping Label [68] => Product Import Export Plugin for WooCommerce [69] => Smart Coupons for WooCommerce [70] => Abandoned Cart Discount [71] => Advanced Coupon Options [72] => Bulk Generate [73] => Changelog [76] => Getting Started [78] => Import Coupon [80] => Sales Countdown Timer [81] => SignUp Coupon [82] => Store Credit [84] => Volume/Quantity based coupon [85] => Stripe Payment Gateway for WooCommerce [86] => Alipay [87] => Apple Pay [88] => Changelog [89] => Compatibility with Subscription [90] => Getting Started [93] => SCA Ready [94] => Stripe Checkout [95] => Stripe Overview [96] => Stripe via Credit Card [97] => Troubleshoot [98] => Video Tutorial [99] => Subscriptions for WooCommerce [100] => Changelog [101] => Email Notifications [102] => FAQ [103] => Getting Started [104] => Manually Add or Modify Subscriptions [105] => Subscriptions Payment Gateway Guide [106] => URL Coupons for WooCommerce [107] => Changelog [108] => FAQ [109] => Getting Started [110] => Import URL Coupons [111] => QR Code Coupon [112] => WordPress Users & WooCommerce Customers Import Export )

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