Home > Docs > Product Import Export Plugin for WooCommerce > Update Simple and Variable Products in WooCommerce with a CSV Import

Update Simple and Variable Products in WooCommerce with a CSV Import

Last updated on November 3, 2023

Product Import Export Plugin For WooCommerce provides an effective mechanism to update your existing simple as well as variable products with all the details you want. To update the products:

  1. Select the post type as Product.
  2. Select an import method.
  3. Map the import columns.
  4. In the advanced options section, choose Update for the option If the product exists in the store.
  5. Click on Import to finish.

Use Case

In the screenshot below, you can see the WooCommerce products page showing all products along with their product image, Name, SKU, stock information, prices, categories, tags and so on.

WooCommerce Products Page
Products before update

For this demonstration, we will update the regular prices, categories and tags of products in the importing CSV file, as shown in the screenshot below:

Updating the input file

Steps to update the products

As a first step, install and activate the product import export plugin. Click on WebToffee Import Export (Pro) > Import menu from the WordPress admin panel.

  • Select Products under post type.
    Selecting post type as product
  • Select an import method: One can choose among: Quick import, Pre-saved template and Advanced import .
  • Map import columns: To map import columns. Here, you can map the commercial names to WooCommerce columns. Use Evaluation Field to fix/update the required value for a particular field.
    step3-import-products-suite
  • Advanced Options/Batch Import: Provides advanced options to import and scheduling import. In this screen, choose Update for the option If the product exists in the store. This will update the existing products as per the data from the input file.
    update existing products
  • Click on Import to update the products.

Finally, head on to Products from the WordPress dashboard to view the updated changes in the product prices, categories, and tags as shown below:

WooCommerce Updated Products Page
Updated products