Notes:

  • At least one column must be present.

  • All columns must be filled to be able to map with useful information.

  • Having more columns than required is possible.

  • Only the first row will be read into the importer. It is possible to successfully upload 0 rows of information, as long as all required columns are present, the importer will still “succeed” in mapping the csv file.

  • Mapping will allow any column to be mapped to any column “header”.

  • Must be attached to an already created vendor.

  • A demo spreadsheet can be found here.


FieldIs Field Required?Additional DetailsMax Characters/Values
Vendor Code
Yes
  • Often referred to as 'Unique Stock ID' or 'Product Code' in supplier lists
  • No size limit
Price Per
No
  • Often referred to as 'Costing Units' or 'U of M'
  • No size limit
Minimum Level
No
  • Minimum levels on stock
  • No size limit
Package QuantityNo
  • Often referred to as 'Carton Count'
  • No size limit
Price Scale - Quantity 1-10
Yes
  • Export a current stock list for the specific supplier from DocketManager
  • Review the Price Scale - Quantity column(s) in your DocketManager Export
    • If only one scale exists, insert a column into your supplier list as ' Price Scale - Quantity 1 and enter the Quantity - typically seen as 999999 or 1
    • If there are multiple Price Scale Quantities, you will need to include a 'Price Scale - Quantity column for each scale and use the Additional Scales when mapping.


Note: The updater will match costs according to your quantity column on supplier list. If the quantity does not exist in DocketManager, it will add a new Price Scale - Quantity and cost into DocketManager when importing which may throw off your pricing scales. 

  • No size limit
Price Scale - Cost 1-10
Yes
  • Enter value for Price Scale - Cost 1 
  • Do not use any commas or '$' signs
  • No size limit
Price Scale - Book Cost 1-10Yes
  • Enter value for Price Scale - Book Cost 1 
  • Do not use any commas or '$' signs
  • No size limit