How do I upload a large number of products in WooCommerce?
Creating products in WooCommerce is one of the most time-consuming and effort-intensive tasks. However, within the WooCommerce product creation page, there is a way to upload thousands of products in just a few seconds. This method involves creating an Excel file containing a list of products to be added.
The Excel file must contain the following columns to ensure WooCommerce can accurately identify product details such as the product name, price, variations, attributes, and other elements.
The list of required columns must follow these guidelines:
- CSV files should be in UTF-8 format.
- All dates should be defined according to the store’s local timezone.
- Boolean values (true or false) should be represented as 1 or 0 in your CSV.
- Multiple values in a field should be separated by commas.
- When referencing an existing product ID, prefix it with id:. If referencing a SKU, no prefix is needed (e.g., id:100, SKU101).
- Custom meta fields are supported but only for plain text — JSON or serialized data is not supported.
- Taxonomy term hierarchy should be denoted with >, and terms should be separated by commas.
- Serialized data is not supported.
- Images must be pre-uploaded or available online to be imported into your store.
- External URLs are supported and will be imported into the media library if used.
- If an image already exists in the media library, you can define the filename to reference it.
Below is a list of the necessary columns required to successfully complete the import :
https://medium.com/media/de8f9ac8c9e745e5c7aac77232eaf646/href
Here is a list of products for WooCommerce in a CSV file that you can use as an example to upload products to your store :
https://medium.com/media/0fbf292ebefb878ddfda43d635b9bd3a/href
You can use this file as inspiration when creating your own.
To upload products, go to Products, then click on Import :
From there, you will be redirected to a page where you can upload your CSV file :
From there, you can click Next to proceed with the product import on your WooCommerce store.
This brings us to the end of our tutorial. If you’re looking for plugins to enhance your WooCommerce store and boost your sales, be sure to check out our website.