WooCommerce any product type import as csv

July 27, 2015

As a first step ensure that “WooCommerce” plugin has been installed, and activated in wp-admin plugins. Before importing the CSV file you should enable WooCommerce import module in wp ultimate CSV importer pro plugin in selecting “settings” in the drop down menu and then select “eCommerce settings”. In the enable/disable option select “enable”.

Woocommerce Module settings

To import product CSV file select WooCommerce->product import in the drop down menu. Our plugin supports four different options, to import a CSV file. They are upload file, upload using FTP, upload from external, choose file in the server. Select anyone of the above mentioned options to upload. “Import” and “update” buttons are enable only after the CSV file was uploaded. “Reset” button is used to delete the uploaded CSV file. Select “import” to continue.

Woocommerce import menu

 

In the mapping page, you need to map three mapping fields for WooCommerce such as “core fields”, “Terms/Taxonomies Fields” and “eCommerce Meta Fields”. “Core fields” is for mapping the basic WP fields. “Terms / Taxonomies Fields and eCommerce Meta Fields” are used for mapping the WooCommerce fields.

WooCommerce field attribute mapping

 

Core Fields:

In “Post Title” field, specify the “product name” and this field is mandatory.

If you want to insert images, mention the image name with inline image short code in the “Post Content” field.

Post Excerpt” field is for describing the product. In the “Post Date” field, specify the date of publishing.

In the “Post Author” field, specify the author of the product.

Featured image” field is used to include images, specify the image URL or shortcode.

 

Terms / Taxonomies Fields:

Product categories and product tags are mapped in this field

WooCommerce taxonomy mapping 

eCommerce Meta Fields:

For, simple product specify 1 Grouped produced specify 2, External/Affiliate product specify 3, Variable product specify 4 in the CSV file.

 Woocommerce simple product

 

WooCommerce simple product mapping

  

Simple product:

A simple product is a product with no variations. If your product is a virtual product then it doesn’t need shipping. If it is downloadable and virtual product(specify “yes” in the CSV file)means you should specify SKU(stock keeping unit – it is unique id for each product) and also specify the regular price, sale price, download Limit, downloadable files, download type, download Expiry, stock status(For “In stock” you should mention 1 and for “Out of stock” mention 2 in the CSV file.

For enabling the “manage stock” specify “yes” otherwise specify “no” in the CSV file. If the manage stock is mentioned as “yes” then you should specify the Stock quantity and allow back orders. If you want the product to sell individual, then specify “yes” otherwise specify “no”. UpSells Id and CrossSells Id means other product ID which you want to recommend. If your product is not a virtual product means, then specify the shipping details such as shipping class, weight, dimensions.

 

Grouped product:

Grouped product means a group of related products. It is similar to a simple product, except shipping, virtual and downloadable options.

WooCommerce grouped products 

External/Affiliate product:

In this type of product, you must specify product URL(external URL of the product) and Button text(text to be displayed on the button). All the others are similar as a simple product.

Variable product:

It  is a product which has distinct variations. You must specify SKU, weight, dimensions.

Shipping option is not available in Grouped product and External/Affiliate product.

The virtual and downloadable option is available only in a simple product.

 

Woocommerce product meta field mapping

 

After mapping, select “Next”. In the next page, you will see the summary of mapped, unmapped fields and total no. of records. Click “Proceed Import” to continue. By default “Import right away” option is enabled. To import immediately choose “import right away” option. “Schedule now” option is used to import later.

Press “Next” to continue and then click “Import now”. In the next page “Import completed successfully” message will be displayed that means your CSV file was successfully imported. Click “admin view” or “web view” to verify.