Product Mix by Store Report

The Product Mix by Store Report compares item sales across multiple store locations within the selected date range.
It’s designed to help multi-location operators identify performance differences, track top sellers at each site, and confirm that menu consistency and pricing are aligned.

Where to find the report

• Backoffice --> Reporting --> Reports --> Sales folder --> Product Mix by Store --> Select Date Range --> Execute

Report Options

Select Locations

• choose as many or as few locations

Filters

• Reporting Groups – Filters the report by preconfigured groups (for example: “Food,” “Liquor,” or “Wine”).
  These groups come from your menu setup and help narrow the results to only items within that group.

• Item Categories – Lets you filter by the Backoffice category assigned to each menu item (for example: “Appetizers,” “Entrees,” “Pizza,” etc.).

• Select Day Part – Runs the report for a specific time block, such as Lunch, Dinner, or Late Night.
  Day Parts are preconfigured in Backoffice and can vary by location.

• Select Order Type – Filters by order types like Dine In, To-Go, Delivery, or Online Order.
  Useful if you want to see how modifier usage differs by service style.

What it looks like

 

Report Samples

Pie Chart

• Displays total sales by Reporting Group as a visual breakdown of where revenue is coming from.

 

Organization / Sections

The report is organized in three layers:

• Reporting Group – Listed alphabetically (e.g., Appetizers, Entrees, Beverages).
  • Category – Each Reporting Group is divided into its assigned categories (e.g., Burgers, Sandwiches, Desserts).
    • Item – Items within each category are listed in order of how frequently they were sold during the selected date range.

This report does not display modifier information—only base menu items.

 

Columns

• Item Name – The menu item sold.

• Store Columns (1–4) – Each store selected appears in its own column, showing that item’s total sales for the chosen period.

  • If an item doesn’t exist or wasn’t sold at a specific store, that column will be blank for that row.

  • Up to four stores fit on one line; additional stores wrap to the next line.

• Total Sales $ – The combined total sales for that item across all selected stores.

 

Subtotals / Grand Totals

• Category Totals: Sum all items within each category across stores.

• Reporting Group Totals: Combine all categories under each Reporting Group.

• Grand Total: Displays total sales for all included stores at the bottom of the report.

 

Special Behaviors

• Only menu items appear; modifier items are excluded.

• The pie chart at the top reflects total sales by Reporting Group, not by store.

• The number of store columns displayed depends on how many locations were selected (up to four per line).
  

 

How to Use This Report

• Compare sales performance of the same items across different stores to identify regional or operational differences.

• Review total sales by Reporting Group using the pie chart to see which categories drive the most revenue.

• Spot menu inconsistencies or missing items if one store doesn’t show sales for an item available elsewhere.

• Use the data to balance inventory or adjust menu focus based on local demand.

• Validate pricing consistency across stores to ensure all locations are aligned.

• Identify underperforming categories or items at specific stores and investigate the cause (e.g., training, placement, or availability).