How to Set Up Product Import Export Plugin For WooCommerce – Beginner’s Guide

This article explains the setting up of WebToffee Product Import Export Plugin For WooCommerce. To know more about the features of the plugin, refer to the product page.

Overview

Product Import Export Plugin For WooCommerce allows you to import and export products to/from your WooCommerce store in CSV or XML format. You can use this plugin to import simple, grouped, external, variable including custom product types such as subscription, bundle or bookable products. You can easily import, export or update hundreds, even thousands of products using one file which saves your effort and time for manually adding product information.

For importing products to your online store, you will need a CSV (Comma-Separated Values)/XML (Extensible Markup Language) file, which contains information about mapping fields.

The plugin also facilitates you to export or import product reviews and ratings of the products by using a CSV file. You can also customize product reviews and ratings according to the needs. This option is mainly used by store owners/admin to move reviews and ratings from one store to another.

It also supports Cron Jobs (WordPress scheduled task) to schedule importing and exporting of products, as well as reviews into an FTP location in a specific time interval automatically.

Pre-requisites

The CSV Import file must be in UTF-8 format. For more information about UTF-8 encoding, read How to save CSV / Excel File as UTF-8 Encoded?

Installation

After purchasing the Product Export Import Plugin For WooCommerce, the plugin will be available as a zip file in the API Downloads section of your MY ACCOUNT page.

Download the zip file from API Downloads by logging into your Webtoffee MY ACCOUNTS page.
Log in as the WordPress Admin of your online store.
Navigate to Plugins > Add New to upload the downloaded plugin.
Choose the plugin file to upload.
Finally, activate the plugin.

For detailed information about installing WebToffee plugins, read How to Download, Install, Activate & Update WooCommerce Plugin.

Getting started with the plugin

Once the activation is successful, two new sub-menus appear under the WooCommerce section in the WordPress sidebar menu. You can navigate to the Product Import Export settings in two ways:

WooCommerce > Product Im-Ex from WordPress dashboard, or
Plugins > Installed Plugins > Product/Review CSV Import Export > Product Import Export.

Product Import/Export

In CSV Import, the plugin takes CSV file as input for importing products. It maps each field of the CSV file to the field of a particular WooCommerce product (that otherwise needs to be entered manually by admin). Each row represents one single product. You can create a CSV file by using a spreadsheet application such as Google Spreadsheets or Microsoft Excel. After entering all details about products in the spreadsheet, save this file with extension .csv.

You can create one or you can export the product to get the format of CSV. Alternatively, download Product WooCommerce Sample CSV (column headers are the same as WooCommerce field) and Product Commercial Sample CSV (column headers are user-defined).

In XML Import, the plugin takes XML file as input for importing products. It maps each tag of the XML file to the field of a particular WooCommerce product (that otherwise needs to be entered manually by admin).

You can create one or you can export the product to get the format of XML.

WooCommerce Mapping Fields:

Before you get down to configure settings for product import & export, you should know some information about mapping fields.

For example, the post_title field gets mapped to the product name and the regular_price field gets mapped to the regular price of your product. If you want the plugin to work correctly, you must map all of the fields in the correct format. If there is any mistake in your import file, your product import may not work as expected.

The details about Woocommerce mapping field is given as below:

