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.
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.
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.
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.
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.
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
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
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).
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.
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
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.
Check out the documentation of Product Importer Deluxe for a full breakdown of features.
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!
★ ★ ★ ★ ★
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.
★ ★ ★ ★ ★
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.
★ ★ ★ ★ ★
Visser Labs offered top-notch product support for the Store Exporter plugin!
Couldn't be happier with the purchase!
★ ★ ★ ★ ★
This Plugin, alongside Store Exporter Deluxe, is the linch pin of our website stock management.
Great work guys, on the Plugin and the support.
★ ★ ★ ★ ★
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.
★ ★ ★ ★ ★