Plugin Setup

Product Import Export Plugin For WooCommerce is an ideal plugin for exporting and importing all the products and their related data either from the WooCommerce store or e-commerce platforms. With this plugin, you can easily import/export :

Products
Product Review

What do we provide?

Migrate products and product reviews using the same plugin.
The main migration methods are:
- Quick import/export
- Based on a Pre-saved template
- Advanced import/export
Import/export data processing in batches, ensures successful import/export irrespective of its size/count.
One can automate migration via FTP profiles and schedules.
Detailed history, debug logs and cron schedules are other main peculiarities.

Pre-requisites

Supports both CSV and XML file formats.
Download a CSV with:
- Sample Product CSV.
- Sample Product Review CSV.
CSVs should be in UTF-8 format.

Important: Import Export (Pro) plugin comes with multiple ZIP files on purchase. Please ensure to install and activate both the wrapper and the add-ons for hassle free import/export.

To begin with the plugin, download, install and activate.

Getting Started

Hooray!!.. You have successfully activated the plugin. From your WordPress dashboard, navigate through the WebToffee Import/Export(Pro) menu.

The plugin consists of six different sub-menus :

Export
Import
History
Logs
Scheduled actions
General settings

Let us have a look at each of these sub-menus in detail.

Export

Products and product reviews can be exported in just 5 steps:

Select a post type: The available post types are Product and Product Review.
Select an export method: Quick export, Pre-saved template and Advanced export are the provided export methods.
Filter data: One can filter data with respect to the chosen post type.
Map and reorder export columns: To map, edit and reorder export columns.
Advanced Options/Batch Export: Provides advanced options for export and scheduling export.

Import

Products and product reviews can be imported in just 4 steps:

Select a post type: The available post types are Product and Product Review.
Select an import method: Quick import, Pre-saved template and Advanced import are the provided import methods.
Map and reorder import columns: To map, edit and reorder import columns.
Advanced Options/Batch Import: Provides advanced options for import and scheduling import.

For a detailed stepwise import export process, refer:

History

The History tab lists the runs and the status corresponding to every import/export with options to:

Re-run: to re-run the action will take the user to the respective screen .
Details: view a detailed history
Delete: delete the entry

To look into the History section:

Click on WebToffee Import/Export(Pro) > History
One can sort the list with these available Filter options:
• Post type: Product, Product reviews
• Action type: All, Export, Import
• Status: All, Finished
• Sort by: Date descending, Date ascending
• Max record/page: The maximum records to be included in a page

The actions will be listed in following statuses:

Success : Process completed successfully.
Failed : Failed process triggered due to connection/permission or similar issues(unable to establish FTP/DB connection, write permission issues etc.).
Running/Incomplete : Processes that are running currently or that may have been terminated unknowingly(e.g, closing a browser tab while in progress etc).

Logs

The Logs tab lists developer logs mostly required for debugging purposes with options to perform the following actions:

View: to view detailed logs
Delete: to remove the log
Download: to share the log report with the support team in case of issues

To look into the Logs section:Click on WebToffee Import/Export(Pro) > Logs

To save the import Logs:

Click on WebToffee Import/Export(Pro) > General Settings
Click on General and choose “Yes” for the Save Import log to save the import log as a text file and make it available in the log section for debugging purposes.
Click on Update Settings to finish.

Scheduled Actions

The Scheduled Actions tab lists all the scheduled processes for import and export. One can disable or delete unwanted scheduled actions to:

Reduce server load
Reduce the chances for failure of actively scheduled actions.

General Settings

The General Settings helps to configure all the basic settings of the plugin.

Let us navigate through this section:

Click on WebToffee Import/Export(Pro) > General Settings.

This tab consists of four different sections:

General
FTP settings
Help Guide
Licence

General

Here, you can configure the basic settings.

Default Export batch count : Here you can give the default count for the records to be exported in a batch.
Default import batch count : Specify the default number of records to be imported in a batch.

The Advanced options constitutes :

Default Export method : Here you can choose a default export method from the three given options:
1. Quick export (chosen by default).
2. Pre-saved template
3. Advanced export
Save Import log : Here you can choose ‘Yes’ to save the import log as a text file and to make it available in the log section.
Default Import method : Choose an import method from three options Quick import, Pre-saved template, and advanced import.
Auto-delete history: You can auto-delete the history by choosing ‘Yes’.
Maximum entries : Here, you can specify the maximum records to retain in history. It will limit the number of records with the status ‘Finished’. E.g: if you input a count of 50 the system will retain only the most recent 50 number of records with the status ‘Finished’. All other records of any other status will not be impacted by this count.

