How to import WooCommerce Products

In this guide we will look at importing Products into WooCommerce using a CSV file. I'm assuming you already have a file of Products 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 two samples.
Download 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.

Happy Importing!

Thanks for reading!

If you would like to export Products and more from WooCommerce check out our Store Exporter Deluxe Plugin.

Product Importer Deluxe for WooCommerce

★ ★ ★ ★ ★

Single Site

Import Excel and CSV easily

$99
  • Free future updates
  • Automatic Plugin updates
  • Premium Support
Add to cart

Unlimited Sites

Perfect for developers

$245
  • Free future updates
  • Automatic Plugin updates
  • Developer Support
Add to cart

Recent Reviews

Love this Plugin!

It's saved me massive amounts of time in analysing data and doing mass Product updates

US Ron, 3 months ago

We use Product Importer Deluxe everyday and rely heavily on it working well every time for syncing data, stock, etc across our marketplaces.

This is a great tool standalone or better still with Store Exporter Deluxe.

AU Tim, 5 months ago

I can't speak highly enough of my experience using this product!

I'm a novice however I had no problems uploading 8,000+ Products complete with images and custom meta data using the Plugin's simple interface.

AU MimsTech, 5 months ago

(close)

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