How to Import & Export WooCommerce Products with Images

28

Do you want to import and 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 easily import and export WooCommerce products with images.

How to Import & Export WooCommerce Products with ImagesHow to Import & Export WooCommerce Products with Images

Why Import & Export WooCommerce Products?

Many users need to import and export WooCommerce products for a number of reasons.

  • You may want to move products from one WooCommerce store to another
  • You may want to start an online store with a new WordPress website but with the same WooCommerce products
  • You may want to move your website to a new server but need a better way to move products
  • You may want a faster way to add your products to multiple stores that you manage
  • and more

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.

Import export WooCommerce productsImport export WooCommerce 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.

Default WooCommerce product export optionsDefault WooCommerce product export options

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 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:

CSV file opened in spreadsheet softwareCSV file opened in spreadsheet software

Importing WooCommerce Products without Using a Plugin

Simply go to the Products » All Products page and click on the Import button at the top.

Import productsImport products

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.

Start import Start 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.

Choose import fileChoose import file

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.

Map columnsMap columns

The default settings here will work for most WooCommerce stores.

However, you still need to review and 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.

Match attribute fieldsMatch attribute fields

This will allow you to ensure that the fields in your CSV file match the corresponding WooCommerce fields.

Click on the ‘Run’ the Importer button to begin.

WooCommerce will now start importing data from CSV file. It will also download any images attached to your products.

Products importedProducts imported

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 WooCommerce plugin. For more details, see our step-by-step guide on how to install a WordPress plugin.

The plugin comes as three separate addons. You’ll need to download and install all of them.

Download pluginsDownload plugins

Upon activation, you need to visit the Webtoffee Import Export (Pro) » Export page and select the ‘Product’ as the post type you want to export.

Exporting WooCommerce products using a pluginExporting WooCommerce products using a plugin

On the next screen, you need to select an export method.

The default Quick Export method automatically selects all your products for export.

Quick export methodQuick export method

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.

Advanced filtering optionsAdvanced filtering options

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.

Download export fileDownload export file

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.

Import products using a pluginImport products using a plugin

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.

Import methodImport method

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.

Map fieldsMap 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.

Import optionsImport options

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 screen. Once finished, you can click on ‘View Products’ to check if everything has been imported correctly.

products importedproducts imported

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 ‘Product Reviews’ post type on the import or export page.

Import or export product reviewsImport or export product reviews

Improve Your WooCommerce Store with Automations

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.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.