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