Visser Labs – WooCommerce Plugins

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.

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.

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.

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

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.

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!

Get WooCommerce Product Importer Deluxe here. Happy importing!

Was this article helpful?

Related Articles

Visser Labs – WooCommerce Plugins
  • PO BOX 4362 Gumdale QLD Australia
  • ABN: 51 604 474 213
  • We're hiring remotely!

© 2023 Rymera Web Co Pty Ltd. All Rights Reserved. ABN 51 604 474 213. All prices are in USD.