How to Import Thousands of WooCommerce Products

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.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

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

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.

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.

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.

Now, just click on Import all the columns.

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

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

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.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

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.

Close Menu