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-powered eCommerce platform.

Importing Products

To mass 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:

  1. Insert additional columns after the “product_price” column
  2. Make sure to name the new columns after the lists you want to simultaneously update (e.g., Basic Price List (CAD), Basic Price list (USD)). Note that the column name should exactly match the corresponding price list’s name
  3. Once you add prices for the product for all your prices lists, remove the “product_price” column from your spreadsheet and upload it
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 empty 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

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 fromthe 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
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).

Still need help? Contact Us Contact Us