The Product Import Export Plugin for WooCommerce lets you quickly import and export all product types, including simple, variable, grouped, downloadable, and external products, along with their categories and tags.
Export Products
Step 1: Select Post Type
From the WordPress admin panel, go to WebToffee Import Export (Pro) > Export.
Choose Post type as Product.
Step 2: Choose Export Method
- For a quick export, select Quick Export and click Export to download the file.
- For advanced export, use Advanced Options/Batch Export/Scheduling to refine your export and select the file format (e.g., CSV). CSV is recommended as it clearly displays product data in columns.
Step 3: Export File
Click Export. A CSV file will be generated and automatically downloaded.
The file includes all product types—simple, variable, downloadable, grouped, and external along with tags and categories.
The plugin doesn’t export product reviews while exporting products. Product reviews need to be exported separately.
For a detailed walkthrough of export, see How to export WooCommerce products.
Import Products
Step 1: Prepare Input File
- Use the same exported CSV for import to ensure field names match.
- Separate multiple product tags with ‘|’.
- Separate multiple categories with ‘|’.
- Use ‘>’ to define parent-child hierarchy in categories.
Step 2: Select Post Type
Navigate to WebToffee Import Export (Pro) > Import and choose Post type as Product.
Step 3: Select Import Method
Choose Advanced Import. This option allows filtering, column mapping, advanced options, batch importing, and scheduling.
Step 4: Map Columns
The plugin automatically maps CSV columns if the header names match. Unmapped fields remain blank.
- To adjust, click on a product field column, choose the correct CSV column from the dropdown.
- Proceed with default mapping if everything matches correctly.
Step 5: Advanced Options & Scheduling
Set filters if you want to import only specific products, such as those matched by SKU or ID. By default, the plugin:
- Imports new products from the CSV.
- Skips products if the ID already exists in your store.
- Skips conflicting products with duplicate IDs.
You can import directly or schedule imports via FTP.
For scheduling, see Cron scheduled export/import.
Click Import/Schedule to finish.
Explore Advanced Features
- Composite Product Support – Import and export composite products with all component details, pricing, and configurations.
- ChatGPT Product Descriptions – Automatically generate descriptions for products with missing content during import.
- Cron Scheduling – Automate imports and exports at defined intervals using cron jobs.
- Email Alerts – Receive email notifications when a scheduled cron import completes successfully.
Péter
May 9, 2025
Hello! I bought Product/Review CSV Import Export PRO plugin in 2020. The actual version is 3.8.3, PHP8.1. But I changed PHP from 7.4 to 8.1 . After that the plugin not working good. It importes some variations from all and do nothing. What is the problem. How can I update it. Thanks Péter
Hema
May 20, 2025
Hello Peter, Product/Review CSV Import Export PRO Plugin is discontinued, and we no longer offer technical support. All the features that were earlier part of this plugin are now available in Product Import Export Plugin for WooCommerce. Kindly purchase the latest plugin for more new features and support.
Anthony Didsbury
August 28, 2024
Hi, is it possible to use the plugin to export from one website, then deactivate the plugin and install on another site to import?
Hema
August 29, 2024
Hello Anthony
Thanks for reaching out. Yes, this can be done. If you have only single-site access, then you need to deactivate the licence from the first site and then activate it on the second site.
Ben Kraemer
August 20, 2024
Super plugin! We have some dublicate products in our list and have created a csv file only containing these products. How can we now delete these products with the csv import function?
Many thanks and best wishes,
Ben
Hema
August 23, 2024
Hi Ben,
Thanks for reaching out. Yes, this can be done. You will need a customized code snipped to do this. To get the code snippet, kindly contact customer support team.
bernie clark
July 22, 2024
does Product Import Export Plugin For WooCommerce support all in one seo data?
e.i. seo title and description
Hema
July 31, 2024
Hello Bernie,
Thanks for reaching out. The plugin supports All-in-one SEO . If you are facing any problems, kindly contact customer support.
dario
July 13, 2024
If I am using the Plug in to export or import products can I use WooCommerce on another browser card, to insert other products?
Hema
July 18, 2024
Hello Dario,
Thanks for reaching out. Yes, you can do that. But you must be cautious not to cause any conflict.
RUBEN
March 8, 2024
How to Import / Export product attributes?
Hema
April 2, 2024
Hello Ruben,
Thanks for reaching out. Kindly follow the steps mentioned in article:Import with Attributes, to import product with attributes. Then, to export, follow the steps mentioned in this article.
aghayedigital
January 30, 2024
Thanks-a-mundo for the blog article. Much obliged.
Tim
December 18, 2023
I have this message coming up when i am trying to add new products. Do you know why?
Could not insert post into the database.
Vineetha
December 19, 2023
Hi Tim,
Thanks for reaching out! The error message “Could not insert post into the database” is displayed when the importing CSV file contains unidentified characters and is not UTF-8 encoded. Please make sure that the CSV file is saved as UTF-8 encoded before importing to overcome this issue. Please go through the article on How to save CSV as UTF-8 encoded.
Tom
March 15, 2023
Hello,
I installed WP comments Import / Export
I would like to export or download the comments. But that doesn’t work. I do not know why.
The FTP data are entered.
What must be entered in the “Export Path” field?
Vineetha
March 29, 2023
Hi Tom,
Thanks for reaching out. The Product Import Export Plugin For WooCommerce does not support page comments. It supports product reviews. If you are trying to export the reviews to a ftp server, then you need to specify the folder path in the export path field.
Igal Hebron
October 17, 2022
Hello there. I am getting an error on two products out of 50 that I am trying to import froma CSV file.
The error I am getting is “Failed to import product”
When I go into the logs, i get this error:
2022-10-17T14:23:49+00:00 DEBUG > Row 1 – preparing for import.
2022-10-17T14:23:49+00:00 DEBUG > Inserting Asian Terracotta Warrior Standing Replica Made of Marble Size: 6″ x 4″ x 19″H
2022-10-17T14:23:49+00:00 DEBUG Could not insert post into the database.“Asian Terracotta Warrior Standing Replica Made of Marble Size: 6″ x 4″ x 19″H”
2022-10-17T14:23:49+00:00 DEBUG > Row 2 – preparing for import.
2022-10-17T14:23:49+00:00 DEBUG > Inserting Asian Terracotta Warrior Sitting Replica Made of Marble Size: 5″ x 5″ x 15″H
2022-10-17T14:23:49+00:00 DEBUG Could not insert post into the database.“Asian Terracotta Warrior Sitting Replica Made of Marble Size: 5″ x 5″ x 15″H”
2022-10-17T14:23:49+00:00 DEBUG > Row 3 – preparing for import.
Could you please explain why I am getting this error? What am I doing wrong here?
Alan
November 1, 2022
Hi,
Can you please reach us via support and share your CSV file so that our support agent can check it and help you with it?
Dobriša Bagić
May 27, 2022
Hi,
I can’t use plugin, it says : The WebToffee Import/Export wrapper plugin should be activated in order to import/export any of the post types supported via WebToffee add-ons(Product/Reviews, User, Order/Coupon/Subscription). Go to My accounts->API Downloads to download and activate the wrapper. If already installed, activate the wrapper plugin from under Plugins.
Ivonne Budimir
July 14, 2022
Same issue here, will deactivate again… no possibility to get the license key going.. :/
Alan
July 20, 2022
Hi,
The issue you are facing is that you haven’t installed all the plugin zip files that are available in the downloads section of your WebToffee account. Please download all the plugin zip files from the Downloads section of your WebToffee account and install all the zip files on your site for successfully installing and using the plugin.
If you still face any issues then please reach us via support.
Krystian Sledz
January 10, 2022
Hi,
I updated the plugin and the plugin menu dissapeared. I can only access the settings from the plugins page and nothing else.
Loretta
October 8, 2021
I am trying to import product csv file in 3 languages however they are not connected. May I know what field I should add to connect them ?
Mark
October 9, 2021
Hi,
Please make sure that you add the WPML columns wpml:langauge_code, wpml:original_product_sku, and wpml:original_product_id in the CSV file to import WPML simple products in different languages. To know more about it please go through the article on How to import WPML products.
Carlos
March 11, 2021
Hello
I am trying to schedule an automatic product update by FTP via XML file. However it does not update. The connection to the FTP is correct and the path is correct, but in RECORDS it indicates this:
2021-03-11T15:46:19+00:00 DEBUG —————Start: Cron Import started at 2021-03-11 15:46:19—————
2021-03-11T15:46:19+00:00 DEBUG Fetching file failed. Reason:
2021-03-11T15:46:19+00:00 DEBUG —————End: Cron Import ended with errors at 2021-03-11 15:46:19—————
When I do manual update with the same XML file, it updates it correctly
Could you help me?
Thanks!! 🙂
Alan
March 16, 2021
Hi,
It seems like the issue you are facing is because the file path you provided is wrong. Please make sure that the file path is correct and the file has the necessary permissions for importing.
How can i Prepend field by other field Value ?
February 5, 2021
How can i Prepend field by other field Value ?
I need to Prepend SubCategory field with ParentCategory field like this ‘ parentcat > subcat ‘
Mark
February 12, 2021
Hi,
You can add parent category to sub-category by adding it in the CSV file itself or by using the evaluation field. In the evaluation field, you may please specify “&parentcat[VAL]” where parentcat is the parent category name. Please note that if you use the evaluation field then all the rows in the file will be imported with the data that is provided in the evaluation field prepended. Hope this is clear.
Stu Turn
January 11, 2021
Hi there, what’s the format for importing cross sell and up sell SKUs? e.g. meta:_crosssell_skus
Separate SKUs by | or , ?
Mark
January 12, 2021
Hi,
You may please use the pipe symbol( | ) to import multiple upsell and cross-sell data. You may please create a column with the header “upsell_ids” and “crosssell_ids” and provide data in that column.
Craig Sharp
December 6, 2020
I tried importing with the Product WooCommerce Sample CSV sample file you provided the link to. It fails on the last two products (the variations). The plugin provides no information why it failed either. Can you check this?
Mark
December 8, 2020
Hi,
You can check why the products failed to import in the import log file(Woocommere>status>logs>csv-import). Please share with us the screenshot of the error that you are receiving on the import screen via support. Our support team will follow you up from there.
Carolee Cheu
July 26, 2020
You completed a few fine points there. I did a search on the subject and found a good number of people will consent with your blog.
https://tanyblogs.wordpress.com/2020/06/06/how-to-use-shopify-in-2020/
marc Giraudon
October 10, 2018
Hi,
For the the product information, how do I create multiple lines in the product area?
what separator should I use between multiple tags and categories?
Anne-Marie
July 4, 2018
Hi,
I have a list of variable products and when I import them it says import successful and merge successful – however when I then go to items, they are not there!
Can you help me? It is extremely frustrating…
Br,
Anne-Marie
Mark
July 5, 2018
Hi,
Please share us the CSV via the support link above.
Iwan_sandy2000
June 11, 2018
After upload 1000 sku product in 1st time..
Next time i want to update new product (1500 sku).
Are this plugins can progress empty stock when the sku not allready(old product)..
In this case ..
I’m just have the sku ready stock..
Mark
June 12, 2018
Hi Iwan,
Our plugin uses either SKU or ID to update existing product data such as stock. If you do not have SKU for all products, you may use ID to update stock.
Deb
August 14, 2020
Can you create and import a new product’s ID in the import file? I’m connecting variable products with IDs instead of SKUs.
Mark
August 19, 2020
Yes. Use the column Id and parent_id and make sure that the ID is not used for any other posts in WordPress database.
visual
August 29, 2017
Is it possible to export products by an attribute? Rather than just Category?
Veeresh
August 30, 2017
Hello Visual,
Currently, our plugin will not support filtering of attribute while exporting.
Igor
July 1, 2017
Hi,
I get this message when running Products Import:
Merge Products
There was a problem
Anindo
July 3, 2017
Hi Igor,
Can you kindly share the csv via ticket.
Our support team will have a look and help you.
alex-hh
June 21, 2017
Hi there! Thank you for this great plugin! I exported my products cause I had to make a change in the description of the pruducts (same change on each product). Then I imported the file again. Everything is fine, BUT how can I turn off the regenerating of the images? By importing I have all the images twice in my media section now. That wouldn’t be such a big deal to delete them once, but the images in my shop are renamed due to regenerating and image.jpg is now image-1.jpg … I want it to be image.jpg – any suggestion what to do? Thank you in advance!
Alex
Anindo
July 3, 2017
Hi Alex,
If images are not importing, it will not create new image
During updation, desc image column can be skipped.
Kindly try this and let us know if that worked.
Christine
May 15, 2017
I would like to upload a few products to add to my existing products in WooCommerce. Can I append the list with just my few additional products? I don’t want to mess up what’s already there!
Veeresh
May 15, 2017
Hello Christine,
Yes, You can add any amount of New products to your existing products list. or you can update your existing products too.
To add new products to your existing products list, Just have new products in your import csv.
(Note: if you are using ID to new products, please make sure your existing products not having the same ID of existing products). Hope this works.
Regards,
Veeresh
Christine
May 15, 2017
How do you delete a product?
Veeresh
May 15, 2017
Hello Christine,
To delete products from the site, go to products page –> select products want to delete–> in bulk actions, choose “Move to trash”–> Apply. this action will make products to move to trash. (You can restore deletedproducts any time)
If you wanted to delete products permanently, go to “trash” –> mark products–> bulk actions–> delete permanently. This will make delete your products permanatly from your site.
Hope this will help.
Regards,
Veeresh