Use these instructions to import an inventory list provided in a “CSV” format by other software programs. This feature is only included in QFloors version 4.004 and higher. 

1. The CSV file must be in the format found below in the Rules for CSV File section below. 
2. Click File on the Menu bar, then select Import, then Inventory (CSV). 
3. Browse to and select the CSV file that you need to import. 

Rules for CSV File 

1. The CSV file must be in the following format. The first row is a header row and cell A1 must have the following indicator: ~~Inventory Number. Data should start on row 2 of the file. 

   Column	Column Contents	Values
   A	~~Inventory Number	Char[50]
   B	*Manufacturer	Char[50]
   C	*Description Name	Char[50]
   D	*Description Number	Char[50]
   E	*Color Name	Char[50]
   F	*Color Number	Char[50]
   G	SKU	Char[50]
   H	Product Type	Char[50]
   I	*Pricing Units	Char[50]
   J	*Cost	Decimal
   K	*Physical Quantity	Decimal
   L	*Width/Quant_Carton	Decimal
   M	Backing	Char[50]
   N	Retail Price	Decimal
   O	Freight	Decimal
   P	Sidemark	Char[50]
   Q	PO Number	Char[50]
   R	Recieved Date(mm/dd/yyyy)	Char[50]
   S	DyeLot	Char[50]
   T	Bin	Char[50]
   U	Comments	Char[50]

2. Required fields * 
   Manufacturer, Description Name, Description Number, Color Name, Color Number, Pricing Units, Cost,
   Physical Quantity and Width/Quant_Carton must contain data.
   Width/Quant_Carton must contain a number greater than zero. 
3. Recognized Pricing Units (B2B Standard) 
   

   SY = Square Yards	EA = Each
   SF = Square Feet	CT = Carton
   LF = Linear Feet

4. Recognized Product Types (B2B Standard) 
   The following codes are from the B2B Standard and correspond to, or will match up to, the first three letters of the product types you define in the QFloors Product Catalog. It is possible to define your own meanings to the three letter codes but be aware that these codes follow industry standards and could affect imported documents from other venders. Also, make sure you have these set up in the Product Catalog before you import your CSV files. 

   ACC	Accessories	LAMCOU	Laminate Countertops
   BAS	Base Coving	PAD	Pad
   CAR	Carpet	RUG	Rugs
   CARTIL	Carpet Tile	STO	Stone
   CER	Ceramic Tile	STOSGR	Granite
   CEI	Ceilings	TRA	Training
   DIS	Displays	UNC	Unclassified
   FIX	Fixtures	VIN	Vinyl
   INS	Installation Material	VINTIL	Vinyl Tile
   INSTOO	Installation Tools	VINSTR	Vinyl Strip
   INSUND	Underlayment	WAL	Wall Covering
   LAM	Laminates	WOO	Wood

   
   Non-B2B supported codes
   If you have non-B2B products in your list of Product Types, give them a code that does not match any of the actual B2B codes. 

5. Invalid Characters 
   Do not use the following characters in the CSV file (' * , ")