The Sales by Product Report in Appliance.io is one of the most powerful tools for understanding your store’s performance. It gives you a clear picture of how individual products are selling, how much revenue they generate, what they cost you, and the profit they bring in. With this information, you can quickly identify bestsellers, manage your inventory more strategically, and make data-driven decisions that directly boost profitability.
📍 Accessing the Report
From the sidebar, click Reports
Select Sales by Product
By default, the report shows data from one year back from today.
You’ll also see a By Paid Date toggle:
ON (default): Shows data based on when the customer paid
OFF: Switches the report to delivered date
🎛 Filters & Options
Use filters to refine your report:
Brand
Location
Source
Model Number
Sales Person
Condition
Category
👉 Click Reset Filter anytime to start fresh.
Extra options include:
Custom Product Only toggle → Show only custom products
Export → Download the report in CSV or Excel format (exports always match your applied filters)
📊 Tiles Overview
At the top of the report, you’ll see summary tiles that give you an at-a-glance performance snapshot:
Total Quantity → Sum of all units sold
Total Revenue → Sales before costs are deducted
Average Revenue → Revenue ÷ Quantity
Total Cost → Combined cost of products (untagged items show $0)
Average Cost → Cost ÷ Quantity
Total Profit → Revenue – Cost
Average Profit → Profit ÷ Quantity
Total Gross Margin → (Revenue – Cost) ÷ Revenue × 100
Average Gross Margin → Total Gross Margin ÷ Total Data
📑 Detailed Report View
Scroll down to see the full product breakdown, including:
Date Sold
Order Number
Model Number
Store Location
Sales Person
Quantity
Revenue
Cost
Gross Margin
Profit
Delivery Date
💡 Pro tip: Click on an Order Number or Model Number for a deeper look into that specific record.
🎉 You’re Ready!
The Sales by Product Report makes it easy to track product performance, monitor sales trends, and evaluate profitability. Whether you’re analyzing margins or identifying top sellers, this report is your go-to tool for smarter decision-making.