How to import WooCommerce Products

In this guide we will look at importing Products into WooCommerce using a CSV file.

This guide assumes you already have a Product file ready to import. If not, then check out our how to guide on exporting WooCommerce Products.

Looking for a sample import CSV file? We have prepared a ZIP file with several Product samples.


Step 1

Uploading Products

Importing Products into WooCommerce

Head over to the Product Importer sub-menu under WooCommerce. We are then greeted by the Overview screen. Let's go straight to importing as I'll cover the the tools and advanced settings at the end of the guide.

Importing Products into WooCommerce using Product Importer Deluxe

Here we will upload our CSV file that contains the Products we intend to import. We have a few ways we can import our file.

  • Import Products from a file on your computer
  • Import Products by file path on the server
  • Import Products from file URL
  • Import Products from remote FTP/SFTP

I have my file stored locally on my computer, so I'll select the first option and select my file.


Step 2

Column Mapping

The Column mapping screen is where we ensure that our import will run in the correct fields. Essentially we are matching our fields with the WooCommerce fields.

How to column map WooCommerce Product imports

Product Importer Deluxe automatically matches columns with corresponding WooCommerce field names. If your import file contains custom field names simply select your desired column name from the dropdown.

Use the Sample row to preview column content, double check that columns match their intended content.

Step 3

Import Options

Once we are happy with the column mapping, we will scroll down to Import Options. This is where we select how we want to import the Products into WooCommerce:

  • Import new Products only
  • Delete WooCommerce Products which are referenced in our file.
  • Import new Products and merge Product changes
  • Merge Product changes only
Import new Products and update existing Products in WooCommerce

Image Import Method

Next we will tell Product Importer Deluxe how to handle WooCommerce images during the import.

  • Assigned an image filename column for Products in the import file
  • Assigned an external URL column for Products in the import file
  • I am not uploading Product images

Select the image filename method

  • Image file names are relative to the WordPress Uploads directory
    Images need to be uploaded to: /app/public/wp-content/uploads/2017/12/...
  • Image file names are relative to the WordPress base directory
    Images need to be uploaded below: /app/public/... For instance: product_images/product-1a.jpg|product_images/product-1b.jpg|product_images/product-1c.jpg

Duplicate image control

Select how the importer should handle image duplicates.

  • Create new media items for each duplicate Product image
  • Re-use existing media items where duplicate Product images are detected

Step 4

Advanced Options

The advanced options allow greater control over the import. Skip first row is checked by default (Skip the first row of the import file if it contains column headers. Product Importer Deluxe detects columns headers at upload time and toggles this option if necessary).

How to import bulk WooCommerce options

Take advantage of the other options as you need them.

Start the Import

Now that we have all of our selections, let's import our Products into WooCommerce!
We can check out the real-time log of the import or take a breather.

Quick WooCommerce Product importing Plugin

The import took 27 seconds. That's it! We have successfully imported new Products and merged existing WooCommerce Products.

Bonus

Import Modules for Third-party Plugins

Import WooCommerce Products with third party data

Product Importer Deluxe supports an extensive selection of third-party Plugins. Plugin specific import options automatically display as supported Plugins are detected. You can install and see which supported Plugins are active under the Tools menu in Product Importer Deluxe.

That's it!

Check out the documentation of Product Importer Deluxe for a full breakdown of features.

Happy importing!

Thanks for reading!

Meet our happy customers

Trusted by WooCommerce store owners, developers and professionals.

Can't live without it ;-)

Extremely useful with fast and brilliant support. Thanks!

Plantus   ★ ★ ★ ★ ★

This is a great plugin, does exactly what is says

I got Product Importer Deluxe as it includes Store Exporter Deluxe at a reasonable price. I have an issue with importing Stock by location, this plugin does it and works very well. The support is amazing especially Byron. He helps to the extend, even with importing. Thanks to him.

Msharine   ★ ★ ★ ★ ★

Highly recommended!

This is a great plugin, I got the bundle with Store Importer Deluxe and Store Exporter Deluxe. When I had questions about exporting and importing subscription product variations, support was quick to reply and was able to help me resolve my issue.

Robert Tilton   ★ ★ ★ ★ ★

Visser Labs offered top-notch product support for the Store Exporter plugin!

Couldn't be happier with the purchase!

Matthew Upton   ★ ★ ★ ★ ★

This Plugin, alongside Store Exporter Deluxe, is the linch pin of our website stock management.

Great work guys, on the Plugin and the support.

Luke   ★ ★ ★ ★ ★

Thanks for your help and creating this easy to use Plugin.

Don’t know how you do it, but it makes my life a lot easier.

Brandon Lawrence   ★ ★ ★ ★ ★

(close)

Log In

 Forgotten Password? 

Register Sign Up

When you register you can easily:

  • Manage your Plugin downloads
  • Raise support requests with Visser Labs
  • Interact with the Visser Labs community