Import Inventory
Facilitate users to upload inventory for items at one or multiple facilities.
Last updated
Facilitate users to upload inventory for items at one or multiple facilities.
Last updated
Usage:
Download sample file and input required data in the given fields in predefined format.
Upload the updated CSV file to import bulk inventory for items on facilities in OMS, under Warehouse menu.
Check the status is updated as Finished in the .
Refer to the table for CSV field details.
CSV Fields
Descriptions
Required Fields
Warehouse-Id
HotWax Commerce Facility Identification value
Mandatory
Warehouse-External-Id
External Facility Identification value
Optional
Product-Sku
Universal Product Identification value
Mandatory
Area-Id
Area in the warehouse where the item is kept
Optional
Aisle-Id
Shelf in the area, in the warehouse where the item is kept
Optional
Section-Id
Section in the Shelf of the warehouse where the item is kept
Optional
Level-Id
Level in the shelf section, in the warehouse where the item is kept
Optional
Position-Id
Position in the shelf area in the warehouse where the item is kept
Optional
Location-Type
Specify the type as Primary, Bulk, Pickup or other
Optional
Date-Time-Received
Date in the format as MM/DD/YYYY HH:mm:ss
Note: Timestamp of inventory received in the system.
Mandatory
Accepted-Quantity
Quantity of each item for each facility
Mandatory
Warehouse-Minimum-Stock
Minimum stock value at any facility for an item, if any
Optional