The product sales summary tab in the monthly order report offers a clear and concise overview of how each product is performing. This report brings together sales data for every item, giving you valuable insights into total revenue, the ‘Manufacturer’s Suggested Retail Price (MSRP),’ and the quantity sold during the reporting period. It serves as a crucial tool for distilleries to assess product success, highlight top-performing items, and shape inventory and marketing strategies effectively
Purpose of the product sales summary
This tab simplifies the analysis of product performance by summarizing:
The total MSRP generated for each product.
The total quantity of each product sold during the reporting period.
Unlike the Product sales report, which lists individual orders, this summary aggregates data for each product to give a high-level view of overall sales performance.
Key metrics in the report
Product name
Definition: The name of the product sold.
Use case: Identifies each product, allowing distilleries to evaluate which items are driving revenue.
Product SKU
Definition: The unique identifier for the product.
Use case: Facilitates tracking and reporting of individual products across sales and inventory systems.
Sum total MSRP
Definition: The total retail value of the product based on the Manufacturer’s Suggested Retail Price (MSRP), multiplied by the quantity sold.
Use case: Provides a measure of the product’s revenue-generating potential.
Sum total quantity
Definition: The total number of units sold for the product during the reporting period.
Use case: Tracks sales volume and helps distilleries assess demand for specific products.
Example walkthrough of the data
Sample rows
Product Name | Product SKU | Sum Total MSRP | Sum Total Quantity |
My Bourbon | my-bourbon | $69.75 | 1 |
My Vodka | my-vodka | $904.26 | 21 |
My Whiskey | my-whiskey | $749.75 | 25 |
My Gin | my-gin | $450.15 | 15 |
My Rum | my-rum | $247.50 | 10 |
Aggregated example
Metric | Value |
Total MSRP | $183,865.06 |
Total quantity sold | 2,574 |
FAQs
What does Sum Total MSRP represent?
It reflects the total revenue potential based on the Manufacturer’s Suggested Retail Price and the quantity sold during the reporting period.
Can I see product-specific discounts in this report?
No, discounts are reflected in other tabs like the orders report. This tab focuses on gross revenue based on MSRP.
The product sales summary tab provides a streamlined view of product-level performance, helping distilleries focus on their best-sellers and refine their strategies for inventory, marketing, and revenue growth. Use this alongside other tabs, such as the orders report and product sales report, to gain comprehensive insights into your business.
For questions or assistance, contact [email protected].