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:
- Was this article helpful?
- Yes, thanks!Not really
September 25, 2022
hiya on my site i have brands how can i link the product to a brand when do in bulk like this please? what option is for brand?
September 28, 2022
The brand data will be stored in the database in a particular column with a data format. To get the correct column and data format please export a sample product using the plugin to the CSV file and the brand data will be exported to the CSV file. Later, you can use this exported file as a template to import data back.
January 19, 2022
If I’ve run this bulk import once, and need to make a change to all of the product names, can I do it again and it not erase or re-set quantities?
Basically, what’s the quickest, easiest way to change the name of all the products I have without editing each one in the products part of the wp dashboard?
January 20, 2022
Yes, you can bulk update just the product names by keeping only the ID/SKU and product name data in the CSV and importing it. You may please create a CSV with all the product IDs in the ID column and the new product name in the post_title column and then importing them.
July 15, 2021
Do we need to update image name and url manually in csv..Id their any tool their for aut CSV genration
July 16, 2021
Using the plugin you can export all the product details to the CSV file. You can also update the images and other details of the existing products using the plugin by creating a CSV file with modified data in it and importing it.
May 18, 2020
How do you get all the product images uploaded in bulk from your computer to WooCommerce to go along with csv file?
May 26, 2020
The plugin does not support importing images directly from the computer to Woocommerce. You may please upload your image files to the /wp-content/uploads/prouct_images/ directory first and then specify the image name in the CSV file to import images to the products.
June 18, 2020
Most importing plugin by XML or CSV does not upload images, they usually link the images to the original site.
I have a script to upload each image and match all the images to the variations, and to do so, it is a little slower than the typical CSV plugins.
May 6, 2021
When an external link of the image is provided in the CSV per product. How does this get imported to the WooCommerce page please?
May 8, 2021
When the file contains an external image URL the plugin downloads the image from the URL and then moves it to the uploads directory of your site and then links it with the products.
November 21, 2018
Hi. I am trying to import 827 products. The merer is just stuck showing 89 products but is still moving. Now 30 minutes. Whats going on and how many products can this plugin import?
November 22, 2018
You can import any number of products using the plugin. The issue you are facing might be due to some server limitations. Kindly share us your import error log and woocommerce fatal error log via support.
September 8, 2018
Please let us know the version of the plugin you are using.
September 5, 2018
I am trying to import 60K products, the file is about 100 MB, it is almost 17 hours and only 40% import is done.
We need to import about 100K product each night and it is currently far from reality.
How can we achieve this.
June 18, 2020
What kind of plugin do you use?
Pablo Alberto Jaramillo Quiroz
November 19, 2020
Hi did you find a soution ?
December 16, 2020
If you are having large numbers of products to be imported then please do it in batches instead of importing all the products at once.