Column/Tag Header	Explanation	Accepted value or format
post_title	Indicates the name of the product.	Text (ex. High Heel Shoe)
post_name	Indicates slug name of the product.	Text (ex. high-heel-shoe)
post_status	Indicates whether the product is in a draft or published mode.	draft/publish
post_excerpt	Indicates a short description of the product.	Text/HTML
post_content	Indicates description of the product.	Text/HTML
post_parent	Indicates parent of grouped and variable products.	Parent ID
post_password	For including a password for a private post.	Text
sku	SKU(stock keeping unit) is an identification, usually alphanumeric, of a particular product that allows it to be tracked for inventory purposes.	Alpha-numeric characters
menu_order	It decides the order of displaying the products in the shop. Items with menu order = 0 are displayed 1, 2, 3, etc. Products with the same menu order number are then listed alphabetically. When you create a new product it defaults to menu_order = 0.	Numeric characters
downloadable	After purchasing the product, whether the product can be downloaded or not.	yes/no
virtual	It is not physically existing as such but made by software to appear to do so.	yes/no
visibility	Indicates whether a product is available for purchase or not.	visible/hidden
stock	Total number of products available in stock. You can use (+) or (-) signs with parenthesis to add or subtract the number of products to the stock.	Numeric characters
stock_status	It indicates whether the product is in stock or not.	instock/outofstock/onbackorder
backorders	Indicate orders for out-of-stock products that cannot be currently fulfilled or shipped, but is requested nonetheless for when the product becomes available again.	yes/no
manage_stock	It indicates whether the stock is managed by a store or not.	yes/no
regular_price	Indicates the original price of the product.	Numeric characters
sale_price	It is the price of the product that is being offered at a discounted rate.	Numeric characters
weight	Indicates the weight of the product.	Numeric characters
length	Indicates the length of the product.	Numeric characters
width	Indicates the width of the product.	Numeric characters
height	Indicates the height of the product.	Numeric characters
images	Indicate image URL or image name. Supports multiple image URLs separated by ‘\|’.	URL Eg: http://url/filename1.png
tax_status	It indicates whether the product is taxable or not.	taxable/none
tax_class	It indicates the tax option for the product.	Standard rate/Reduced rate/Zero rate
tax:product_type	Indicates the type of product (simple or variable).	simple/variable
tax:product_cat	It is used during importing the product which indicates the category of product.	Text
tax:product_tag	It is used during importing the product which indicates tag(s) used for the product.	Text
tax:product_brand	It indicates the brand of the product.	Text
attribute:Color	It indicates the available color of the product.	Text
attribute_data:Color	It indicates the metadata about the attribute color of the product.	position\|visible\|variation (ex. 0\|1\|1)
attribute:Size	It indicates the available size of the product.	Ex. US 7\|US 8\|US 9
attribute_data:Size	It indicates the metadata about the attribute size of the product.	position\|visible\|variation (ex. 1\|1\|1)
attribute:pa_unit	This lists out the unit options.	Ex. 10 kg \| 20 kg \| 30 kg
meta:attribute_pa_unit	It indicates the metadata about the product unit.	Ex. 10 kg
attribute_data:pa_unit	It defines the position, visibility and whether used for variation or not.	position\|visible\|variation (ex. 4\|1\|1)
attribute_default:pa_unit	This is the default value of a unit attribute.	Ex. 10 kg

Note: Attribute names with pa are global attributes and the ones without pa are called local attributes.

Mapping fields supported by Google Product Feeds:

Column/Tag Header	Explanation	Accepted value or format
gpf:availability	Indicates availability	in stock, available for order, preorder
gpf:condition	Indicates condition of the product	new, used, refurbished
gpf:brand	Indicates brand	Text
gpf:product_type	Indicates product type	Text
gpf:google_product_category	Indicates product category	Text
gpf:gtin	GTIN (Global Trade Item Number)	Text
gpf:mpn	MPN (Manufacturer Part Number)	Text
gpf:gender	Indicates gender	male, female, unisex
gpf:age_group	Indicates age group	adult, kids
gpf:color	Indicates color	Text
gpf:size	Indicates size	Text

Mapping fields supported by Yoast SEO:

meta:_yoast_wpseo_focuskw
meta:_yoast_wpseo_title
meta:_yoast_wpseo_metadesc
meta:_yoast_wpseo_metakeywords

On the plugin dashboard, the Product tab is divided into the following two sections:

Import
Export

Product Import Export-Menu

Import Products

The Import section helps in importing products using the CSV/XML file. To start importing products, click the Import button.

The Import section contains three methods for importing products as shown below:

WooCommerce Product Import Export- Import Window

Method 1: Select a file from your computer – The first method is to select a CSV/XML file from your computer.

Selecting a file from your computer: Click the Choose File button to select a CSV/XML file for importing from your computer.

WooCommerce Import Products using CSV/XML

Method 2: Provide FTP Details – The second method is to select a CSV file from your FTP server. You need to provide your FTP information for importing products using this method.

Import Products using FTP

The following FTP information has to be entered for importing products using this method:

Enable FTP import/export: Check this option to enable FTP import/export.
FTP Server Host/IP: Enter your FTP server hostname.
FTP User Name: Enter your FTP username.
FTP Password: Enter your FTP password
FTP Server Path: Enter the FTP server path.
Use FTPS: Check this option to use FTPS. FTPS (File Transfer Protocol Secure) is a secured extension of FTP (File Transfer Protocol).

Method 3: Enter the URL of the file – In the third method, you can provide the URL of the CSV file from where it will be downloaded for importing the products.

Import products via URL

The section below is the Advanced Options for import.

Available-Options

Mapping Profile: You can select an existing mapping file. Mapping files are created by mapping your imported columns to product data fields.
Update products if exists: Check the Update products if exists check-box to update details of existing products on your store. The existing products are identified by their SKUs/Product IDs.
Skip New Products: While updating existing products, tick this check-box to skip products which are not already present in the store. If a new SKU is encountered in the imported CSV file, it will be skipped, and only the existing products will be updated.
Delimiter: In a delimited text file that is used to store data, each line represents a single entity, and has fields separated by the delimiter. A delimiter is a character used to specify the boundary between separate entities in a text file. A popular example of a delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values (CSV). Enter a delimiter to separate the mapping values. By default, a comma is taken as the delimiter. In place of a comma, you can also use other characters like /, ” “, |, @, etc. You can also use the letter ‘t‘ for parsing tab delimiter.
Delete Existing Products: Check this option to delete the existing products that are not present in the importing CSV.
Use SKU to link up-sells and cross-sells: Check this option to use SKU to link the up-sells and cross-sells of a product. If this option is not checked, up-sells and cross-sells of a product will be linked using the Product ID.
Disable thumbnail generation: Check this option to avoid the regeneration of thumbnails on import.
New product status: This section allows you to change the status of all the new products imported to draft, pending, or published, overriding the existing status in the CSV.
Use SKU to link grouped products: Check this option to link the grouped items using SKU. If this option is not checked, the grouped products will be linked using product IDs.

Finally, click the Upload File and Import button to proceed further towards Map Fields.

Map Fields: This section allows you to map your imported columns to product data fields. You can select an existing mapping file or create a new one by naming the mapping file and clicking on the Save Import Mapping button as shown below:

Product Import Export-Import Products-Map Fields

It is divided into the following three columns:

Map to: Represents WooCommerce product field names to which attributes will be mapped.
Column Header: Represents CSV headers which will be mapped to appropriate WooCommerce fields.

Product import column header

Evaluation Field: This column is used to fix/update the required value for a particular field.

Following are the possible values:

Assign any required constant value to field –
For example, to assign the value ‘cotton mixed’ to ‘attribute:pa_fabric’, enter the value =cotton mixed under Evaluation Field in the attribute:pa_fabric row.
Add any required value to the field –
For example, to add ‘2’ to ‘length’, write +2 under Evaluation Field in the Dimension: length row.
Reduce any required value from the field –
For example, to reduce ‘1’ from ‘width’, write -1 under Evaluation Field in the Dimension: width row.
Multiply by any required value to the field –
For example, to multiply ‘weight’ by ‘1.15’, enter the value *1.15 under Evaluation Field in the Dimension: Weight row.
Divide by any required value to the field –
For example, to divide ‘sale price’ by ‘2’, write /2 under Evaluation Field in the Price: Sale Price row.
Append any field by required value –
For example, to append ‘Product Title’ by ‘By HikeForce’, write &By HikeForce under Evaluation Field in the Product Title row.
Prepend any field by required value –
For example, to prepend ‘Product Description’ by ‘Description’, write &Description[VAL] under Evaluation Field in Product Description row.

Note: You can hover the mouse to the sign, next to the header Evaluation Field column to see all the above value information. It is as shown in the screenshot below:

Evaluation-Field-On-Hover

After mapping all the required fields, save these mapping and evaluation fields in a file by specifying the filename in the Mapping file name field.
Click Submit to start importing.

Once the import is successful, a screen is displayed similar to the below screenshot:

Import successful progress dialog box

Merge Products (Update Existing Products)

If your existing product is modified, you can update that modification on your store by merging it with the existing product. For this, update the existing product by importing the modified product CSV file.

