🛒

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.

Importing 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.