The Store Sales table provides information about all store sales at item, channel, store, or date level.
Table Channels
The following provides the Store Sales table 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 table. The SFS (Ship From Store) program is planned for discontinue as of Jan 24, 2025, so data would not be available going forward.
Table Details
The following provides Store Sales table details.
| Specification | Details |
|---|---|
| Table Type | Fact |
| Refresh Frequency | Daily |
| Target Refresh Time | Monday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST |
| Data Grain | bus_dt geo_region_cd rpt_cd store_nbr svc_chnl_nm wm_item_nbr |
| Supplier Table Name | wmt-dv-bi-link-prod.dv_supplier.store_sales |
| Catman Table Name | wmt-dv-bi-link-prod.dv_catman.store_sales |
©️Walmart | All Rights Reserved | Confidential
