Import Inventory

Facilitate users to upload inventory for items at one or multiple facilities.

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 Result Section.

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

Last updated

Was this helpful?