WebToffee Logo
  • Home
  • Plugins
  • Blog
  • Documentation
  • Support
Login
0

  • Product Import Export Plugin for WooCommerce - Overview
  • Pre-requirements for Using the Plugin
  • Installation of the Plugin
  • Getting Started with the Plugin
  • How WooCommerce Mapping Works?
  • Exporting Products Using the Plugin
  • Importing Products Using the Plugin

Product Import Export Plugin for WooCommerce – User Guide

Last updated on October 9, 2020

This article is a complete documentation of the basic version of the Product Import Export Plugin for WooCommerce, using which you can import, export, and update products in bulk.

By going through it, you will be able to quickly develop an understanding of how to set up and use this plugin, get an overview of its features, and learn about how this plugin works.

Product Import Export Plugin for WooCommerce – Overview

Product Import Export Plugin for WooCommerce lets you import and export products to and from your WooCommerce store in CSV file format. Using this plugin you can export products to a CSV and use this file as input to import them into your WooCommerce store. 

The plugin supports the import and export of simple product types. You can easily transfer hundreds or thousands of products to and from your store, bulk update their data, etc., with the help of this plugin.  

Pre-requirements for Using the Plugin

  • The plugin takes CSV (Comma-separated values) as input for import. You can create a CSV in two ways.
    • By exporting/downloading products from the WooCommerce store.
    • Using a spreadsheet program such as LibreOffice, Microsoft Excel, OpenOffice, or Google Spreadsheets and saving the file with the extension ‘.csv’. 
  • The CSV Import file must be in UTF-8 format, if you need to know more about it read How to save CSV / Excel File as UTF-8 Encoded?

Installation of the Plugin

You can install the plugin by following the below steps.

Step 1 – Navigate to Plugins > Add new from the WordPress dashboard. 

add product import export plugin from WordPress repository
Installation of the plugin

Step 2 – Enter the keyword ‘Product import-export’.

Step 3 – Click Install Now and Activate. 

Getting Started with the Plugin

Upon installation of the plugin, you can open the plugin settings page in two ways. By navigating to either, 

  • WordPress dashboard > WooCommerce> Product Import Export

                                                 or

  • Plugins > Installed Plugins > Product Import Export

The following is a screenshot of the opening window of the plugin.

Product Import export plugin opening window
Plugin opening window

How WooCommerce Mapping Works?

Before proceeding with the importing and exporting of products, you need to know how WooCommerce mapping works. 

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. You have to map all the fields in the correct format if you want the plugin to work correctly. If there is any mistake in your import file, your product import may not work as expected.

The following table gives you information on each column/tag header in WoCommerce, its explanation, and its accepted value or format.

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
WooCommerce data fields

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

Exporting Products Using the Plugin

Using this plugin you can export or download your products in CSV file format. This file can be used to import products back into your WooCommerce store.

Following is a screenshot of the export settings page of the plugin.

export window for product import export plugin
Export settings page

The export settings window contains the following fields to configure.

Offset – It is the number of products to skip before exporting. If the value is 0, no products are skipped. If the value is 100, products from product id 101 will be exported.

Limit – Here you can give the number of products you wish to export. If you leave this field empty, no products will be exported. It is useful when you have a large number of products and want to export only a partial list of products.

Columns – Here you can configure how the column header names should appear in the CSV. By default, the column header names are the same as the WooCommerce product field name. You can also select the product fields (product data) you wish to export by selecting them one by one. 

Now you can click the Export products button to finish with the export process. 

Importing Products Using the Plugin

Here you can import all products from the CSV file to your store. The import process has been divided into two steps; import settings and import mapping.

Product import settings window
Import settings page

Select a file from your computer – Upload the CSV file containing product data from your computer. The maximum supported file size is 1GB. 

Update products if exists –  Existing products are identified by their SKUs/IDs. If this option is not selected and if a product with the same ID/SKU is found in the CSV, that product will not be imported. You can also perform bulk product update by selecting this checkbox. 

Delimiter  – Here you can select a delimiter to separate the field values with. Comma is the default delimiter. 

Merge empty cells – If this option is checked, empty attributes will be added to products with no value. You can leave this unchecked if you are not sure about this option.

Now you may move on to the next step by clicking the Proceed to Import Mapping button. 

import mapping window
Import mapping window