Follow the below steps to merge products:

Check the Update Products if exists option from the Available Options setting of Product Import.
Click Import Products to proceed further by selecting the mapping file.

The process of selecting a CSV file for merging products is similar to that of importing products, as described earlier in this article.

Note: If the product SKU does not already exist in your store, then the product is imported as a new product.

You can import simple, grouped, variable and external products. Along with these basic product types, the plugin supports WC Composite products, WC Bundle Product, WC Booking and WC Photography.
For more information on import and export of bundle products, please refer to WooCommerce Import and Export of Bundle Product.

Export Products

With this plugin, products can be exported into a CSV/XML file. The exported file will contain all the product information from your WooCommerce store. You can use this plugin to export simple, grouped, external and variable products, including custom product types such as subscription, bundle or bookable products.

To start exporting products, click the Export button. The export settings are as shown below:

Product Import Export-Export Products

The export settings consist of the following:

Offset: Allows you to set an offset value that lets you skip a specific number of products before exporting.

product-export-offset

Limit: Allows you to specify the number of products to be exported.
For example, if Offset=0 and Limit=50, the first 50 products will be exported.
If Offset=10 and Limit=50, the first 10 products will be skipped, and the remaining 50 products will be exported (from product number 11 to 60).

product-export-limit

Product Categories: Allows you to select categories of products to be exported. This option can be used as a filter for exporting products of certain categories.

product-export-categories

Product types: Allows you to select the types of products to be exported. You can import simple, variable, grouped or external products only or any combinations of these types.

product-export-types

Sort Columns: Allows you to enter the column name(s) by which you want to sort the products in the CSV file. If you want to sort the products by more than one column name, enter a comma (‘,’) in between the column names. Accepted columns for sorting the products are as given below:
- post_author
- post_date
- post_title
- post_name
- post_modified
- menu_order
- post_modified_gmt
- rand
- comment_count

Note: post_parent and ID columns are entered by default. However, if you want to sort the products first by Product ID, you can manually enter the ID in the Sort Columns field.

Delimiter: Enter a delimiter to separate the mapping values. By default, a comma is taken as the delimiter. You can also use characters like /, ” “, |, @ and so on.

Product export delimiter

Select a mapping file for export: Similar to import settings, you can select an existing mapping file for exporting products. This option is enabled only when you create your first mapping file.
Columns: Select checkboxes from the Column field for the required columns to be exported. With the Column Name field, you can modify the column header in the CSV file. To do this, simply enter an appropriate name for the specified column.

export-required-product-columns

Additional options for exporting:

Export-Additional-Options

Save the export mapping: Enter a mapping filename for exporting.
Include hidden metadata: Select the checkbox if you want to show hidden metadata of your products in the CSV file. To get thumbnail IDs of the product images, select this checkbox.
Export Children SKU of Grouped Products: Enable this checkbox to link parent and child products with SKU. If this box is unchecked, parent and child products are linked using the product ID.
Convert shortcodes to HTML: Enable this option to convert shortcode to HTML in the exported CSV.
Export images as Zip file: When this option is chosen, the exported CSV will include only the names of the images of the products instead of the entire path/URL. To link the products with their corresponding images, all the images that are related to the products being imported will be downloaded to a zip file.

Export-Images-as-ZIP-file

The Export Images as Zip file option is set to no by default. So if you do not want to export the images in a separate file, you leave the field as it is and go ahead with the export.

When you choose yes, click on the Export Product’s Images button to download the images in the zip file. After downloading the zip file you can export the products into a CSV/XML file.

Click Export Products(CSV)/Export Products(XML) to start exporting products to CSV/XML file respectively.

The exported CSV will be downloaded on your computer automatically.

The following is a screenshot of a sample exported CSV file.

Exporting Products from WooCommerce Products page

Apart from exporting products from our plugin section, you can directly import it from the WooCommerce product page. The products in the WooCommerce products page will be displayed as shown below:

product-page

To export product details, select the products you want to export and select Download Products as CSV from the Bulk Actions drop-down list and click Apply. All the details about selected products will be auto-downloaded to the CSV file.

bulk-actions

Product Reviews Import/Export

