Importing/Exporting Products
You can mass import products to your storefront under the Products >Import menu. However, before importing your products on your B2B portal and to facilitate the process of adding prices and products assigned to different price lists, it is useful first to create the following:
Let’s see how to import, export, and update products in bulk through your B2B Wave eCommerce platform.
Importing Products
To bulk import products to your online store, follow these steps:
Step 1. Go to the Products >Import menu on your Admin Dashboard.
Step 2. Download the sample import file.
Step 3. Open the spreadsheet and fill in the necessary information. Specifically:
product_sku | Enter the product code (e.g., SKU1) |
category_path |
Insert the category to which the product belongs. When populating your file, keep in mind that the category path should be in the following format if you have categories and subcategories Category/Subcategory (e.g., Menswear/Tops) |
extra_categories | Add the name of the additional category the product belongs to, if applicable (e.g., Knits). If the product falls under more categories, using a semicolon (;) to separate them (e.g., Knits;New collection/Menswear/Cardigans), leaving no space between them |
product_name | Type the product’s name (e.g., Checkered Shirt) |
product_desc | Enter the product’s description – this can also be in HTML format |
product_price | Add the price of the product. If you have multiple price lists, you can create multiple .xlsx files and import the product’s value per price list through Products >Price Lists. In this case, if available, products are matched with the “product_sku” column and are not duplicated. Also, you can upload product prices for all your lists at once. To do so:
|
product_tax | Insert if the product is taxable or not, choosing from the following values “Taxable” and “Non Taxable.” You can see available values under the Settings >Sales Tax menu in your Admin Dashboard |
product_unit | Enter the main measurement unit of the product, if applicable. This can be kg, lb, square meters, or any other measurement unit. This field is only informational. Otherwise, leave this cell blank |
product_active | Type “1” if the product is active, otherwise type “0” |
product_availability | Enter the product’s status (e.g., Available, Pre-order). You can see available product status options by going to Settings >Product Statuses |
minimum_quantity | Enter the minimum quantity order for the product (e.g., 1, 10, 25), if applicable. Otherwise, enter “0” or leave the cell empty |
quantity | Add the product’s available stock quantity if you want to monitor your inventory through the B2B Wave platform |
quantity_monitor | Type “1” to monitor available quantities. Otherwise, enter “0” |
package_quantity | Enter here the product’s package quantity. If this does not apply, leave this cell empty |
image_url | Enter the full URL of the product’s image. Supported file formats are .png and .jpeg. The URL must follow this example: https://uploads-ssl.yoururlhere.com/5968d069/938fd4b_1009x600-Company-v2_with_products.jpg. You can also import additional pictures for each product, by adding extra columns to your spreadsheet named using the following format: “gallery_image_url1,” “gallery_image_url2.” In this dedicated article, you can find out more about bulk uploading your images on your B2B Wave platform. NOTE: If you don’t have your product images online, leave this blank, or contact us for an alternative |
product_upc | Add the product’s UPC, if applicable. Otherwise, leave this cell empty. Remember that this information will appear on your storefront |
reference_code | Enter the product’s internal reference codes, if applicable. Otherwise, leave this cell blank. Remember that this code is for internal use and will not appear on your storefront |
available_options |
Add here the product’s available options, if applicable, separating each option with a comma (,) and not leaving any space (e.g., Size,Color). Otherwise, leave this cell blank |
related_products | Enter the related product's code, if applicable, separating each option with a comma (,) and making sure not to leave any space (e.g., SKU1,SKU2). Otherwise, leave this cell blank |
NOTE: You can also import brands and brand images. To do so, add the following columns “brand” and “brand_image_url” at the end of the spreadsheet and then enter the relevant info. Remember that for brand images, supported file formats are .png or .jpeg format.
Step 4. Go to Products >Import, choose the relevant price list you want to mass import products and pricing for from the “Price List” drop-down menu, and check “Import prices.” Then, “Choose File” to upload your file, and click “Import.” Remember that your file should be in .xlsx format.
Exporting Products
To export your existing product catalog, follow these steps:
Step 1. Go to the Products >Export menu on your Admin Dashboard.
Step 2. Select the available options on the “Products export” page and click “Export.” Specifically:
Price List | Select the appropriate price list from the drop-down menu |
Category | Choose the appropriate option from the drop-down menu. Remember to choose “All” if you want to download all your products |
Privacy group | Select the appropriate option from the drop-down menu to export only products that are assigned to specific privacy groups. Otherwise, leave the pre-selected option |
Only Active | Check this option to export only active products. Otherwise, leave unchecked |
Products without images | Check this option to export products for which you haven’t uploaded images. Otherwise, leave unchecked |
Products without prices | Check this option to export products without their prices. Otherwise, leave unchecked |
Updating Products in Bulk
You can update products by downloading and re-uploading them on your B2B eCommerce platform. To do this:
Step 1. Go to the Products >Export menu on your Admin Dashboard, make your selections (as described above), and click “Export” to download the file.
Step 2. Make the necessary changes to the file, then import it through Products >Import. Remember to check the “Import prices” option if you also want to update product prices. Below, you will find a list of columns that typically are part of the downloaded spreadsheet.
product_sku | Corresponds to the product’s code (e.g., SKU1) |
category_path | Refers to the product’s category. When populating your file, keep in mind that the category path should be in the following format if you have categories and subcategories: Category/Subcategory (e.g., Menswear/Tops) |
extra_categories | Reflects the name of the additional category the product belongs to, if applicable (e.g., Knits). If the product falls under more categories, using a semicolon (;) to separate them (e.g., Knits;New collection/Menswear/Cardigans), leaving no space between them |
product_name | Corresponds to the product’s name (e.g., Checkered Shirt) |
product_desc | Refers to the product’s description – this can also be in HTML format |
product_price | Reflects the product’s price |
length/width/height | Corresponds to the product’s dimensions, which appear on your storefront, if applicable |
dimension_measurement_unit | Reflects the product’s default dimension measurement unit. Read more about measurement units |
price_msrp | Refers to the product’s MSRP if you display it on your storefront. If this does not apply, the cell will be empty |
brand | Corresponds to the product’s brand if applicable NOTE: To remove brands, type (-) in the corresponding column |
product_tax | Reflects whether the product is taxable or not from the following available values “Taxable” and “Non Taxable” |
product_unit | Refers to the main measurement unit of the product, if applicable. If this does not apply, the cell will be blank |
product_active | Corresponds to whether the product is active or not: value “1” implies that the product is active, while “0” means that the product is inactive |
product_availability | Reflects the product’s status (e.g., Available, Pre-order) |
weight | Corresponds to the product’s weight, if applicable. If this does not apply, the cell will be blank |
box_quantity | Reflects if the product is only available in multiples. If this does not apply, the cell will be empty |
minimum_quantity | Corresponds to the minimum quantity order for the product (e.g., 1, 10, 25), if applicable. If this does not apply, the cell value will be “0,” or the cell blank |
quantity | Refers to the product’s available stock quantity |
quantity_monitor | Reflects whether you want to monitor the product’s quantity. Value “1” implies that you monitor available quantities, while value “0” means that you do not |
can_backorder | Corresponds to whether you allow back ordering for this product. Value “1” implies that back ordering is active, while “0” means that this option is inactive. Read more about backorders |
package_quantity | Refers to the product’s package quantity. If this does not apply, this cell will be blank |
package_quantity_unit | Specifies the product's package quantity unit. If this does not apply, this cell will be blank |
image_url | Corresponds to the product’s full image URL. If you haven’t uploaded any images for the product, this cell will be blank |
pdf_description | Refers to the product’s description in your PDF product catalog. To enable product descriptions to display in your PDF catalog, go to Tools >PDF Catalog and check “Show product description” |
product_upc | Reflects the product’s UPC as it appears on your storefront. If this does not apply, this cell will be empty |
search_keywords | Corresponds to the keywords with which customers can look up this product. If this does not apply, this cell will be blank. If the product has multiple keywords, these will be listed here separated with a comma (,) and without spaces (e.g., blanket,knits) |
barcode | Refers to the product's barcode |
reference_code | Corresponds to the product’s reference codes for external systems you may use, if applicable. If you do not use internal codes, this cell will be empty |
b2b_product_id | Refers to the product’s identification code used internally for B2B Wave |
is_private | Corresponds to whether the product is private or not. Value “1” implies that the product is private, while “0” means that it is not |
customer_access | If the product is private, customers added to this column are the only ones who can access this product on your online store. These customers’ email addresses will be listed here, separated with a semicolon (;) and without blanks between them (e.g., demo@b2bwave;support@b2bwave.com;sales@b2bwave.com). If the product is not private, the cell will be blank |
privacy_groups | If the product belongs to privacy groups, the name of these privacy groups will appear here, separated with a comma (,) without spaces between them (e.g., VIP,Gold). If you haven’t added the product to any privacy group(s), the cell will be blank. Learn more about privacy groups |
related_products | If you have added related products for the product, their codes will appear here, separated with a comma (,) without any spaces between them (e.g., SKU1,SKU2). If you haven’t added any related products, this cell will be empty |
current_image_url | Corresponds to the product’s currentimage URL. If you haven’t uploaded any images for the product, this cell will be blank |
extra field [name] | If you added product view extra fields with small text, text area, select or multi-select as their field type to your B2B website, these will appear here in your exported file. You can update these by typing the relevant information under these columns, separating multiple options using a comma (,), and leaving no spaces (e.g., Matte,Polished). |
current_product_url | Refers to the product’s current URL on your storefront |
available_options | Reflects the product's available options, if applicable. If you have added product options, these will appear here, separated with a comma (,) and without spaces between them (e.g., Size,Color). Otherwise, leave this cell will be blank |
option_values_[variant name] | Reflects the product's available options, if applicable. If you have added any, these will appear here, separated with a comma (,) and without spaces between them. For example, if you have different sizes, the values in this cell could be “all” or “XL,M,S” |
NOTE: If you want to exclude customers from accessing specific products, add a column named “ block_list ” to the spreadsheet. Then, type the email addresses of the customers for whom you want to restrict access to particular products, separated by semicolons (;) and without spaces between them (e.g., demo@b2bwave.com;support@b2bwave.com).