Explore our Knowledgebase

Item Upload

Template: WithoutWire Item Import Template

Item Upload

 

The Item Upload document contains the following columns:

  • Warehouse Name – Required
  • Item Number – Required
  • Item Type– Required
  • UOM – Required
  • Base Conv Factor – Required
  • Significant Digits – Optional
  • Item Description – Optional, Editable
  • Item Generic Description – Optional, Editable
  • Manufacturer Number – Optional, Editable
  • UPC Barcode Number – Optional, Editable
  • Gross Weight – Optional, Editable
  • Net Weight – Optional, Editable
  • Length – Optional, Editable
  • Width – Optional, Editable
  • Height – Optional, Editable
  • Full Pallet Quantity – Optional
  • Cycle Count Interval – Optional, Editable
  • Zone Description – Optional

Key – The *Item Number field is the Key in an item upload. You can reference an existing item with the key and update the following fields:

Warehouse Name

Warehouse Name is a required field in the Item Upload excel file. The WithoutWire program uses the value in the Warehouse Name field to determine which warehouse to import the Item into.

Item Number

Item Number is a required field in the Item Upload excel file. This value represents the name of the Item you are uploading or updating. If the Item number already exists, WithoutWire will update the other values, if the Item does not exist, WithoutWire will create the Item.

Item Type

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
  

UOM (Unit of Measure)

The Base UOM (Base Unit Of Measure) is the smallest measurement of this item that will ever be handled in WithoutWire. For example, there are 24 Cans in every Case. The Can(s) is the Base UOM.

Significant Digits

Represents the number of decimal places WithoutWire will track inventory to for the Item and Unit of Measure associated on the same row. If no value is provided a default value of 0 will be used.

Item Description

Item Descriptions provide a more detailed description of the Item. If this value is left blank the Item Number will be used as the Item Description.

Item Generic Description

Item Generic Description is an optional field in the Item Upload excel file. The generic description is available on the handheld devices to provide more information to users when the item number is not easily recognizable.

Manufacturer Number

Manufacturer Number is an optional field in the Item Upload excel file.

UPC Barcode Number

UPC Barcode Number is an optional field in the Item Upload excel file. If the UPC Barecode Number is filled in, it adds the ability to scan either the Item Number or the Barcode Number already printed on items in your warehouse.

Gross Weight

Gross Weight is an optional field in the Item Upload excel file. If this field is left blank, it will default to 1.

Net Weight

Net Weight is an optional field in the Item Upload excel file. If this field is left blank, it will default to 1.

Length

Length is an optional field in the Item Upload excel file. Length refers to the dimensional length of the Item. If left blank, this value defaults to 1.

Width

Width is an optional field in the Item Upload excel file. Width refers to the dimensional width of the Item. If left blank, this value defaults to 1.

Height

Height is an optional field in the Item Upload excel file. Height refers to the dimensional height of the Item. If left blank, this value defaults to 1.

Full Pallet Quantity

Full Pallet Quantity is an optional field in the Item Upload excel file. Full Pallet Quantity is the maximum amount of that item that can be held on a container and it is used to determine how to split orders into multiple containers. If left blank, this value defaults to 1000.

Cycle Count Interval

Cycle Count Interval is an optional field in the Item Upload excel file. Cycle Count Interval allows you to plan the amount of cycle counts to be performed on an item in one year. if left blank, this value defaults to 0.

Zone Description

Zone Description is an optional field in the Item Upload excel file. Items in WithoutWire can belong to a zone. Orders can then be split based on zone to ensure efficient picking, Zone Description is the identifier for that zone. if left blank, this value defaults to whatever default Zone is set in WithoutWire.