If you are setting up a new WooCommerce store or migrating from one to another, there are a lot of things that need to be done. Setting up products in it would be one of them. Adding products one by one to your WooCommerce store might not be a good move especially if your old store consists of hundreds and thousands of products in it. Here the only option is to import products.

Importing products from one WooCommerce store to another can be easily enabled with the built-in import feature in WooCommerce. This article will give you a step by step explanation of how it is done.

In order to import products into your WooCommerce store, you first need to have a CSV file containing all the product details in it. If you do not have one, you can create one either by exporting your existing store’s products or you can create a CSV from scratch. You can use a spreadsheet program, such as LibreOffice, Microsoft Excel, OpenOffice or Google Spreadsheets for creating and modifying the CSV file. Save this file with the extension “.CSV”.

Steps for Importing Products in WooCommerce

Follow the below steps to import products in WooCommerce.

Step 1 – Navigating to the Import window

Go to your WordPress dashboard and navigate to Products > All Products.

product navigation

Now another window opens up displaying all products in your WooCommerce store.

existing products

Click on the Import button. 

Step 2 – Upload CSV file

In the opening window, upload the CSV containing the products to be imported.

choose import file

If your store doesn’t have any existing products, you can leave the Update existing products checkbox empty. This feature is for updating your store’s existing products.

Now click Continue.

Step 3 – Column mapping

In the next window, you will be taken to the column mapping window. Here WooCommerce automatically tries to map fields from your CSV file against product fields. You can choose “do not import” from the drop-down if you want to ignore those fields from getting imported.

column mapping

Now click Run the importer button.

This will start the import process and you will be greeted with an “import successful screen” once it is completed. Here is a screenshot of it.

completed import

Now by clicking on the View products button, you will be able to see all the imported products.

imported products


WooCommerce has indeed done a great job by coming up with this awesome feature using which people could easily transfer product data from one WooCommerce store to another. But as with everything, this option has its limitations too. Thus if you have a bigger store with thousands of products and less time for its management, you had better go for the product import premium extensions which will help reduce your workload way better.

Leave a Reply

Your email address will not be published. Required fields are marked *

Latest Posts

How to Find & Delete Unused Images on WordPress Sites in 2024

Imagine you are running an online shop with thousands of products, eac...

The Power of Personalization: Driving Sales with Strategic Product Recommendations

Today’s customers appreciate and value online personalization. Onlin...

How Can I Optimize eCommerce Product Pages for Increased Conversions?

The eCommerce landscape is booming, and online shopping is becoming an...