What are the columns in the Product CSV import template?

Created: - Updated:

**If you want to import your Inventory quantities and costs, please use the Inventory CSV import template.**

 

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 if including variations. The SKU of the parent product of the variation. 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 supported. 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
Used
Reconditioned
New
cost Cost NO LONGER USED. Please use the Inventory CSV template instead. n/a n/a
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
quantity Quantity NO LONGER USED. Please use the Inventory CSV template instead. n/a n/a
category_name Category The name of the category this product is in within Sellbrite. You will be able to choose the appropriate category offered by the sales channel to list in when creating product listings. 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
EAN
ISBN
UPC
item_height Height The height of the product without packaging. Any numerical value with 1 digit allowed after the decimal point. 4.5
item_length Length The length of the product without packaging. Any numerical value with 1 digit allowed after the decimal point. 9.0
item_width Width The width of the product without packaging. Any numerical value with 1 digit allowed after the decimal point. 3.6
item_unit_of_length Dimensions Unit of Measure The unit of measure you are using for the product dimensions. Inches Inches
item_weight Weight The weight of the product without packaging. Any numerical value with 1 digit allowed after the decimal point. 4.3
item_unit_of_weight Weight Unit of Measure The unit of measure you are using for the product 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_1 -
variation_3
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
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
/images/317086-1.jpg
product_image_2 -
product_image_12
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
/images/317086-2.jpg
Was this article helpful?
1 out of 1 found this helpful

Comments

  • Avatar
    Juan Natteri

    When I export the csv file from SellBrite it does NOT contain all these fields.
    Some fields apparently have been eliminated, for example package unit of length and package unit of weight.
    Anybody care to shed some light in this matter?