The eComm Inventory feed provides eComm inventory information, at the Fulfillment Center level, to help reduce operational costs and improve efficiency.
Endpoints
GET
/v2/bulkfeeds/incremental/ecomitem
POST
/v2/bulkfeeds/incremental/ecomitem
GET
/v2/bulkfeeds/history/ecomitem
POST
/v2/bulkfeeds/history/ecomitem Feed Details
The following table provides the eComm Inventory feed details.
| Specification | Details |
|---|---|
| Feed Type | Fact Feed |
| Refresh Frequency | Daily |
| Data Grain | Catalog Item ID / eComm Prod ID, Report Date, Ship Node Organization Code, Operational Company Code |
| Incremental Data | Daily Incremental |
| File Format | orc, parquet |
| Target Refresh Time | Monday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST |
| History | 1 Year |
Feed Structure
The following table provides the eComm Inventory structure.
| Sequence | Business Name | Technical Name | Data Type (orc, parquet) | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|---|
| 1 | Catalog Item ID / eComm Prod ID | catlg_item_id | long | Y | - | - |
| 6 | Report Date | rpt_dt | date | Y | - | - |
| 9 | Ship Node Organization Code | ship_node_org _cd | string | Y | - | - |
| 10 | Operational Company Code | op_cmpny_cd | string | Y | - | - |
| 2 | Trouble Quantity | trbl_qty | decimal (18,4) | - | - | Curr Trouble Bucket (Owned only) |
| 3 | Receipt In Progress Quantity | rip_qty | decimal (18,4) | - | - | - |
| 4 | Work In Progress Quantity | wip_qty | decimal (18,4) | - | - | - |
| 5 | Geographic Region Code | geo_region_cd | string | - | - | - |
| 7 | Store On Hand Cost Amount | on_hand_cost_amt | Decimal (12,2) | - | Y | Curr On Hand Cost (Owned only), Hist On Hand Cost (Owned only) |
| 8 | Walmart Product ID | wpid | string | - | - | - |
| 11 | On Hand Retail Amount | on_hand_rtl_a mt | decimal (12,2) | - | - | - |
| 12 | On Hand Unit Quantity | on_hand_unit _ qty | integer | - | - | Curr On Hand QTY (Owned only), Hist QTY in Stock (DSV only), Curr QTY in Stock (DSV only), Hist On Hand QTY (Owned only) |
| 13 | Delta Flag | delta_flag | string | - | - | - |
| 14 | Hold Quantity | hld_qty | decimal (18,4) | - | - | - |
©️Walmart | All Rights Reserved | Confidential