Skip to main content

Sales by Product Report

Analyze product sales, margins, and profitability trends

Updated this week

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.

Did this answer your question?