Inventory Upload
  • 1 Minute to read
  • PDF

Inventory Upload

  • PDF

Article Summary

Inventory Upload


Inventory Upload Template

The Inventory Upload document contains the following columns:


WarehouseName – Required


ParentBinNumber – Required


LicensePlate – Optional


ItemNumber – Required


UOM – Required


ConversionFactor – Optional


ItemType – Required


ItemValue – Required


Quantity – Required


OwnerName – Optional







The WarehouseName is a reference to the name of the warehouse where the inventory will be created.






The Parent Bin is where the inventory will be created. If a License Plate is specified in column C, the inventory will reside on the License Plate inside the Parent Bin. If no License Plate is specified, the inventory will reside directly inside the Parent Bin.





Inventory in WithoutWire can be placed on a License Plate inside of a bin. Specify a license plate to place inventory on. Or leave this field blank to create the inventory directly in the Parent Bin.






A reference to the item number of the item that you are adding inventory for.






The unit of measure for the inventory you are adding.






The Base Conversion Factor for the Unit of Measure referenced in column E. If this is the smallest Unit of Measure you will track for this item, enter 1. A default value of 1 will be used for any new UOM’s missing a conversion factor.






A reference to the item type of the item being added inventory for.  If this item exists in the system, then this field is not required.  If the item is new, then the item type should be set to one of the following:




lot – lot tracking


date – expiration date tracking


serial – serial tracking






The value of the tracking unit.  For example, if you are lot tracking, this field would be the lot number.  If serial tracked, then the serial number.  If the item type is date, then the value must be MM/DD/YY.  If the item type is basic, then this value can be left blank.






The amount of inventory in the bin for the item listed.




Owner Name


Inventory can be added for a specific customer to be used to fulfill orders for only that customer.




What's Next