Reset Inventory

Learn how to sync inventory from an external reference source to HotWax Commerce with the 'Reset Inventory' feature.

Syncs inventory from an external reference source to HotWax. After receiving the inventory file in CSV format, HotWax Commerce calculates the difference in inventory and matches its inventory levels exactly with CSV. CSV files can be imported in HotWax by two methods: using the EXIM menu in HotWax or saving the file at a designated SFTP location for HotWax to automatically download and process.

Sample path for SFTP method: /home/<host_name>-sftp/staging/incoming

CSV example

Here's an example of the CSV file format:

facilityId
locationSeqId
idType
idValue
availableQty

DEMO_HC_STORE_1

TLTLTLLL01

sku

WH09-XL-Green

20

Parameters

The Reset Inventory API accepts the following parameters:

Parameters
Description
Required

facilityId

HotWax Commerce internal facility Id. Generally the same as the facility Id in Shopify.

Yes

locationSeqId

The Id of the designated location in a facility in HotWax Commerce.

Yes

idType

The type of the unique product identifier in the external reference source. Default is shopifyProductId

No

idValue

The value of the product idType in the external reference source.

Yes

availableQty

The available quantity of the product in the external reference source. This number will overwrite the current ATP level of the product in HotWax Commerce.

Yes

externalFacilityId

The Id of the facility in an external reference source.

No

productId

The internal Id of a product in HotWax Commerce.

No

comments

Optional field to store additional information.

No

Note: sku upca and shopifyProductId are commonly used product Identifiers.

Reset inventory sample.csv

Last updated