This feature is only available for Lightspeed Retail merchants on select pricing packages.
Modifiers & Variants Report
Use the Modifiers and Variants report to view item, modifier, and variant sales to determine things like which item version is performing well, which modifiers are frequently chosen, or which variant is least popular.
This report “flattens” the Sales by Item report data. Instead of displaying modifiers and individual variant sales rolled up into the basic item or product with variants total, with nested details available via overlay, everything is visible in the same table. This gives you a more granular comparison to work with.
Here, we’ll show you how to read and run the report in a variety of ways.
Table of Contents
Run the Report
Visit BackOffice to run the report and view item sales data, including modifiers and variants sold.
In BackOffice, click ‘Reports’ and select ‘Modifiers and Variants’.
Click to Enlarge
Click the Date icon to choose a preset or custom range then click ‘Retrieve’.
Click to Enlarge
Read the Report
The Modifiers and Variants report reveals sales data on all items, modifiers, and variants sold in one report. Use the report to gain insight into sales during a specified date range including details such as total sales, quantity sold, and net sales.
Differentiate among different item types by looking at the Name column:
Basic item rows are indicated by a bold item name.
Modifiers are separate rows indented underneath a basic item name.
Variants are indicated by item names that have a dash in the middle identifying the top-level item and the specific variant in a single row.
Columns
The Quantity Returned, Returns Amount, Current Cost, Total Costs, Discounts, Gross Margin, and Gross Profit columns are hidden by default. Make sure to enable them in the Filter menu if you’d like to see a full detailed report. Click any header with arrows to sort the table ascending. Click again to sort descending.
* Item totals are calculated without the price and quantity of the modifications included. The Total row includes all variants, basic items, and modifiers.
Basic Item & Item with Variants Rows
Name | Name of the item as it is currently entered in BackOffice. Quantity Sold | Total number of units of the item sold. Current Price | Item’s price at the time the report is run. Sales Amount | Dollar amount of the item sold, not including modifiers. This is based on the price of the item at the time of sale and the quantity sold. Quantity Returned | Total number of units of the item returned. Returns Amount | Dollar amount of the item returned, not including modifiers. This is based on the price of the item at the time of the original sale and the quantity returned. Current Cost | Cost of the item at the time the report is run. Total Costs | Cost of goods sold for the item based on the item cost at the time of sale. Discounts | Discounts on all sold items minus discounts on returns. Check out the Sales by Discount report for a detailed breakdown. Net Sales | Sales Total, minus Returns Total, and minus Discounts Gross Margin | The difference between Net Sales and Total Costs, divided by Net Sales. Gross Profit | Net Sales minus Total Costs.
Modifier Rows
Name | Name of the modifier as it is currently entered in BackOffice. Quantity Sold | Total number of units of the modifier sold. Current Price | Modifier’s price at the time the report is run. Sales Amount | Dollar amount of the modifier sold based on the price of the modifier at the time it was sold and the quantity sold. Quantity Returned | Total number of units of the modifier returned. Returns Amount | Dollar amount of the modifier returned based on the price of the modifier at the time of the original sale and the quantity returned. Net Sales | Sales Total, minus Returns Total, and minus Discounts.
Filter the Report
Filter the report by column to customize which table columns appear on the report. Filter by item to hide items you don’t want to see or to display only specific items.
Click ‘Filter’.
To hide a row, click ‘Show/Hide’ and check/uncheck the boxes to include/exclude headers.
Only the Quantity Sold, Current Price, Sales Amount, and Net Sales columns are checked by default. Note that Modifiers cannot be filtered.
Click 'Items' to filter by item name. Check/uncheck the box next to an item's name to include/exclude it.
Use the search bar to quickly find a specific item to filter or scroll through your complete item list.
Export the Report
Download a copy of your Modifiers and Variants report to analyze and filter the data using spreadsheet software. Export the report and filter/sort it in spreadsheet software to view items with variants in an organized group. Note that the export will include any row filters you’ve set prior to exporting.
On the Table View, click ‘Export’.
Wait for the export to generate. Check the box to be notified by email when exports are ready for download (optional).
Exports ready within a few seconds will automatically download to your computer. Click ‘Close’ to close the message box.
Exports that take more than a few seconds to generate are downloadable via the Export Center when ready. Click ‘Ok’ to close the message box.
After downloading, the export is ready to open in any spreadsheet software.
