Notes:

  • Column names must follow the exact same naming scheme as provided or the import upload will fail. 

  • Blank rows are considered empty and skipped by the importer. 

  • Duplicate rows are not allowed.

  • It is possible to successfully upload 0 rows of information, as long as all required columns are present, the importer will still “succeed”.

  • Overwrites will be performed on any data that has been changed between exporting/importing as long as the ID matches.


FieldIs Field Required?Additional DetailsField Value FormatMax Characters/Values
IdLeave Blank
  • Generated by the system upon export. If an Id exists any changes to that row will update.
  • If an Id does not exist the import will treat the row as a new record.
GUID (Globally Unique Identifier)Can be a null or empty value
SupplierYes
  • Supplier must exist in DocketManager prior to import.


Supplier CodeNo
  • The item number used to order the supply from your supplier.


Supply NameYes
  • Unique name specific to this supply.


Package QuantityNo
  • The number of items that are in a package or carton.


LocationNo
  • The location of the supply in your facility.


Minimum LevelNo
  • The number of items you want on hand before reordering.


On Hand
No
  • The number of items in inventory.


Price PerNo
  • The number of items the Price scale is specific to.


Price Scale - Qty 1No
  • Allows you to create scales of pricing, this field is the Quantity up to. If one row exists a price scale the quantity is up to that value and beyond.


Price Scale - Cost 1No
  • The cost of the supply to you from your supplier that is based on the Price Per column.