Do you want to import & export WooCommerce products with images?
Importing or exporting WooCommerce products with images allows you to easily move your store or add new products in multiple stores.
In this article, we will show you how to import & export WooCommerce products with images.
Why Import & Export WooCommerce Products? How to Import & Export WooCommerce Products with Images?
Many users need to import and export WooCommerce products for several reasons.
Now normally if you are moving your website to a new server, then you can just duplicate your entire website and set it up on your new host.
We have a complete step-by-step guide for that, see how to easily move WordPress to a new host or server.
On the other hand, if you only want to move products, then this tutorial will help you learn how to properly export and import WooCommerce products with images and other product data.
We’ll show you two methods, you can choose one that works best for you.
Method 1. Import & Export WooCommerce Products without a Plugin
WooCommerce comes with built-in functionality to easily import and export products with images, but without using any additional plugins.
First, you need to visit the Products » All Products page in your WordPress admin area. There, you will see two buttons at the top to ‘Import’ or ‘Export’ products.
Let’s first check out how the export feature works.
Exporting WooCommerce Products without Using a Plugin
Simply click on the ‘Export’ button at the top to continue.
On the next screen, you’ll see a bunch of options to choose what data you want to export.
For instance, you can choose to only export certain columns from product data. You can also choose to export specific product types or products in specific categories.
To export all products with images and all other data, you can leave these options unchecked.
Optionally, you can check the ‘Export custom meta.’ If you are unsure, then it’s better to check it so that you have the data.
Go ahead and click on the ‘Generate CSV’ button to continue.
WooCommerce will now prepare a CSV file and download it to your computer.
What is a CSV File?
CSV is short for Comma Separated Values, and it is a file type of plain text that separates different columns or fields of data with a comma.
You can open it with any spreadsheet software like Google Sheets or Microsoft Excel. Here is how it would look:
Importing WooCommerce Products without Using a Plugin
Simply go to the Products » All Products page and click on the Import button at the top.
If your WooCommerce store is empty, then instead of the buttons at the top, you will see buttons at the center of the page.
Click on the ‘Start Import’ button to begin the import.
This will bring up the import wizard.
First, you need to click on the ‘Choose File’ button to select the WooCommerce export CSV file you downloaded earlier.
Click on the continue button to upload the CSV file.
WooCommerce will now check to see if your CSV file is in a compatible format. After that, it will ask you to map that data to existing WooCommerce product data.
The default settings here will work for most WooCommerce stores.
However, you still need to review if a column is missing, and then click on the drop-down menu next to it and select a matching field if available.
Particularly, if you are using variations attribute for products, then make sure to scroll down to the attributes columns and match fields.
This will allow you to ensure that the fields in your CSV file match the corresponding WooCommerce fields.
Click on the ‘Run’ Importer button to begin.
WooCommerce will now start importing data from CSV files. It will also download any images attached to your products.
Once finished, you can visit the Products » All Products page to see the imported products.
Make sure to visit your shop and product pages to check that everything is working as expected.
Method 2. Import & Export WooCommerce Products with a Plugin
For this method, we’ll be using a plugin to import and export WooCommerce products.
The advantage of this method is that it offers more flexible options and also allows you to export / import product reviews.
Plus, it allows you to import/export WooCommerce products in batches which comes in handy if you have a large store with many products and images.
Exporting WooCommerce Products with a Plugin
First, you need to install and activate the Product Import Export for the WooCommerce plugin. For more details, see our step-by-step guide on how to install a WordPress plugin.
The plugin comes as three separate add-ons. You’ll need to download and install all of them.
Upon activation, you need to visit the Webtoffee Import Export (Pro) » Export page and select ‘Product’ as the post type you want to export.
On the next screen, you need to select an export method.
The default Quick Export method automatically selects all your products for export.
Optionally, you can also choose ‘Advanced Export’ which allows you to filter products by category, tag, and status.
You can also exclude individual products manually.
Click on the Export button to continue and the plugin will start preparing your product data.
Once finished, you’ll be prompted to download the export file to your computer.
Importing WooCommerce Products with a Plugin
Now that you have your export file ready, you can use it to import products on another WooCommerce store.
Simply install and activate the Product Import Export for WooCommerce plugin on the store where you need to import the products.
After that, go to the Webtoffee Import Export (Pro) » Import page and select ‘Product’ as the post type you want to import.
Click on the ‘Step 2: Select import method’ button to continue.
Next, you need to select an import method and upload the exported file you downloaded earlier to your computer.
Click on the ‘Step 3: Map and Import Columns’ button to continue.
On the next screen, you’ll see a list of fields and the matching fields from your import file. If you see an empty field, you can choose a matching field for it in the next column.
If you are using product variations like sizes and colors, then make sure to click on the Attributes tab to match attribute fields.
However, if you are not using any products with variations or custom attributes then you can use the default settings.
Click on the ‘Step 4: Advanced Options / Batch Import’ button to continue.
On the final screen, you’ll see advanced options. For instance, you can choose to match products by ID or SKU, choose what to do if a product already exists, and more.
If you are importing products into an empty WooCommere store, then you can use the default settings.
Finally, click on the ‘Import’ button to run the product import process.
You’ll see the progress of the import on the screen. Once finished, you can click on ‘View Products’ to check if everything has been imported correctly.
The plugin also allows you to import and export Product Reviews.
If you want to import or export the product reviews too, then simply choose the ‘Product Reviews’ post type on the import or export page.
Improve Your WooCommerce Store with automation
If you find yourself doing a lot of manual work around your WooCommerce store and want to save time, then we recommend using Uncanny Automator for workflow automation.
Uncanny Automator helps you connect over 100+ plugins and apps with a simple no-code visual builder. You can use it to create automated workflows for things that you normally do without writing any code.
There’s a free version that you can try out, and it’s already used by over 20,000 websites.
Aside from workflow automation, if you’re looking for a marketing automation tool for WooCommerce, then we recommend using FunnelKit Automation. It will help you grow your sales and improve conversions without the high costs.
We hope this article helped you learn how to easily import and export WooCommerce products with images in WordPress. You may also want to see our pick of the essential WooCommerce plugins or see these practical tips on recovering abandoned cart sales in WooCommerce.