Table of Contents
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.
Now another window opens up displaying all products in your WooCommerce store.
Click on the Import button.
Step 2 - Upload CSV file
In the opening window, upload the CSV containing the products to be imported.
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.
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.
Now by clicking on the View products button, you will be able to see all the 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.