The Product Reviews Import/ Export tab allows you to export or import product reviews and ratings of the products by using a CSV file. You can also customize product reviews and ratings according to your needs. This option is mainly used by store owners/admin to move reviews and ratings from one store to another.

For importing product reviews to your online store, you must create a CSV (Comma-Separated Values) file, which contains information about mapping fields in the tabular form. You can create the CSV file by using a spreadsheet application such as Google Spreadsheets or Microsoft Excel. Save this file with extension .csv. After entering all the details about products in the spreadsheet, you can import product reviews to your online store.

It also supports Cron Job (WordPress scheduled task) to schedule importing and exporting of products reviews into an FTP location in a specific time interval automatically.

To configure product reviews import and export, read this article on How to import and export product reviews using WooCommerce Product Reviews Import Export Plugin?.

Batch Export

Batch Export is a technique by which you can export products in batches with a specific batch count. In a single iteration, the specified count of products will be exported within the configured timeout intervals until the entire products are exported successfully.

Product Import Export for WooCommerce-Batch Export

Enable Batch Export by ticking the checkbox.
If you to include hidden metadata while exporting, select the checkbox.
The number of records that the server can process for every iteration within the configured timeout interval can be entered in the Batch Count field. If the export fails you can lower this number accordingly and try again.

Settings

The Settings tab helps in auto-exporting and/or auto-importing products, as well as reviews through FTP. You need to provide your FTP information, time period, and mapping file information among other settings.

Product Import Export-Settings

The following are the settings in this section:

FTP Settings for Import/Export Products: These settings are used to configure FTP settings for importing and exporting products automatically (also known as Cron job). Enable this option to display further settings.

FTP-settings-for-import-export-products

It contains the following settings:

Enable FTP – Check this option to enable FTP settings for product import/export.
FTP Server Host/IP – Enter your FTP Server hostname.
FTP User Name – Enter your FTP username.
FTP Password – Enter your FTP password.
FTP Port – Enter your FTP port number.
Use FTPS – Check this option to use FTPS. FTPS (File Transfer Protocol Secure) is a secured extension of FTP (File Transfer Protocol).
Test FTP – Click on this to check whether your FTP connection is working fine or not.
Export Path – Here you can specify the path where the exported file will be saved on the server.
Export Filename – This section allows you to enter the name the exported file will be saved with.
Automatically Export Products – Enable this option to configure the automatic export of products.
Convert Shortcodes to HTML – Enable this check-box to convert shortcodes to HTML in the CSV.
Product Categories – This field allows you to enter the categories of the products only which will be exported.
Export Start Time – Enter the start time for export. You can enter a time value like 10:10am.
Export Interval [Minutes] – Enter the time interval in minutes for exporting the products.
Include hidden metadata – Check this box to include hidden metadata in the CSV file.
Select an export mapping file – Allows you to select a required export mapping file from the given drop-down list. This field is only available if you have already saved an export mapping file in a prior export.
Automatically Import Products – Enable this option to configure the automatic import of products.
Import File – Enter the complete path on the server of the CSV file to be imported.
Delimiter – In this field, enter the type of the delimiter that the importing CSV file is using.
Import Start Time – Enter the start time for import. You can enter a time value like 10:10am.
Import Interval [Minutes] – Enter the time interval in minutes for importing the products.
Merge Products if exist – Check this option to merge existing products with updated information of the product in the import file. The merging of the product is possible only if the product ID or SKU already exists in your online store. Otherwise, the product is imported as a new product.
Skip new product: If a new product SKU is encountered in the imported CSV file, it will be skipped, and only the existing products will be updated.
Delete existing products: Checking this option will delete the products from the store that are not present in the importing CSV file.
Use SKU to link up-sells and cross-sells: Check this option to link up-sells and cross-sells using the SKU of the product.
New product status: You can change the status of all the products being imported to the status specified in this field (draft/pending/published).
Use SKU to link grouped products: Checking this option will link all the grouped products using the product SKU instead of the product ID.
Select a mapping file – Allows you to select a required import mapping file from the given drop-down list.

FTP Settings for Import/Export Reviews: These settings are used to configure FTP settings for importing and exporting reviews automatically (also known as Cron job). Enable this option to reveal further settings.

FTP-settings-for-import-export-reviews

