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:
- Select the post type as Product.
- Select an import method.
- Map the import columns.
- In the advanced options section, choose Update for the option If the product exists in the store.
- 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.

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:
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.
- 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.
- 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.
- 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:
Comments (3)
Alejandro Merino
August 27, 2020
Is there a way just to import only one field images. Just a csv with image urls and a skus. We have made several changes to the products since they have been uploaded.
Mark
August 28, 2020
Choose only the SKU column and Images column in the mapping screen to only export that data.
Riccardo
June 20, 2019
Hi there,
First of all, thank you for your plugin, it’s very powerful and useful! Anyway, unfortunately, I’m having an issue regarding CSV automatic import via URL (set under Settings). Well, the issue is the following: when the store is automatically updated via the CSV file at a specific import start time, some product variations are still present in the front-end of this product, even if these variations don’t exist in the CSV file and also even if I’ve checked “Delete existing products” that are not present in the CSV. Seems that this option only works for products and not for variations, even if variations are, more or less, products too. So, please let me know if I’m missing something, and also if the “Merge products if exist” option could do the correct job.