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

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