Creating Products From CSV

Created: - Updated:

This article will teach you how to use the Products CSV to create products in bulk.

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

The Product CSV template lives here:

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 creating 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 NAMEFIELD NAME IN APPDESCRIPTIONACCEPTED VALUESEXAMPLE
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
Used
Reconditioned
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
EAN
ISBN
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_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, 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
/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?
0 out of 0 found this helpful

Comments

  • Avatar
    zoe rem

    Your help center is incredibly unhelpful. I literally have to submit a request for every question I have. I've just uploaded a csv and it says my upload is complete but doesn't show new products? Why isn't there another paragraph in here about what to do once you click upload. Why are the products not in inventory manager? Do I have to do something else to make them appear?

  • Avatar
    David Martens
    Edited by David Martens