Omni Sales
Support

Omni Sales

Omni Sales

The Omni Sales data provides information about your In-Store and eCommerce sales across five current service channels:

  • Delivery
  • Pickup
  • Buy in Store
  • Ship to Home
  • Ship to Store

It also includes historical data from the Ship from Store service channel.

You can view this data at category–item–day granularity for your products that are supplied to Walmart as of the current date.

What are Omni Sales?

Omni Sales are a combination of both In-Store and eCommerce sales metrics. They provide a holistic view of your total item/category sales.

With this data, you can:

  • Build reports to understand how customers order your products
  • Analyze how customers choose to receive products across service channels
  • Track how channel mix changes over time
  • Create reports and recaps that roll up to the corporate level

Before diving deeper, it’s important to understand service channels.

What is a Service Channel?

A service channel represents:

  • How a customer places an order
  • How the order is fulfilled
  • How the customer receives the order

The Omni Sales data includes the following Walmart service channels:

  • Buy in Store
  • Pickup
  • Delivery
  • Site to Home
  • Ship to Store
  • Ship from Store (historical only)

Note: Marketplace (3P) data is not available in Scintilla and is not included in Omni Sales data.

Service Channel Definitions

Buy in Store (BIS)

Traditional in-store purchases where customers select and buy items in person.

Pickup (PU)

Orders placed online, fulfilled by the store, and picked up by the customer.

  • Includes both scheduled and unscheduled pickup
  • Not differentiated in Omni Sales data

Delivery (DLV)

Orders placed online, fulfilled by the store, and delivered to the customer’s home.

  • Includes scheduled, unscheduled, and in-home delivery
  • Not differentiated in Omni Sales data

Site to Home (S2H)

Orders placed online with two-day shipping:

  • Fulfilled from a Fulfillment Center (FC) or
  • Drop shipped (DSV) from the supplier
  • Delivered to the customer’s home

Ship to Store (S2S)

Orders placed online, fulfilled by the supplier, and shipped to a store for pickup.

  • Currently used only for tires

Ship from Store (SFS) (Historical Only)

A discontinued service channel:

  • Orders placed online with two-day shipping
  • Fulfilled by stores
  • Delivered via carriers (e.g., FedEx)

Historical SFS data is still accessible in Scintilla.

Using Omni Sales Data

Because data comes from multiple service channels, understanding the metrics allows you to drill down into insights for different business needs.

Example Use Cases & Recipes

Note: Element names may change slightly over time as improvements are made.

Use Case #1: Review Overall Category Sales Performance by Channel

Create a report to analyze category performance across service channels and identify which channel drives the most sales.

Relevant Fields

Table Name Technical Name Business Name
Omni Sales wm_item_nbr Walmart Item Number
Omni Sales catlg_item_id Catalog Item ID / eComm Prod ID
Omni Sales svc_chnl_nm Service Channel
Omni Sales order_chnl_nm Order Channel Name
Omni Sales auth_based_gmv_amt AUTH Based GMV Amount
Omni Sales auth_based_net_sales_amt AUTH Based Net Sales Amount
Omni Sales auth_based_qty AUTH Based Item Quantity
Item Attributes item_status_cd Item Status Code
Item Attributes item_name Item Name
Item Attributes omni_catg_nbr Omni Category Number
Item Attributes omni_catg_desc Omni Category Description
Item Attributes omni_catg_grp_nbr Omni Category Group Number
Item Attributes omni_catg_grp_desc Omni Category Group Description
Item Attributes omni_subcatg_nbr Omni Subcategory Number
Item Attributes omni_subcatg_desc Omni Subcategory Description
Product Dimensions prod_nm Product Name
Product Dimensions ecomm_upc_nbr Universal Product Code Number

Use Case #2: Review Item Sales Performance by Channel

Filter by identifiers (e.g., Walmart Item Number) to evaluate how a specific item performs across service channels.

Relevant Fields

Table Name Technical Name Business Name
Omni Sales wm_item_nbr Walmart Item Number
Omni Sales catlg_item_id Catalog Item ID / eComm Prod ID
Omni Sales svc_chnl_nm Service Channel
Omni Sales order_chnl_nm Order Channel Name
Omni Sales auth_based_gmv_amt AUTH Based GMV Amount
Omni Sales auth_based_net_sales_amt AUTH Based Net Sales Amount
Omni Sales auth_based_qty AUTH Based Item Quantity

Analyze trends over time by filtering for a specific period and item.

Example: Identify seasonal sales patterns for a product.

Relevant Fields

Table Name Technical Name Business Name
Omni Sales wm_item_nbr Walmart Item Number
Omni Sales catlg_item_id Catalog Item ID / eComm Prod ID
Omni Sales svc_chnl_nm Service Channel
Omni Sales wm_yr_wk_nbr Walmart Year Week Number
Omni Sales order_chnl_nm Order Channel Name
Omni Sales auth_based_gmv_amt AUTH Based GMV Amount
Omni Sales auth_based_net_sales_amt AUTH Based Net Sales Amount
Omni Sales auth_based_qty AUTH Based Item Quantity
Item Attributes item_status_cd Item Status Code
Item Attributes item_name Item Name
Item Attributes omni_catg_nbr Omni Category Number
Item Attributes omni_catg_desc Omni Category Description
Item Attributes omni_catg_grp_nbr Omni Category Group Number
Item Attributes omni_catg_grp_desc Omni Category Group Description
Item Attributes omni_subcatg_nbr Omni Subcategory Number
Item Attributes omni_subcatg_desc Omni Subcategory Description
Product Dimensions prod_nm Product Name
Product Dimensions ecomm_upc_nbr Universal Product Code Number

©2026 Walmart Inc. All rights reserved.