Inventory Upload
Template: WithoutWire Inventory Import Template
The Inventory Upload document contains the following columns:
- WarehouseName – Required
- ParentBinNumber – Required
- LicensePlate – Optional
- ItemNumber – Required
- UOM – Optional
- ConversionFactor – Optional
- ItemType – Required
- ItemValue – Required
- Quantity – Required
WarehouseName
The WarehouseName is a reference to the name of the warehouse where the inventory will be created
ParentBinNumber
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.
LicensePlate
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.
ItemNumber
A reference to the item number of the item that you are adding inventory for.
ItemType
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 item type should be set to one of the following:
- basic
- lot – lot tracking
- date – expiration date tracking
- serial – serial tracking
ItemValue
The value of the tracking unit. For example, if you are lot tracking, this field would be the lot number. If serial tracked, then 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.
UOM
The unit of measure for the inventory you are adding. The base unit of measure will be used if this value is not provided.
ConversionFactor
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.
LotNumber
The Lot Number to associate with the inventory in the bin.
*Required if the item is a lot tracked item.
Quantity
The amount of inventory in the bin for the item listed.