More and more people are starting to use the combination of WordPress and WooCommerce to build foreign trade websites to sell their products. For most B2C users, there are usually dozens or hundreds of products that need to be added to the website. Manually adding them one by one from the backend is very time-consuming, and overseas server networks are generally slower. Here, Naiba teaches you how to
Use WooCommerce's bulk product upload feature to quickly add products。
Steps for WooCommerce Bulk Product Upload
Step 1: Create a sample product
To upload products in bulk, we first need to create a sample product. This way, you'll know what content needs to be filled in during the bulk process.
From the Admin Dashboard, go to Products, Add New, and fill in all your product information, including product title, short description, featured image, product gallery, product categories, and any other product information you need to display on your website.
Step 2: Export the product information CSV file
Go to Products, All Products, then click Export
On the export screen, select the content you want to export. It is recommended to export SKU, because in most cases, the product SKU on an e-commerce website is unique, making it convenient for identifying products. After making your selections, click 'Generate CSV' to download all the selected data to a local CSV file.
Step 3: Complete the CSV product file
If your Admin Dashboard is in English, the exported CSV will be in English; if it„s in Chinese, the CSV will be in Chinese. This doesn“t affect the process. In the image above, you can see Naiba only exported SKU, Name, Categories, and Image. Now, you just need to fill in all the product information you want to upload in bulk. If a product has multiple images, separate each image URL with an English comma. Images can be URLs from your server or external URLs. If there are multiple categories, separate them with an English comma. For subcategories, use the format „Main Category > Subcategory“. After completing the CSV spreadsheet, save it.
Step 4: Bulk import via WordPress Admin Dashboard
Go to the WordPress Admin Dashboard, find Products, then select All Products, and choose Import.
After running the import screen, select the CSV file you just saved, then click Continue.
Next, a parameter mapping screen will appear. If you followed the method in this article, all parameters will be automatically matched after uploading the CSV file, so you don't need to select anything. Just click 'Start Import'.
This completes the bulk product import. If you need to modify some product information later, you can simply go to the website backend and click on the product to edit it. This is much more efficient than manually uploading products one by one.
WooCommerce Bulk Add Product Categories
If you want to add product categories to WooCommerce in bulk, you can use the 'Bulk WooCommerce Category Creator' Plugin. Simply search for 'Bulk WooCommerce Category Creator' in the website backend, install and activate it. The Plugin's introduction page has a video tutorial. If you don't know how to use it, you can follow the tutorial. The above is the method for bulk uploading products in WooCommerce. If you still have questions, you can communicate with Naiba. Contact information is at the bottom of the website.
Other WooCommerce Related Tutorials
- WooCommerce Bulk Import/Export Plugin: Woo Import Export
- Method for Bulk Ordering Products in WooCommerce
- For more WooCommerce tips and resources, please check:WooCommerce Tutorial
From the Admin Dashboard, go to Products, Add New, and fill in all your product information, including product title, short description, featured image, product gallery, product categories, and any other product information you need to display on your website.
Go to Products, All Products, then click Export
On the export screen, select the content you want to export. It is recommended to export SKU, because in most cases, the product SKU on an e-commerce website is unique, making it convenient for identifying products. After making your selections, click 'Generate CSV' to download all the selected data to a local CSV file.
If your Admin Dashboard is in English, the exported CSV will be in English; if it„s in Chinese, the CSV will be in Chinese. This doesn“t affect the process. In the image above, you can see Naiba only exported SKU, Name, Categories, and Image. Now, you just need to fill in all the product information you want to upload in bulk. If a product has multiple images, separate each image URL with an English comma. Images can be URLs from your server or external URLs. If there are multiple categories, separate them with an English comma. For subcategories, use the format „Main Category > Subcategory“. After completing the CSV spreadsheet, save it.
After running the import screen, select the CSV file you just saved, then click Continue.
Next, a parameter mapping screen will appear. If you followed the method in this article, all parameters will be automatically matched after uploading the CSV file, so you don't need to select anything. Just click 'Start Import'.
This completes the bulk product import. If you need to modify some product information later, you can simply go to the website backend and click on the product to edit it. This is much more efficient than manually uploading products one by one.
Comments are closed
The comment function for this article is closed. If you have any questions, please feel free to contact us through other channels.