The Store Inventory feed (formerly Store Item Measures) provides information about inventory at the store level; several types of metrics across in-stock inventory; and markup, markdown, and margins on an item, store, and day grain.
Endpoints
GET
/bulkfeeds/incremental/storeitem POST
/bulkfeeds/incremental/storeitem GET
/bulkfeeds/history/storeitem POST
/bulkfeeds/history/storeitem Feed Details
The following table provides the Store Inventory details.
| Specification | Details |
|---|---|
| Feed Type | Fact Feed |
| Feed Availability | Supplier and Category Advisor available |
| Refresh Frequency | Daily |
| Data Grain | Business Date, Walmart Item Number, Store Number, Operational Company Code |
| Incremental Data | Daily Incremental + Affected Dates. |
| File Format | orc, parquet, csv |
| Target Refresh Time | Monday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST |
| History Period | 2 Years |
NOTE: History Period for Category Advisor Store Item feed is for only 1 year.
Feed Structure
The following table provides the Store Inventory structure.
NOTE:
- "Traited Store/Item Count - This year" and "This Year Valid Store/Item Count" are aggregated at the item level, so they will have the distinct store count at each item level.
- "Replenishment In-Stock Numerator" and "Replenishment In-Stock Denominator" will help to derive "This Year Replenishment In-Stock Percentage". This will enable aggregation based on the use case.
| Sequence | Business Name | Technical Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|---|
| 1 | Walmart Item Number | wm_item_nbr | Long | Y | - | Walmart Item Number |
| 2 | Store Number | store_nbr | Integer | Y | - | Store Nbr |
| 3 | Business Date | bus_dt | Date | Y | - | - |
| 21 | Operational Company Code | op_cmpny_cd | String | Y | - | - |
| 4 | Store Item ID | mds_fam_id | Integer | - | - | Item Nbr |
| 5 | Vendor Number | vendor_nbr | Integer | - | - | Vendor Nbr |
| 6 | Vendor Name | vendor_nm | String | - | - | Vendor Name |
| 7 | Store In Transit Quantity-This Year | ty_in_trnst_qty | Integer | - | - | Curr Str in Transit Qty |
| 8 | Store In Transit Retail-This Year | ty_in_trnst_rtl_amt | Decimal (18,2) | - | - | Curr Str in Transit Retail |
| 9 | Store In Warehouse Quantity-This Year | ty_in_whse_qty | Integer | - | - | Received QTY at WH (Owned only) |
| 10 | Store In Warehouse Retail-This Year | ty_in_whse_rtl_amt | Decimal (18,2) | - | - | Curr Whse Buyer Orders Sell |
| 11 | Store On Hand Quantity-This Year | ty_on_hand_qty | Integer | - | - | Curr Str on Hand Qty |
| 12 | Store On Hand Retail-This Year | ty_on_hand_rtl_amt | Decimal (18,2) | - | - | Curr Str on Hand Retail |
| 13 | Store On Order Quantity -This year | ty_on_order_qty | Integer | - | - | Curr Str on Order Qty |
| 14 | Store On Order Retail Amount-This Year | ty_on_order_rtl_amt | Decimal (18,2) | - | - | Curr Str on Order Retail |
| 15 | Store Pipeline Quantity-This Year | ty_pipeline_qty | Integer | - | - | - |
| 16 | Replenishment Instock Numerator-This Year | ty_repl_instock_numerator | Decimal (9,4) | - | - | Repl Instock % |
| 17 | Replenishment Instock Denominator-This Year | ty_repl_instock_denominator | Integer | - | - | Repl Instock % |
| 18 | Traited Store/Item Count - This year | ty_traited_cnt | Integer | - | - | Curr Traited Store/Item Comb |
| 19 | Net Receipt Retail Amount-This Year | ty_net_rcpt_rtl_amt | Decimal (11,2) | - | - | Net Ship Retail |
| 20 | Net Receipt Cost Amount-This Year | ty_net_rcpt_cost_amt | Decimal (11,4) | - | Y | Net Ships Cost |
| 22 | Delta Flag | delta_flag | String | - | - | - |
| 23 | Gross receipt quantity-This year | ty_gross_rcpt_qty | Decimal (9,2) | - | - | Gross Ship Qty |
| 24 | Net Receipt Quantity-This Year | ty_net_rcpt_qty | Decimal (11,2) | - | - | Net Ship Qty |
| 25 | Valid Store Item Count-This Year | ty_repl_store_item_cnt | Integer | - | - | Curr Valid Store/Item Comb |
| 26 | Store On Order Cost Amount | on_order_cost_amt | Decimal (18,2) | Y | Curr Str On Order Cost, Curr Corporate Inv Cost With On Orders | |
| 27 | Store On Hand Cost Amount | on_hand_cost_amt | Decimal (18,2) | - | Y | Curr Str On Hand Cost, Curr Corporate Inv Cost With On Orders,Curr Corporate Inv Cost Without On Orders |
| 28 | Store In Warehouse Cost Amount | in_whse_cost_amt | Decimal (18,2) | - | Y | Curr Str In Whse Cost |
| 29 | Store In Transit Cost Amount | in_trnst_cost_amt | Decimal (18,2) | - | Y | Curr Str In Transit Cost, Curr Corporate Inv Cost With On Orders, Curr Corporate Inv Cost Without On Orders |
| 30 | Walmart Year Week Number | wm_yr_wk_nbr | Integer | - | - | Est Unit Turns, Est Retail Turns |
| 31 | Tab Receiving Quantity | tab_rcv_qty | Integer | - | - | Curr Tab On Hand Qty |
| 32 | Max Shelf Quantity | max_shelf_qty | Integer | - | - | Max Shelf Qty |
| 33 | Geographic Region Code | geo_region_cd | String | - | - | - |
| 34 | Currency Code | crncy_cd | String | - | - | - |
| 35 | Gross Receipt Cost Amount | gross_rcpt_cost_amt | Decimal (11,2) | - | Y | Gross Ship Cost, Gross Ship Cost (MTR) |
| 36 | Gross Receipt Retail Amount | gross_rcpt_rtl_amt | Decimal (11,2) | - | - | - |
| 37 | Target Shelf Quantity | trgt_shelf_qty | Integer | - | - | TSS Qty |
| 38 | Retail Price Event Code | rtl_price_event_cd | Integer | - | - | - |
©️Walmart | All Rights Reserved | Confidential
