This article will teach you how to use the Products CSV to add products in bulk.
Adding products from CSV is a great way to get new products into Sellbrite in bulk, quickly and easily.
Once products are added via CSV, you will then need to add inventory quantities to the SKUs imported from the Product CSV. There is a separate process for adding and/or adjusting inventory quantities. Show me more.
You can access the Product CSV template by following this path in the software:
Settings > Import Data > Products
Find the link to download a blank template. The template includes 2 sample products, one with variations and one without.
IMPORTANT: Do not remove the first 3 rows of the file.
When adding a product in Sellbrite, only 2 fields are required: SKU and Name. However, it is encouraged that you build products as completely as possible.
The table below provides an explanation of each column and a sample value.
|COLUMN NAME||FIELD NAME IN APP||DESCRIPTION||ACCEPTED VALUES||EXAMPLE|
|sku||SKU||Required. A unique identifier for the product, assigned by you. The SKU must be unique for each product and cannot be changed once the product has any history (listings, orders, etc.).||Any alphanumeric value no longer than 50 characters. Case-sensitive. Avoid spaces, quotes and other punctuation besides dashes (-) and periods (.)||NIK-317086-001-14|
|parent_sku||SKU of Parent Product||Required for variations only. The SKU of the parent product goes in this column.||Same as SKU||NIK-317086|
|name||Product Name||Required. The name of the product.||Any alphanumeric value no longer than 500 characters.||Jeter Vital Metal Mens Baseball Cleats|
|description||Description||A text description of the product.||Any alphanumeric value no longer than 2000 characters. HTML not recommended.||The Jordan Jeter Vital Metal baseball shoe features a molded synthetic leather upper with asymmetrical toe down view.|
|brand||Brand||The brand of the product.||Any alphanumeric value||Nike|
|condition||Condition||The condition of the product. You will be able to map these conditions to the condition options offered by the sales channel when creating product listings.||New
|price||Price||The amount for which you are selling the product.||A dollar amount greater than 0.00||199.99|
|msrp||MSRP||The manufacturer's suggested retail price or list price for the product.||A dollar amount greater than 0.00||199.99|
|category_name||Category||The name of the category for this product in Sellbrite. This is for your own organization and does not need to match a sales channel category.||Any text. Unrecognized categories will be created if the option is selected during import.||Baseball Cleats|
|manufacturer||Manufacturer||The manufacturer of the product. May be the same as the brand.||Any alphanumeric value||Nike|
|manufacturer_model_number||Manufacturer Model Number||The manufacturer's part or model number for the product.||Any alphanumeric value||317086|
|product_id||Product ID||A standard, universal ID that identifies the product, such as a UPC, EAN or ISBN.||Numerical only (dashes accepted)||640135-885181|
|product_id_type||Product ID Type||The type of universal ID that you supplied for Product ID||UPC
|package_height||Package Height||The height of the product in the packaging (for shipping purposes).||Any numerical value with 1 digit allowed after the decimal point.||5.5|
|package_length||Package Length||The length of the product in the packaging (for shipping purposes).||Any numerical value with 1 digit allowed after the decimal point.||9.5|
|package_width||Package Width||The width of the product in the packaging (for shipping purposes).||Any numerical value with 1 digit allowed after the decimal point.||4.0|
|package_unit_of_length||Package Dimensions Unit of Measure||The unit of measure you are using for the product packaging dimensions.||Inches||Inches|
|package_weight||Package Weight||The weight of the product in the packaging (for shipping purposes).||Any numerical value with 1 digit allowed after the decimal point.||5.5|
|package_unit_of_weight||Package Weight Unit of Measure||The unit of measure you are using for the product packaging weight.||Pounds||Pounds|
|feature_1 - feature_5||Product Features||Brief descriptive text regarding a specific aspect of the product.||Any alphanumeric value||Simple stylish design comes in multiple color options, is functional and suitable for any room.|
|Variation Option Name or Option Value||For Parent Product: The variation option that the child products will vary on.
For Child Products: The value for this variation option.
|For Parent Products: Color, Size, Material, etc.
For Child Products: Any alphanumeric value
|For Parent Products: Color
For Child Products: Blue
|product_image_1||Product Images||The URL where a main image of the product is located.||Any valid image URL. Images should have 72-pixels-per-inch resolution and be 500 pixels minimum in length (on the longest side). The preferred file format is JPEG (.jpg), and the URL must be fully-formed and valid (i.e., include http://). There cannot be any spaces in the image URL. Save the image to your web server and supply the URL to the image in this field. Accepted formats are .jpeg, .jpg, .png and .gif.||http://www.companyname.com
|Product Images||The URL where additional images of the product are located.||Any valid image URL. The preferred file format is JPEG (.jpg), and the URL must be fully-formed and valid (i.e., include http://). There cannot be any spaces in the image URL. Save the image to your web server and supply the URL to the image in this field. Accepted formats are .jpeg, .jpg, .png and .gif.||http://www.companyname.com