BackIntroduction to B3

Import Products

Description of the product import CSV file

Column Description Data requirements
Handle

Handles are unique names for each product. They can contain letters, dashes, and numbers, but no spaces, accents, or other characters, including periods. Handles are used in the URL for each product.

For example, the handle for a "Men's Shoe" should be mens-shoe, and the product's URL would be https://yourstore.b3.my/product/mens-shoe.

Every line in the CSV file that starts with a different handle is treated as a new product. To add multiple images to a product, you must add multiple lines with the same handle.

Required. Can't be blank or missing.
Title

The title of your product. For example, Mens Shoe.

Required. Can't be blank or missing.

Body (HTML)

The description of the product in HTML format. This can also be plain text without any formatting.

Required, but can be blank.

Vendor

The name of the vendor for your product. For example, Michaels Apparel.

Required, but can be blank.

Entered values must be at least two characters long.

Type The product type. For example, Shoes Required, but can be blank.
Tags

A comma-separated list of tags used to tag the product. Most spreadsheet applications automatically add quotes around the tags for you. If you use a plain text editor, then you need to manually add the quotes. For example, "tag1, tag2, tag3".

Required, but can be blank.

Published

States whether a product is published on your online store. Valid values are TRUE. If the product is published on your online store, or FALSE. If the product is hidden from your online store.

Required. Leaving the field blank publishes the product.
Option1 Name

If a product has an option, then enter its name. For example, Color.

Required, but can be blank.

For products with only one option, this should be set to blank.
Option1 Value

Caution: Changing data in this column deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values can break third-party dependencies on variant IDs.

If a product has an option, then enter its value. For example, Black.

Required, but can be blank.

For products with only one option, this should be set to blank.
Option2 Name

If a product has a second option, then enter its name. For example, Size.

Required, but can be blank.

Option2 Value

Caution: Changing data in this column deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values can break third-party dependencies on variant IDs.

If a product has a second option, then enter its value. For example, Large.

Required, but can be blank.

Option3 Name

If a product has a third option, then enter its name.

Required, but can be blank.

Option3 Value

Caution: Changing data in this column deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values can break third-party dependencies on variant IDs.

If a product has a third option, then enter its value.

Required, but can be blank.

Variant SKU

The SKU of the product or variant. This is used to track inventory with inventory tracking services.

Required, but can be blank.

Variant Grams

The weight of the product or variant in grams. Don't specify a unit of measurement or use decimals. For example, for a weight of 5.125 kg, enter 5125.

B3 always imports and exports the weight in grams, even if you specify a different unit. You must use accurate weights if you intend to offer carrier-calculated shipping or use a third-party fulfillment service.

Required. Can't be blank or missing.

You must enter a value, even if that value is 0.

Variant Inventory Qty

The number of items you have in stock of this product or variant. This column is used only for B3 stores that have a single location.

Required, but can be blank.

Variant Price

The price of the product or variant. Don't include any currency symbols, include only the price. For example, 9.99.

Required. Can't be blank or missing.

Variant Compare at Price

The Compare at Price of the product or variant. Don't include any currency symbols, include only the price. For example, 9.99.

Required, but can be blank.

 

Variant Barcode

The barcode, ISBN, or UPC of the product.

Required, but can be blank.

 

Image Src

Enter the URL for the product image. B3 downloads the images during the import and re-uploads them into your store.

Required, but can be blank.

 

Image Alt Text

Alt (alternate) text describes an image and is an important part of a product description. If an image can't load for any reason, then alt text is shown instead. It's also used by assistive technology to describe an image to a customer who's visually impaired. Including alt text will boost your website's SEO. Keep your alt text brief and descriptive. The maximum length is 512 characters, but the optimal length is 125 characters or fewer.

Required, but can be blank.

 

SEO Title

The SEO Title is found on a product's details page under the Search engine listing preview header in the Page title field. The SEO Title has a character (letters and numbers) limit of 70. If you leave this field blank when importing a product, then the field is automatically populated with the product title.

Optional.

SEO Description

The SEO Description is also found on a product's details page under the Search engine listing preview header in the Meta description field. The SEO description has a character (letters and numbers) limit of 320. If you leave this field blank when importing a product, then the field is automatically populated with the product description.

Optional.

Variant Weight Unit

Valid values are gkglb, and oz.

Optional.

If this field is left blank, then the Variant Weight Unit is kg.

Cost per item

How much it costs you for the product or variant. Don't include any currency symbols, only include the cost. For example, 9.99.

Optional.

Status Whether a product is available to your customers. Valid values are:
  • active: the product is active and ready to be sold
  • draft: the product is a draft and needs to be completed
  • archived: the product is archived and no longer available to sell

Required.

If the column is missing, then all products upload as active. If the column is present, then blank values cause the upload to fail with the error: Status isn't valid. Set the status as active, , draft, or archived.

Import File

Download Import File