The Store Sales feed provides information about all store sales at item, channel, store, or Date level.
Endpoints
GET
/bulkfeeds/incremental/store-sales2 POST
/bulkfeeds/incremental/store-sales2 GET
/bulkfeeds/history/store-sales2 POST
/bulkfeeds/history/store-sales2 Feed Channels
The following table provides the Store Sales feed channels and their fulfillment types.
| Channel | Fulfillment Type |
|---|---|
| Store | BIS (Buy in Store) |
| Store | Pickup |
| Store | Delivery |
| Store | SFS (Ship from Store) |
NOTE: Marketplace, Ship 2 Home (S2H) and Ship 2 Store (S2S) are not part of this feed. The SFS (Ship From Store) program is planned for discontinue as of Jan 24, 2025, so data would not be available going forward.
Feed Details
The following table provides the Store Sales details.
| Specification | Details |
|---|---|
| Feed Type | Fact Feed |
| Feed Availability | Supplier and Category Advisor available |
| Refresh Frequency | Daily |
| Data Grain | Store Number, Walmart Item Number, Service Channel, Business Date, Report Code, Operational Company Code, Geographic Region Code, Store Item ID |
| Incremental Data | Incremental + Restatement |
| File Format | orc, parquet, csv |
| Target Refresh Time | Monday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST |
| History | 2 Years |
Feed Structure
The following table provides the Store Sales structure.
| Sequence | Business Name | Technical Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|---|
| 1 | Store Number | store_nbr | Integer | Y | - | - |
| 2 | Walmart Item Number | wm_item_nbr | Long | Y | - | - |
| 3 | Service Channel | svc_chnl_nm | String | Y | - | - |
| 4 | Business Date | bus_dt | Date | Y | - | - |
| 5 | Store Item ID | mds_fam_id | Long | Y | - | - |
| 6 | Sales By Type | rpt_cd | String | Y | - | - |
| 7 | Operational Company Code | op_cmpny_cd | String | Y | - | - |
| 8 | Geographic Region Code | geo_region_cd | String | Y | - | - |
| 9 | Vendor Number | vendor_nbr | Integer | - | - | - |
| 10 | Vendor Name | vendor_nm | String | - | - | - |
| 11 | Walmart Year Week Number | wm_yr_wk_nbr | Integer | - | - | - |
| 12 | Sales Amount | sales_amt | Decimal (18,2) | - | - | - |
| 13 | Quantity | qty | Decimal (11,2) | - | - | - |
| 14 | Average Unit Retail Amount | aur | Decimal (11,2) | - | - | - |
| 15 | Scan Count | scan_cnt | Integer | - | - | - |
| 16 | Delta Flag | delta_flag | String | - | - | - |
©️Walmart | All Rights Reserved | Confidential
