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.

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