The Omni Sales feed provides information about Omni Sales from all six channels, at an item or Date granularity.
Endpoints
GET
/v2/bulkfeeds/incremental/omni-sales2
POST
/v2/bulkfeeds/incremental/omni-sales2
GET
/v2/bulkfeeds/history/omni-sales2
POST
/v2/bulkfeeds/history/omni-sales2 Feed Channels
The following table provides the Omni Sales feed channels and their fulfillment types.
| Channel | Fulfillment Type |
|---|---|
| Store | BIS (Buy in Store) |
| Store | PICKUP |
| Store | DELIVERY |
| Store | SFS (Ship from Store) |
| Online | S2H (Ship to Home) |
| Online | S2S (Ship to Store) |
NOTE: Marketplace is not part of this data 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 Omni Sales feed details.
| Specification | Details |
|---|---|
| Feed Type | Fact Feed |
| Refresh Frequency | Daily |
| Data Grain | Walmart Item Number, Catalog Item ID / eComm Prod ID, Service Channel, Business Date, Operational Company Code, Geographic Region Code |
| Incremental Data | Incremental + Restatement |
| File Format | orc, parquet |
| Target Refresh Time | Monday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST |
| History | 1 Year |
Feed Structure
The following table provides the Omni Sales feed structure.
| Sequence | Business Name | Technical Name | Data Type (orc, parquet) | Data Type (csv) | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|---|---|
| 1 | Walmart Item Number | wm_item_nbr | Long | String | Y | - | - |
| 2 | Catalog Item ID / eComm Prod ID | catlg_item_id | Long | String | Y | - | - |
| 3 | Service Channel | svc_chnl_nm | String | String | Y | - | - |
| 4 | Business Date | bus_dt | Date | String | Y | - | - |
| 5 | Operational Company Code | op_cmpny_cd | String | String | Y | - | - |
| 6 | Geographic Region Code | geo_region_cd | String | String | Y | - | - |
| 7 | Vendor Number | vendor_nbr | Integer | String | - | - | - |
| 8 | Vendor Name | vendor_nm | String | String | - | - | - |
| 9 | Walmart Year Week Number | wm_yr_wk_nbr | Integer | String | - | - | - |
| 10 | Order Channel Name | order_chnl_nm | String | String | - | - | - |
| 11 | AUTH Based GMV Amount | auth_based_gmv_amt | Decimal (18,2) | String | - | - | - |
| 12 | AUTH Based Net Sales Amount | auth_based_net_sales_amt | Decimal (18,2) | String | - | - | - |
| 13 | AUTH Based Item Quantity | auth_based_qty | Decimal (18,2) | String | - | - | - |
| 14 | Shipped Based GMV Amount | shpd_based_gmv_amt | Decimal (18,2) | String | - | - | - |
| 15 | Shipped Based Net Sales Amount | shpd_based_net_sales_amt | Decimal (18,2) | String | - | - | - |
| 16 | Average Unit Retail Amount | aur | Decimal (18,2) | String | - | - | - |
| 17 | Cost Sales | cost_sales | Decimal (18,2) | String | - | Y | - |
| 18 | Cancel Cost | cncl_cost | Decimal (18,2) | String | - | Y | - |
| 19 | Contract Cost | cntra_cost | Decimal (18,2) | String | - | Y | - |
| 20 | Product Margin | prod_margin | Decimal (18,2) | String | - | Y | - |
| 21 | Delta Flag | delta_flag | String | String | - | - | - |
©️Walmart | All Rights Reserved | Confidential