It contains the following settings:

Enable FTP – Check this option to enable FTP settings for product import/export.
FTP Server Host/IP – Enter your FTP Server hostname.
FTP User Name – Enter your FTP username.
FTP Password – Enter your FTP password.
FTP Port – Enter your FTP port number.
Use FTPS – Check this option to use FTPS. FTPS (File Transfer Protocol Secure) is a secured extension of FTP (File Transfer Protocol).
Test FTP – Click to check whether your FTP connection is working fine or not.
Export Path – Here you can specify the path where the exported CSV file will be saved.
Export Filename – This field allows you to specify the name of the exported CSV file.
Automatically Export Reviews – Enable this option to configure automatic export of reviews.
Export Start Time – Enter the start time for export. You can enter a time value like 10:10am.
Export Interval [Minutes] – Enter the time interval in minutes for exporting the reviews.
Automatically Import Reviews – Enable this option to configure automatic import of reviews.
Import Start Time – Enter the start time for import. You can enter a time value like 10:10am.
Import Interval [Minutes] – Enter the time interval in minutes for importing the reviews.
Merge Reviews if exist – Check this option to merge the existing review with an updated review of the same product.

URL Settings for Import Products – This option allows you to automatically import products (also known as Cron job) from the specified URL.

URL-settings-for-import-products

It contains the following settings:

Enable URL Import – Check this option to enable settings for importing products using URL.
Import URL – Enter the URL path of the CSV file to be imported.
Delimiter – Enter the delimiter the CSV file to be imported is using.
Import Start Time – Enter the start time for import. You can enter a time value like 10:10am.
Import Interval [Minutes] – Enter the time interval in minutes for importing the products.
Merge Products if exists – Check this option to merge existing products with updated information of the product in the import file. The merging of the product is possible only if the product ID or SKU already exists in your online store. Otherwise, the product is imported as a new product.
Skip New Product – If a new product SKU is encountered in the imported CSV file, it will be skipped, and only the existing products will be updated.
Delete existing products – Check this option to delete the products from the store that does not exist in the CSV.
Select a mapping file – Allows you to select a required import mapping file from the given drop-down list.

Finally, click Save Settings to save the settings.

For more information on Cron Job, read Setting Up Cron Job for WooCommerce Product Import and Export.

Tools to reset WooCommerce Products

Go to Dashboard > WooCommerce > Status > Tools section.

In this section, there are four options that are provided by our WooCommerce Product Import Export plugin. They are used for deletion of all products and reviews, allowing you to start all over again.

They are as shown below:

tools-reset-WooCommerce-products

Delete Orphans: To delete variations which have no parent.
Delete Products: To delete all products of your store, allowing you to start afresh.
Delete Variations: To delete all product variations.
Delete Product Reviews: To delete all product reviews.

Check out the features of Product Import Export Plugin For WooCommerce here.

For more understanding of the plugin, check out the product documentation section.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 70,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Was this article helpful?
Yes No

This article posted in Documentation, 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

WebToffee Team

WebToffee Team is a group of WordPress and WooCommerce enthusiasts consisting of expert developers, testing engineers, technical support engineers, and SMEs.

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.

How to Set Up Product Import Export Plugin For WooCommerce – Beginner’s Guide

Overview

Pre-requisites

Installation

Getting started with the plugin

Product Import/Export

Import Products

Merge Products (Update Existing Products)

Export Products

Exporting Products from WooCommerce Products page

Product Reviews Import/Export

Batch Export

Settings

Tools to reset WooCommerce Products

The Best Product Import Export Plugin for WooCommerce

Written by

Comments (28)

Leave a Reply
Cancel reply

Leave a Reply

How to Set Up Product Import Export Plugin For WooCommerce – Beginner’s Guide

Overview

Pre-requisites

Installation

Getting started with the plugin

Product Import/Export

Import Products

Merge Products (Update Existing Products)

Export Products

Exporting Products from WooCommerce Products page

Product Reviews Import/Export

Batch Export

Settings

Tools to reset WooCommerce Products

The Best Product Import Export Plugin for WooCommerce

Written by

Comments (28)

Leave a Reply Cancel reply

Leave a Reply

Leave a Reply
Cancel reply