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.

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

Required. Can't be blank or missing.

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

Required, but can be blank.

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.

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.

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.

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

Required, but can be blank.

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.

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

Required, but can be blank.

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.

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

Required, but can be blank.

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.

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

Required, but can be blank.

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.

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.

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.

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.

The barcode, ISBN, or UPC of the product.

Required, but can be blank.

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.

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.

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.

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.

Valid values are g, kg, lb, and oz.

Optional.

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

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.

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