How to Import Thousands of WooCommerce Products

Video Guide

Text Guide

In this short tutorial, we want to show you how to save many hours of hard work by creating hundreds of WooComerce products from a simple CSV document. You can create products from Excel or Google Sheets and simply import that information to create them in minutes.

In addition, you can edit these new products to complete the rest of the information in just a few minutes, either individually or massively using a powerful Bulk Edit tool.

Of course, we know this sounds too easy. But it really is. Using an intuitive spreadsheet, you can create, filter and edit hundreds or thousands of WooCommerce products.

To do this, you need to install the WooCommerce Products Spreadsheet plugin. This plugin creates a spreadsheet for all your products so that you can edit any field of your products in just a few minutes.

Once installed and activated, just follow these simple steps:

1- Create your products in Excel or Google Sheets

To create your products, you need to have a basic CSV file created with Microsoft Excel or Google Sheets. For this CSV file you need to create at least the following columns:

  • Name: Product title/name
  • Regular Price: Enter the product price
  • Description: Product short description
  • Manage Stock: Use the yes value
  • Stock: Enter the number of products you’ll have in stock

import-thousands-woocommerce-products

Once you have prepared a CSV file like this, you’re ready to import all your new products to WooCommerce.

2- Import the CSV file to WooCommerce

To import our CSV file, you need to go to Sheet Editor > Edit Products to open the products spreadsheet.

import-thousands-woocommerce-products

Now, you need to open the Import tool. This tool will help you import all the information you’ve saved in the CSV file to create your products.

import-thousands-woocommerce-products

After that, you need to select the CSV file from your computer. For that, select the CSV file from my computer option in the Source dropdown. Then, click on Next.

import-thousands-woocommerce-products

Now, just click on Import all the columns.

import-thousands-woocommerce-products

In Do you want to update or create items, you can select Import all columns as new if all the products are new, and the click on Next.

Note – You can also select one of the options to update existing products.

import-thousands-woocommerce-products

Finally, click on The preview is fine, start import, and you’ll be done.

import-thousands-woocommerce-products

Done!

This is how you can quickly create thousands of products out of a CSV file you’ve created with Microsoft Excel or Google Sheets. For example, if one day you want to create products but don’t have an internet connection, you can work on the CSV file in Excel or even on a tablet or cellphone. When you have an internet connection again, just import your products.

Recommended tutorials:

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.