Modifiers Sold
Report Guide for Users
What this report shows, the choices you make when running it, and how to read each section.
What this report is for
The Modifiers Sold report tells you how often specific product modifiers — the add/remove options attached to a product, like a topping, size, or customization — were selected within a date range, which products they were selected on, and how much net sales they generated.
How the report works
You choose a date range and one or more modifiers to report on. The report then totals how many times each option under those modifiers was selected, which products it was applied to, and the net sales tied to it, and also gives you a transaction-by-transaction breakdown of who selected what.
The choices you make when running it
These are the settings available. Everything else is calculated automatically.
1. The time period
| Setting | What it does |
|---|---|
| Start Date | The beginning of the date range you want to report on. |
| End Date | The end of the date range you want to report on. |
2. What to include
| Setting | What it does |
|---|---|
| Modifier Filter | Choose one or more modifiers to report on (for example, "Toppings" or "Size"). At least one must be selected — the report only returns data for the modifier(s) you pick. |
| Location | Choose one or more locations to include. Leave all selected to include every location. |
What's shown on the report
Modifiers Sold
| Column | Description |
|---|---|
| Modifier Name | The modifier the option belongs to (for example, "Toppings"). |
| Modifier Detail Value | The specific option selected under that modifier (for example, "Extra Cheese"). |
| Product Name | The product the modifier was applied to. Shows "Not Associated with a Product" if the modifier wasn't tied to a specific product or product group. |
| Qty | How many times that option was selected. |
| Net Sales | The net sales generated by that modifier option (based on any price adjustment tied to it). |
| Transaction Id | A transaction where that option was selected. |
Modifiers Pivot by Transaction
A second section listing, for each modifier, every transaction where an option under it was selected, along with the guest and the quantity involved.
| Column | Description |
|---|---|
| Transaction Id | The transaction where the modifier option was selected. |
| Guest Name | The guest on the transaction, if one was attached. |
| Quantity Net | The net quantity involved for that transaction. |
How to read the layout
In the Modifiers Sold section, rows are grouped by Modifier Name, each with a Sub Total, and a Grand Total sums everything at the bottom. The Modifiers Pivot by Transaction section below it is grouped by modifier and then by transaction, giving you the transaction-level detail behind the totals above.
Comments
Please sign in to leave a comment.