Inventory availability data type (INV)

The current inventory availability at the node/item level is used to compute inventory performance cost, including estimating key factors like weeks of supply.

This content should be provided regularly to see up-to-date cost estimates to influence node selection early in the optimization process. This data feed expects beginning-of-the-day numbers.

Inventory supply at node/item level for determining stock-out probabilities (inventory supply – i.e., on-hand inventory is a key factor in determining stock out and also used for various factors in estimating stock-out chance).There should be no duplicate SKU node combinations in the feed. Inventory availability is equal to inventory on hand supply minus allocated demand. The safety stock should not be considered when computing inventory availability.

  • Historical Data
    • Provide two years of BOD inventory availability and supply to model the seasonality across the year. One year is needed for the training data set, and another year for the testing data set.
    • A minimum of one year inventory data is required to support training of the model.
  • Periodical Data
    • Daily files received every 30 minutes – data for all nodes in a single file
    • Weekly snapshot file – one file per node/location

File name and separator

This data type uses the pipe (|) separator.

The recommended format for the file name is: INV_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv

Multiple csv files can be uploaded by compressing into a tar.gz file.

Fields

Table 1. The table displays the fields and description for the inventory availability data type.
Field Name Required Type Description
Node key Yes STRING The node key for this inventory record. It must match the node key in the Fulfillment Network Node file
SKU number Yes STRING SKU Number
Inventory date Yes DATE Date at which inventory adjustment was done, using the format YYYY-MM-DD
Inventory time Yes TIME Time at which inventory adjustment was done, using the format HH:MM:SS
On hand quantity Yes DECIMAL The on hand quantity. This number does not account for any demand
Availability Yes DECIMAL The current inventory quantity available. This quantity is used by the stockout process. It is required to enable item-node cost update for influencing candidate node selection. This number should include supply (on hand quantity) minus demand (SFS or other online orders).

Sample for INV_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv

node_key|sku_id|inv_date|inv_tm|oh_qty|avail_qty

HFNodes1|95073090|2018-07-01|03:01:33|07|07

HFNodes2|95073090|2018-07-01|03:01:33|07|07

HFNodes3|95073090|2018-07-01|03:01:33|07|07

HFNodes4|95073090|2018-07-01|03:01:33|07|07

Sample script to upload data by using the file adapter

/<Install_dir>//AsperaClientLinuxDist/asperaTransferClient.sh -jobname INVPush 
-contentType INV -server -userid -password -op UPLOAD -src -dest/INV 
-conf /<Install_dir>//AsperaLinuxDist/asperaTransferOption.properties