🛒Product Import
WooBend Product import is a user-friendly drag and drop csv import tool. With WooBend Product import, the user has the ability to upload a csv file and then drag and drop the csv header values to map the csv file. The user-friendly drag and drop interface makes it easy to map the csv file and import the products into WooCommerce. WooBend uses the last product from your products list, to get the meta-data information ( Creating import fields ).
Importing existing products
To import existing products you have to have a product ID value in the CSV file. If you don't know the ID's, you may export the products via WooCommerce Product Export.
| ID | Name | Price |
|---|---|---|
123 | T-Shirt | 12.99 |
124 | Hoodie | 24.99 |
125 | Hat | 8.99 |
After adding the IDs and all the necessary fields that you'd like to edit, head to WooBend and click on "Upload CSV" and choose the file.
After the file has been uploaded:
Click on "Process"
Change "New products" from "Yes" -> "No"
Drag and drop the ID value to "Drag Product ID in here"
Drag and drop all the values that you'd like to edit to the box accordingly.
Also, make sure you read the Bulk edit "Reminder" if you are importing existing products.
👐Bulk EditImporting new Simple Products
To Import new products, please download an example file from WooBend "Upload CSV" pop-up and fill the values accordingly. For example:
| Product name | Regular Price | Sale Price |
|---|---|---|
T-shirt | 12.99 | 10.99 |
Hoodie | 24.99 | 19.99 |
Sunglasses | 8.99 | 4.99 |
After filling out the excel file, head to WooBend and click on "Upload CSV" and choose the file.
After the file has been uploaded:
Click on "Process"
Change "New products" from "No" -> "Yes"
Drag and drop all the values that you'd like to edit to the box accordingly.
Importing new Variable products
To Import new variable products, please download an example file from WooBend "Upload CSV" pop-up and fill the values accordingly. Keep in mind, you will have to have a Grouping ID value for products that are variable. For example:
| Grouping ID | Product name | Type | Attribute | Attribute |
|---|---|---|---|---|
1 | Hoodie | Variable | XL | White |
1 | Hoodie | Variable | XL | White |
X Brand Sunglasses | Simple | |||
Y Brand Sunglasses | Simple | |||
2 | T-Shirt | Variable | XL,L | Green |
2 | T-Shirt | Variable | L | Green |
2 | T-Shirt | Variable | XL | Green |
After filling out the excel file, head to WooBend and click on "Upload CSV" and choose the file.
After the file has been uploaded:
Click on "Process"
Change "New products" from "No" -> "Yes"
Drag and drop the ID value to "Drag Grouping ID in here"
Drag and drop all the values that you'd like to add to the products to the box accordingly.
Last updated