eComm Inventory Details & Structure

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

- Note : Please refer to the Current Production Schema for the existing table definitions and structures. If you currently consume these tables, review the Planned Schema Updates and prepare your downstream queries, joins, pipelines, and other dependencies for the transition from catlg_item_id to wm_item_nbr.

Important: WPID will be removed as part of the new table structure.

Planned/Upcoming Schema

Feed Details

The following table provides the eComm Inventory feed details.

SpecificationDetails
Feed TypeFact Feed
Feed AvailabilitySupplier and Category Advisor available
Refresh FrequencyDaily
Data GrainWalmart Item Number, Geographic Region Code, Report Date, Ship Node Organization Code, Operational Company Code
Incremental DataDaily Incremental
File Formatorc, parquet, csv
Target Refresh TimeMonday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST
History2 Years

Feed Structure

The following table provides the eComm Inventory feed structure.

SequenceBusiness nameTechnical NameData Type (orc, parquet)Primary KeySensitive MetricsDSS Mapping
1Walmart Item Numberwm_item_nbrLongY--
8Geographic Region Codegeo_region_cdStringY--
9Report Daterpt_dtDateY--
11Ship Node Organization Codeship_node_org_cdStringY--
12Operational Company Codeop_cmpny_cdStringY--
2Available To Sell Retail Amountats_rtl_amtDecimal(38,9)-Y-
3Available to Sell Quantityats_qtyDecimal(38,9)-Y-
4Available To Sell Cost Amountats_cost_amtDecimal(38,9)-Y-
5Trouble Quantitytrbl_qtyDecimal(38,9)---
6Receipts In Progress Quantityrip_qtyDecimal(38,9)---
7Work In Progress Quantitywip_qtyDecimal(38,9)---
10On hand Cost Amounton_hand_cost_amtDecimal(38,9)---
13On Hand Retail Amounton_hand_rtl_amtDecimal(38,9)-Y-
14On Hand Unit Quantityon_hand_unit_qtyDecimal(38,9)---
15Hold Quantityhld_qtyDecimal(38,9)---
16Delta Flagdelta_flagString---

Current Production Schema

Feed Details

The following table provides the eComm Inventory feed details.

SpecificationDetails
Feed TypeFact Feed
Refresh FrequencyDaily
Data GrainCatalog Item ID / eComm Prod ID, Report Date, Ship Node Organization Code, Operational Company Code
Incremental DataDaily Incremental
File Formatorc, parquet
Target Refresh TimeMonday - Friday: 3:00 PM CST
Saturday and Sunday: 11:30 PM CST
History1 Year

Feed Structure

The following table provides the eComm Inventory structure.

SequenceBusiness NameTechnical NameData Type (orc, parquet)Primary KeySensitive MetricsDSS Mapping
1Catalog Item ID / eComm Prod IDcatlg_item_idlongY--
6Report Daterpt_dtdateY--
9Ship Node Organization Codeship_node_org _cdstringY--
10Operational Company Codeop_cmpny_cdstringY--
2Trouble Quantitytrbl_qtydecimal (18,4)--Curr Trouble Bucket (Owned only)
3Receipt In Progress Quantityrip_qtydecimal (18,4)---
4Work In Progress Quantitywip_qtydecimal (18,4)---
5Geographic Region Codegeo_region_cdstring---
7Store On Hand Cost Amounton_hand_cost_amtDecimal (12,2)-YCurr On Hand Cost (Owned only), Hist On Hand Cost (Owned only)
8Walmart Product IDwpidstring---
11On Hand Retail Amounton_hand_rtl_a mtdecimal (12,2)---
12On Hand Unit Quantityon_hand_unit _ qtyinteger--Curr On Hand QTY (Owned only), Hist QTY in Stock (DSV only), Curr QTY in Stock (DSV only), Hist On Hand QTY (Owned only)
13Delta Flagdelta_flagstring---
14Hold Quantityhld_qtydecimal (18,4)---

©️Walmart | All Rights Reserved | Confidential