Once you are done with the configurations, click Update Settings.

FTP Settings

The plugin is equipped to handle multiple FTP profiles. These dedicated FTP profile settings can be used to manage and manipulate easy scheduled import/export.

Help Guide

Provides direct links to resources like documentation, support and sample CSVs.

Licence

After you have installed and activated the Product Import Export Plugin for WooCommerce on your website, you need to activate the plugin licence to get notified about the plugin updates.

To do so, from the WordPress admin dashboard:

Click WebToffee Import Export(Pro)> General> Licence.

Know more about : Products and Product reviews.

Was this article helpful?
Yes, thanks!Not really

On this page

What do we provide?
Pre-requisites
Getting Started
Export
Import
History
Logs
Scheduled Actions
General Settings
General
FTP Settings
Help Guide
Licence

This article posted in Documentation, Getting Started, Getting Started, Product Import Export Plugin for WooCommerce, WooCommerce and tagged CSV file utf-8 encoded, Plugin set up, Product export, Product import, Product Import Export Plugin for WooCommerce, woocommerce

Written by

Vineetha

Vineetha is a technical content writer with a knack of simplifying complex information into readable content. She focuses on writing content in a conveyable and clear format.

Comments (28)

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!! 🙂
Reply
- 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.
  Reply
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 ‘
Reply
- 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.
  Reply
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 , ?
Reply
- 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.
  Reply
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?
Reply
- 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.
  Reply
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/
Reply
How to Export and Import WooCommerce Products and Variations - Theme Circle
July 30, 2019
[…] Now, although these features are enough for importing and exporting features, you can get more control over the import and export products using an import-export plugin. Let’s see how we can import and export products and variations using the Product Import Export Plugin for WooCommerce. […]
Reply
How to Import WooCommerce Products with Images - WPFloor
July 17, 2019
[…] you need to install and activate the above-said plugin. Once you are done with its installation and set up go to your WordPress dashboard and navigate to WooCommerce > Product […]
Reply
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?
Reply
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
Reply
- Mark
  July 5, 2018
  Hi,
  Please share us the CSV via the support link above.
  Reply
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..
Reply
- 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.
  Reply
  - 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.
    Reply
    - 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.
      Reply
visual
August 29, 2017
Is it possible to export products by an attribute? Rather than just Category?
Reply
- Veeresh
  August 30, 2017
  Hello Visual,
  Currently, our plugin will not support filtering of attribute while exporting.
  Reply
Igor
July 1, 2017
Hi,
I get this message when running Products Import:
Merge Products
There was a problem
Reply
- Anindo
  July 3, 2017
  Hi Igor,
  Can you kindly share the csv via ticket.
  Our support team will have a look and help you.
  Reply
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
Reply
- 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.
  Reply
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!
Reply
- 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
  Reply
Christine
May 15, 2017
How do you delete a product?
Reply
- 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
  Reply

Cookie	Description
PHPSESSID	This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user session on the website. The cookie is a session cookies and is deleted when all the browser windows are closed.
viewed_cookie_policy	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Cookie	Description
_ga	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, camapign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randoly generated number to identify unique visitors.
_gat_gtag	Identification code of website for tracking visits.
_gid	This cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the wbsite is doing. The data collected including the number visitors, the source where they have come from, and the pages viisted in an anonymous form.
_hjid	Hotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInSample	This cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate Heatmaps, Funnels, Recordings, etc.
has_recent_activity	This cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_ai	Gathers information for our own, first party analytics tool about how our services are used. A collection of internal metrics for user activity, used to improve user experience.
tk_lr	This cookie is set by JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack
tk_or	This cookie is set by JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack
tk_qs	Gathers information for our own, first party analytics tool about how our services are used. A collection of internal metrics for user activity, used to improve user experience.
tk_r3d	The cookie is installed by JetPack. Used for the internal metrics fo user activities to improve user experience

Cookie	Description
_fbp	This cookie is set by Facebook to deliver advertisement when they are on Facebook or a digital platform powered by Facebook advertising after visiting this website.
fr	The cookie is set by Facebook to show relevant advertisments to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook pixel or Facebook social plugin.