Maximize Your Profits: The Product Mix Report 📈🍔
Ever wonder which of your dishes are bringing in the most money, or if a specific menu item is being discounted too often? The Product Mix Report is designed to answer one crucial question: "What did we sell, how much of it, and what did it earn?"
As the definitive item-level sales report in NX Restaurant, it breaks down every menu item's quantity sold, average price, gross sales, discounts applied, and net revenue. Whether you are reviewing category performance, evaluating server selling behavior, or simply confirming what moved on a given shift, the Product Mix Report is your perfect starting point.
📊 What You'll See on the Report
The data is cleanly organized to help you see item performance at a glance.
Category Tables: Results are organized by sales category, with one dedicated table per category.
Itemized Rows: Each row represents a specific menu item.
Summary Rows: A summary row sits at the bottom of each table to total the entire category.
📝 Report Example
📖 Column Definitions: What the Numbers Mean
To make auditing easy, here is a quick breakdown of what each performance column tracks:
Qty (Quantity): The total number of units sold across all customer checks during the period.
Avg Price: The average selling price per unit, calculated as Gross $ ÷ Qty.
Gross $: Total revenue generated before any discounts are factored in.
Disc $ (Discounts): The total dollar value of discounts applied against this specific item.
Net $: Your actual recognized revenue, calculated as Gross $ minus Disc $.
🔄 Grouping & Display Options: Changing the Story
By adjusting your settings in the NX Portal, you can restructure the report to look at your restaurant through different lenses:
Top-Level Grouping
Sales Category (Default): Standard menu performance review—one table per category.
Employee: Evaluating individual server selling patterns—one table per staff member.
None: A flat list of every item across all categories compiled into a single table.
Sales Category Display (For Category Grouping)
Nested (Default): Top-level parent categories form the main table headers, while child sub-categories appear as clean section dividers inside the table.
Parent: All items roll up under their top-level parent category, folding the child categories in.
Child: One dedicated table per individual sub-category with no rollups.
🔍 Price Point Detail (Deep Dive)
When you enable Price Point Detail, each menu item row expands to show a breakdown by size or price point. This is incredibly useful for items like beverages or proteins sold in multiple sizes.
The parent item row displays consolidated totals, while the sub-rows beneath it show the breakdown in italics:
Cafe Blend 35 $3.99 $139.65 $0.00 $139.65
small 14 $3.99 $55.86 $0.00 $55.86
medium 12 $4.99 $59.88 $0.00 $59.88
large 9 $5.99 $53.91 $0.00 $53.91
🛠️ Strategic Ways to Use This Data
Menu Engineering: Compare your Qty and Net $ together. High-quantity, high-net items are your menu "stars." High-quantity, low-net items might be underpriced or over-discounted. Low-quantity, high-net items are your hidden gems worth promoting more on the floor!
Discount Exposure: The Disc $ column surfaces exactly which items are most frequently discounted and by how much. This is perfect for evaluating whether your promotional pricing is targeted or drifting too far.
Server Selling Patterns: Grouping by employee shows whether certain staff members consistently upsell higher-margin items or lean too heavily on promotions to close checks. Outliers in either direction are great for a quick coaching conversation.
Category Contribution: Comparing Net $ totals across different category tables shows you exactly which parts of your menu drive the most revenue—and which ones might need a little attention.
Void-Adjusted View: Because this report uses accountable check data, all voided items are automatically excluded. What you see strictly reflects successfully sold and completed orders!
🎛️ Filters and Visual Charts Included
Filters Available
Sales Categories: Limit your results to specific categories.
Order Types: Isolate performance data by Dine In, Takeout, Online, etc.
Revenue Centers: Focus on a specific area of your venue (e.g., Bar vs. Main Dining Room).
Employees: View selling data for specific staff members.
Include Items with No Sales: Show menu items that exist in your configuration but had zero sales during the period.
Include Zero-Priced Items: Show or hide $0.00 items, such as comped items, modifier-only choices, or unpriced items.
📈 Charts Included
When charts are enabled, the report generates two clean visuals:
Sales by Sales Category: A pie chart of Net $ contribution by category, highlighting your top 5.
Top 5 Items: A pie chart showcasing your five highest-grossing individual menu items.
Need Help? 💡
Why are some of my modifiers or sides showing up with $0.00 in the Gross $ column?
If a modifier or side is included in the base price of an item (like standard toppings on a burger), it won't generate individual gross revenue. If you want to hide these from your report view to clean up your screen, simply toggle off the Include Zero-Priced Items filter.
I know an item was ordered today, but it's completely missing from my report.
Double-check that the item wasn't voided! Because the Product Mix report handles actual, completed revenue orders, any item that was voided before payment is automatically excluded from the totals. Check your Void & Delete Report to see if that is where the item went!