Import Items - Formatting Guidelines & Template – FrontStream

Let's Learn

Use the resources in this article to import your items into the Auction Manager Platform.

How to Create CSV and Zip Files
Import Items Template - This CSV file includes all of the required and optional columns for a successful item import.
About Categories, Item Types, & Attributes - Use this guide to learn more about how Item Types and Attributes work. It also includes a chart to help you select the corresponding Item Type and Attributes for all of your items.
Import Formatting Guidelines - The Formatting Guidelines below include column definitions for the Import Item Template and explain what fields are required versus what is optional:

Field Name	Column on Spreadsheet	Notes	Required	If Empty/Null
Lot Number	A	Maximum length: 24 characters if alphanumeric string, or 2,000,000,000 (2 billion) if numerical value. No two items may have the same Lot Number. The importer uses the Lot Number as an identifier for your items: ·If a Lot number already exists in your catalog and your file includes that same number, it will update the item in your catalog. ·If you use a new Lot Number, it will create a new item.	NO	The system will assign Lot Numbers starting at 101 and increasing by 1. If items already exist, the system next issues one number above the highest Lot Number that currently exists. I.e., if your catalog contains a lot number of 556, the system next issues 557.
Quantity	B	For regular biddable items, Quantity must be 1 (which can be indicated by leaving the field blank). For Buy Now Only items: Be sure to enter NO in the Online Bidding column (Column R) and a Buy Now Price (Column V), you can have a quantity 1 - 999.	NO	Blank field OK: the system assumes a quantity of '1'.
Item Name	C	Maximum length: 100 characters No HTML allowed.	YES	ERROR
Item Description	D	Maximum length: unlimited HTML allowable, translated upon import.	YES	ERROR
Special Note	E	Maximum length: unlimited HTML allowable, translated upon import.	NO	Blank field OK