• Leave blank as the Id will be systemically generated when the stock is created

• Required for ease in price updating
• Supplier code must be unique in comparison to the rest of the names and codes in the csv

• Leave Cover or Text in name as provided

• Include 'lbs' or 'pt' pending item
• Checks for existing mass unit
  • If it exists in the database, they are attached to the stock.
  • If they do not exist, they are added to the database of mass units and attached to the stock

• Checks for existing dimension unit
  • If it exists in the database, they are attached to the stock.
  • If they do not exist, they are added to the database of dimension units and attached to the stock
• Convert any fractions (1/2 or 1/8) to decimals 

Example: 4 1/8 x 9 1/2 s/b entered as 4.125 x 9.5

• Do not have any characters in the field 

Example: remove any P3H that may be in the field

• For Rolls, such as 54" or 36", enter 54x1 or 36x1
• If no size available enter 0 x 0 
• Use lower case 'x' otherwise import will FAIL.

• Checks for existing color:
  • If it exists in the database, they are attached to the stock.
  • If they do not exist, they are added to the database of colors and attached to the stock

• Checks for existing finish
  • If it exists in the database, they are attached to the stock.
  • If they do not exist, they are added to the database of finishes and attached to the stock

Example: Gloss / Smooth / Silk / Dull / Satin / Linen etc.

• Checks for existing tag(s):
  • If they exist in the database, they are attached to the stock.
  • If they do not exist, they are added to the database of tags and attached to the stock
• Multiple tags can be added in the same row, must be separated by “;” with no spcae

Example: Tag1;Tag2;Tag3  

• If you have unwanted tags, make sure to remove them so they are not included in stock import

• Must match one of the following exactly:
  • Piece
  • Linear Feet
  • Square Feet
  • Weight

• Leave blank unless specified
• Values will import from defaults set on stock settings

• Max value is 2147483647

• Leave blank
• Values will import from defaults set on stock settings

• Max value is 9 999.99
• Only 2 decimal places are allowed

• Leave blank
• Values will import from defaults set on stock settings

• Max value is 9 999.99
• Only 2 decimal places are allowed

• 1 or if NCR/Carbonless, can be 2 or more

• Max value is 2147483647

• If provided

• Max value is 99 999 999.99
• Only 4 decimal places are allowed

• Must be in decimal form Example: if provided 4 or 12 etc this must be converted to .004, .012, divide by 1000

• Max value is 99 999 999.99
• Only 6 decimal places are allowed

• No decimals allowed or import will FAIL.

• Max value is 2147483647

• Normally '1000'
• Large Format stock normally by # of feet on roll or if a board could be 1
• Dependent upon the cost provided on the stock list
• No Decimals allowed or import will FAIL.

• Max value is 99 999 999.99
• Only 2 decimal places are allowed

• No Decimals allowed or import will FAIL.

• Max value is 2147483647

• No size limit

• Max value is 2147483647

• Must be larger than the Minimum Level column

• Max value is 2147483647

• Leave Blank- this field will auto calculate for display purposes when Columns J (Price By), AF (Price Scale - Qty 1) and AG (Price Scale - Cost 1) are filled out correctly.

• If one is provided on the suppliers stock list use the quantity scales provided
• If no quantity scale provided, enter Qty 1: 999999 or 1

• Max value is 2147483647

• $ amount provided on stock list 
• Do not include $ sign in column

• Max value is 9999.9999
• Only 4 decimal places are allowed

• $ amount provided on stock list (usually the same as Cost)
• Do not include $ sign in column

• Max value is 9999.9999
• Only 4 decimal places are allowed

• If left blank, default stock qty scale will pull in
• If a single markup % has been provided, enter '999999'

• Max value is 2147483647

• If left blank default stock markup will pull in
• If a specific % has been provided enter that amount in field

• Max value is 999 999.9999
• Only 4 decimal places are allowed

• If left blank, default stock qty scale will pull in
• If a single markup % has been provided, enter '999999'

• Max value is 2147483647

• If left blank default stock markup will pull in
• If a specific % has been provided enter that amount in field

• Max value is 999 999.9999
• Only 4 decimal places are allowed

• No size limit