How to Import WooCommerce Products into WordPress with CSV Importer

WooCommerce is the world’s fastest growing eCommerce platform. Hosting and managing an ecommerce store is a tough task. Import your WooCommerce products and stocks to automate the manual process of create or updating the product using WordPress Ultimate CSV Importer.

This helps you to bypass lot of mundane manual process of updates like stock update, price update, product update and similar new additions.

The importer is capable to import all Simple, Variable, Grouped and External/Affiliate product types. You can use any simple XML/CSV editor or spreadsheet editor and create your CSV / XML.

The WooCommerce product information in CSV and XML are scheduled to get the work done easy and automated without any manual intervention. It keeps your eCommerce site updated by importing and updating product information at scheduled intervals.

As a first step ensure that “WooCommerce” plugin got installed, and activated under wp-admin>>plugins menu. Before importing the CSV file, you should enable the WooCommerce import module in WP ultimate CSV importer pro plugin. Go to “settings” in the dropdown menu, select “eCommerce settings”. Next select “enable” from the enable/disable option as shown in below image.

How to enable woocommerce products import suite in ultimate csv importer module setting

To import product CSV file select WooCommerce >> Product import from the dropdown 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 becomes visible after CSV file was uploaded. “Reset” button is used to delete the uploaded CSV file. Select “import” to continue.

Woocommerce products import page in wp ultimate csv importer plugin

Diffenent types of WooCommerce Products import options explained

WordPress Ultimate CSV Importer imports CSV/XML in bulk with all product type data in a single file. The import done in few simple steps.

To Upload CSV/XML file

WordPress Ultimate CSV Importer lets you to upload your CSV/XML in four different methods. Upload file from the local computer, FTP, external link and server.

You can choose any one of the methods to upload your CSV/XML file. And click on ‘Import’.

Map the csv header or xml nodes with wordpres fields

To Map the header/node with WordPress fields

In mapping section, the default product fields and custom fields grouped under the WordPress core fields. The product meta fields listed under eCommerce meta fields group. Each fields grouped in its own specified section.

If the headers/nodes are same as WordPress fields, it will get mapped by default, or choose the corresponding field from the dropdown.

To schedule an import

  •  After mapping the required column check on ‘Save this mapping as a template’ at the bottom
  •  Hit save it as a template.

map the csv header or xml wordpress fields
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” used for mapping the WooCommerce fields.

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 short code.

Terms / Taxonomies Fields:

Product categories and product tags mapping in this field

Woocommerce tax and taxnomy 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 csv file
Woocommerce products mapping

Summary view of the mapped fields

In the summary view, verify details of the mapped and empty fields. It lists all the WordPress fields and corresponding CSV header or XML nodes mapped.

Import summary mapping field

To Import or Schedule CSV/XML

You can eliminate duplicates products import with product title and content. You can import selective products or a range of products from the CSV/XML by specifying row number under ‘Import specific records only’ option.

To import Schedule csv and xml file

Import with run-time log

If the import triggered, the records imported based on your server configurations. The real-time log generated with Admin and Web view links of the each imported record.

Woocommere products import log on wp ultimate csv importer plugin

To Update WooCommerce Products

WordPress Ultimate CSV Importer keeps your WooCommerce product updated by updating or inserting the new field into the existing product.

The product is updated based on the product title. If the existing product title doesn’t match the title, the record will inserted as a new record.

Upload the CSV/XML to update the existing WooCommerce product with anyone of the 4 methods. Click on ‘update’ to choose any previously created mapping template.

Mapping templates are the user defined list of mapped CSV headers or XML nodes to the WordPress fields. If none of them matches your current update you can choose fresh update to create a new mapping template.

Updated woocommerce products import in wp ultimate csv importer plugin

If you choose fresh update,

  • Map the required CSV headers or XML nodes to the WordPress fields.
  •  And save the current mapping as a template.
  •  The update will executed based on the new created template.

The summary view of the mapped fields and the Import or Schedule CSV/XML procedure is same as the import process. The update can performed for the specific range of records in the uploaded file.

If the process completed, the real-time log generated to show the updated record details.

If the import scheduled, it will get triggered by the cron on the specified date and time as per the setup.

WooCommerce Each Product Type Import Explained

Simple product:

A simple product, is a product with no variations. If your product is a virtual product, 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 specify the regular price, sale price, download Limit, downloadable files, download type, download Expiry,
  • Add 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” or specify “no” in the CSV file. If the manage stock mentioned as “yes”, you should specify the Stock quantity and allow back-orders.

If you want the product to sell individual, specify “yes” or specify “no”. UpSells Id and CrossSells Id means other product ID which you want to recommend.

If your product is non virtual product, 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 import in wp ultimate csv importer plugin

External/Affiliate product:

In this type of product, must specify

Must specify

  • Product URL (external URL of the product)
  • Button text (text to 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 excluded for Grouped product and External/Affiliate product.

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

Woocommerce products meta fields in wp ultimate csv importer plugins

After mapping, select “Next”. In the next page, you will see the summary of mapped, non mapped fields and total no. of records.

Click “Proceed Import” to continue. By default “Import right away” option is ON.

To trigger import choose “import right away” option. “Schedule now” option used to import at scheduled time.

Press “Next” to continue and click “Import now”.

In the next page “Import completed successfully” message will displayed that means your CSV file import is success.

Click “admin view” or “web view” to verify.

Step by step tutorial to Import WooCommerce Products using Ultimate CSV Importer

This tutorial describes how to use Woo Commerce plugin in our WP Ultimate CSV Importer. It guides to import CSV file and to perform mapping configuration by simple steps.

Video: WooCommerce CSV Importer with product variations using WP Ultimate CSV Importer 3.6

Description :

This video describes how to use WP Ultimate CSV Importer for WooCommerce CSV import for

  • Each product type,
  • Set of variations,
  • List of attributes
  • And their values

All above items managed as single CSV.

This guides us to import a complete controlled CSV file and to perform mapping configuration by simple steps as from single CSV. It helps to import a complete controlled CSV file and to perform mapping configuration by simple steps.

Steps in Video Explained

How to Enable WooCommerce menu in our WP Ultimate CSV Importer

Here are some steps to enable WooCommerce product menu:

  •  After activating our WP Ultimate CSV Importer plugin, go to “Settings” tab in the plugin
  •  Select “Third Party Plugins” and enable “WooCommerce”
  • Click “Save” button to save the settings
  • Now you can view the “WooCommerce” menu next to “Dashboard” tab.

Refer the screenshot shown below to enable “WooCommerce” menu

Woocommerce Setting in wp ultimate csv importer plugins

How to Import CSV File

1. After enabling WooCommerce in our WP Ultimate CSV Importer, go to “Imports” menu and select “WooCommerce” tab
2. You can upload CSV file by four ways. You can follow any one way to upload it.
3.Upload file from your computer

This is the simplest way. You can directly upload the CSV file from your computer. Click “Browse” button and select the CSV file from your computer.

  • Download file from your FTP Server

You can upload the file directly from your FTP server. Provide FTP host, port, username, password and URL for the file. Click “Download” button to import the specified file.

  • Download File From URL

Here you can upload the file by specifying URL of the file. After that click “Download” button.

  • Use already uploaded file

If you want to use already uploaded file, go to the path and select the file

1. After upload the CSV file by any of the methods, select the delimiter. It may be , (comma) or ; (semicolon). For our sample CSV file, the delimiter is ; (semicolon).
2. Click “Next” button to complete the uploading process.

Woocommerce Browser in ultimate csv importer plugins

Woocommerce import data configuration

  • After perform mapping, go to “Settings and Performance” tab
  • If you want to delete the duplicate post content and title, enable the corresponding checkbox
  • Provide number of import per server record. Example: 1, 2, 3, etc. If it is 2, it imports the record two times.
  • Provide the specific number of records to import from your file. Example: 3, 1-5, etc. If its 3, it import the third record from your file. If its 1-5, it imports first five record from your file.
  • Click “Import Now” button to import the records from your CSV file

  • Next logs get generated and your file import is success
  • Go to “Products” menu in WP-Admin Panel and you can view the product that created using your CSV file

Note : you can Download sample CSV and try our live demo to better understand the import process. Or you can refer our product page and documentation to know more about the WordPress Ultimate CSV Importer WooCommerce features.

If you need further assistance you can write to us at [email protected]. You can read more about latest features in our WordPress products in our blogs.

Cookies help us deliver our services. By using our services, you agree to our use of cookies.