More and more people are switching to using 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 products one by one from the backend is very time-consuming, and overseas servers often have slower network speeds. Here, Naiba teaches you how to
Use WooCommerce's bulk upload product feature to quickly add products.。
Steps for WooCommerce Bulk Product Upload
Step 1: Create a sample product
To bulk upload products, we first need to create a sample product so you know what information needs to be filled in bulk.
From the backend, go to Products > Add Product, and fill in all your product information, including product title, product short description, product featured image, product gallery, product categories, and any other product details you want to display on your website.
Step 2: Export the product information as a CSV file
Go to Products, All Products, then click Export.
Then on the export interface, select the content you need to export. It is recommended to export SKUs because in most cases, the product SKU on an e-commerce website is unique, making it convenient for identifying products. After selecting, click Generate CSV file, which will 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 does not affect the process. In the image above, you can see that Naiba only exported SKU, Name, Categories, and Image. Now, you just need to fill in all the product information you want to batch upload. If a product has multiple images, separate each image URL with an English comma. Images can be server URLs or external URLs. If there are multiple categories, also 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 interface, select the CSV file you just saved, then click Continue.
Next, a parameter mapping interface will appear. If you followed the method in this article, all parameters will be directly matched after uploading the CSV file, so you don't need to make any selections. Just click Start Import.
This completes the batch import of products. If you need to modify some product information later, you can simply go to the website backend and click Edit Product. This is much more efficient than manually uploading products one by one.
WooCommerce Bulk Add Product Categories
If you want to batch add product categories to WooCommerce, 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 introduction page has a video tutorial; those unfamiliar can follow the tutorial. The above is the method for batch uploading products to WooCommerce. If you have any questions, you can discuss with Naiba. Contact information is at the bottom of the website.
Other WooCommerce Related Tutorials
- WooCommerce Batch Import/Export Plugin Woo Import Export
- Method for Batch Ordering Products in WooCommerce
- For more WooCommerce tips and resources, please check:WooCommerce Tutorials
From the backend, go to Products > Add Product, and fill in all your product information, including product title, product short description, product featured image, product gallery, product categories, and any other product details you want to display on your website.
Go to Products, All Products, then click Export.
Then on the export interface, select the content you need to export. It is recommended to export SKUs because in most cases, the product SKU on an e-commerce website is unique, making it convenient for identifying products. After selecting, click Generate CSV file, which will 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 does not affect the process. In the image above, you can see that Naiba only exported SKU, Name, Categories, and Image. Now, you just need to fill in all the product information you want to batch upload. If a product has multiple images, separate each image URL with an English comma. Images can be server URLs or external URLs. If there are multiple categories, also 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 interface, select the CSV file you just saved, then click Continue.
Next, a parameter mapping interface will appear. If you followed the method in this article, all parameters will be directly matched after uploading the CSV file, so you don't need to make any selections. Just click Start Import.
This completes the batch import of products. If you need to modify some product information later, you can simply go to the website backend and click Edit Product. 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.