If you have a huge amount of products that you want to upload to your WooCommerce store, manually entering the products and its details are far from practical. Using the Product Import Export plugin for WooCommerce, you can upload all the products and product types (simple, variable, grouped, and external) in bulk with incredible ease.
Most people opt for maintaining a spreadsheet, CSV, or XML file of product data. It makes the manipulation of the data easier on a larger scale. To upload products to your WooCommerce store, the Product Import Export Plugin for WooCommerce takes a CSV or XML file as input.
The articles on Importing WooCommerce Products from Microsoft Excel File and the article Importing and Exporting Products to Google Spreadsheets will help you more on how to bulk import products from these two popular spreadsheets.
Another important factor when using a CSV file with Product Import Export Plugin for WooCommerce is that it should be UTF-8 encoded. Refer to the article, Saving CSV/Excel File as UTF-8 Encoded, to know how simple it is to do so and encode your spreadsheet by yourself.
Steps to Bulk Upload Products
When you want to bulk upload the products to a WooCommerce store using a CSV or XML file, what you are essentially doing is importing the products in the CSV or XML file into the WooCommerce store. So, to import the CSV or XML file, go to the WooCommerce store, install and activate Product Import Export for WooCommerce.
After the plugin has been activated, navigate to the WooCommerce store dashboard, and then go to WebToffee Import Export (Pro) > Import.
- For uploading the products in bulk, select the post type as: Product in step1.
- On reaching step2, select the import method and the import from location. You can import files from:
- In step 3, you can map the commercial names to WooCommerce columns. Use Evaluation Field to fix/update the required value for a particular field.
- In the last step of Advanced Options/Batch Import/Scheduling, choose the appropriate selections and import.
For a more detailed import procedure, follow the steps in How to import products. On successful import, the screen will appear as: