QPro Videos

CSV Inventory Import (Materials)


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 (‘ * , “) 
QFloors Intermediate Training @ Shaw Flooring Convention

January 20, 2027 | 8am - 12pm