This section allows you to map your imported CSV columns to the corresponding product data fields. It’s been divided into three different columns.

  • WooCommerce product fields – It represents WooCommerce product field names to which attributes will be mapped.
  • CSV column header (from imported file) – Represents CSV headers which will be mapped to appropriate WooCommerce product fields.
CSV column data for mapping
CSV column data for mapping
  • Evaluation field – This column is used to modify/update the value of product fields mapped during the import process. You can apply custom rules to hundreds and thousands of product data using this feature. 

By hovering over the question mark next to the evaluation field header, you will be able to see how you can update the values.

Evaluation field
Evaluation field data on hovering over (?) symbol

Assign any required constant value to field –
For example, to assign the value red to ‘attribute:pa_color’, enter the value ‘=red‘ in the evaluation field of the attribute:pa_color row.

Add any required value to the field –
For example, to add $5 to ‘sale price’ enter the value ‘+5 ‘in the evaluation field of the Price: Sale Price row.

Reduce any required value from the field –
For example, to reduce ‘$5’ from ‘sale price’ enter the value ‘-5’ in the evaluation field of the Price: Sale Price row.

Multiply by any required value to the field –
For example, to multiply ‘sale price‘ by ‘1.05’, enter the value ‘1.05’ in the evaluation field of the Price: Sale Price row.

Divide by any required value to the field –
For example, to divide ‘sale price’ by ‘2’, write ‘/2’ in the evaluation field of the Price: Sale Price row.

Append any field by required value –
For example, to append ‘Product Title‘ by ‘By HikeForce’, write ‘&By HikeForce’ in the evaluation field of the Product Title row.

Prepend any field by required value –
For example, to prepend ‘Product Description‘ by ‘Description’, write ‘&Description[VAL]’ in the evaluation field of the Product Description row.

Once you are done with the mapping, proceed to click the Start Import button to finish with the import process. 

Import complete window
Import complete window

Important Note: The time duration for importing products depends on the time taken to fetch the images and the internet speed available to you. If you have more than 1000 products, it is recommended to do the import in batches by splitting the CSV file. Please do not navigate away or close the window while the import is in progress.

  • Was this article helpful?
  • YesNo

Tagged Product import export plugin, WooCommerce mapping, WooCommerce product import, WooCommerce product import plugin, WooCommerce product upload

Written by

Haritha

Haritha writes for WebToffee on everything related to WordPress/WooCommerce plugins in simple tutorials, blogs, and documentation to help run your WooCommerce store.

Leave a Reply

Cancel reply

Your email address will not be published. Required fields are marked *

We develop awesome WordPress plugins & WooCommerce extensions to help build successful online businesses.

Get Started

  • Plugins
  • Testimonials
  • Affiliates

Help & Support

  • Documentation
  • Documentation (Basic)
  • FAQ
  • Support

Company

  • Terms & Conditions
  • Privacy Policy
  • Refund policy
  • License Activation

© 2021 WebToffee. All rights reserved.

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of the basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website, to store user preferences and provide you with content and advertisements that are relevant. Such cookies will be stored on your browser but only upon procuring consent.

You will also have the option to opt-out of these cookies should you want to. But opting out of some of these cookies may have an effect on your browsing experience as per the descriptions elucidated against the respective categories below.

Necessary
Always Enabled

The cookies defines under this category are absolutely essential for the website to function. Hence they are loaded by default irrespective if user consent.

CookieDescription
PHPSESSIDThis 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_policyThe 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.
Analytics

Analytics cookies help us understand how our visitors interact with the website. It helps us understand the number of visitors, where the visitors are coming from, and the pages they navigate. The cookies collect this data and are reported anonymously.

CookieDescription
_gaThis 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_gtagIdentification code of website for tracking visits.
_gidThis 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.
_hjidHotjar 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.
_hjIncludedInSampleThis 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_activityThis cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_aiGathers 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_lrThis cookie is set by JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack
tk_orThis cookie is set by JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack
tk_qsGathers 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_r3dThe cookie is installed by JetPack. Used for the internal metrics fo user activities to improve user experience
Advertisement

Advertisement cookies help us provide our visitors with relevant ads and marketing campaigns.

CookieDescription
_fbpThis 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.
frThe 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.
Preferences

Preference cookies are used to store user preferences to provide them with content that is customized accordingly. This includes the language of the website or the location of the visitor.

CookieDescription
_gh_sessThis cookie is used to preserve users states across page requests.
Save & Accept