BackIntroduction to B3
- Overview
- Pricing Plans
- B3 Admin
- Initial setup
- Your account
- General Data Protection Regulation (GDPR)
- Selling online
- Restaurant
- E-shop
- Website Online
- Productivity tools
- Customers
- Accept Orders
- Analytics
- Payments
- Marketing and discounts
- Branded Mobile App
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 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, |
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, |
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, |
Required, but can be blank. |
Published |
States whether a product is published on your online store. Valid values are |
Required. Leaving the field blank publishes the product. |
Option1 Name |
If a product has an option, then enter its name. For example, |
Required, but can be blank. For products with only one option, this should be set toblank . |
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, |
Required, but can be blank. For products with only one option, this should be set toblank . |
Option2 Name |
If a product has a second option, then enter its name. For example, |
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, |
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 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 |
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, |
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, |
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 |
Optional. If this field is left blank, then the Variant Weight Unit is |
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, |
Optional. |
Status | Whether a product is available to your customers. Valid values are:
|
Required. If the column is missing, then all products upload as |