Product Totals Report
See each product's quantity ordered, sales, discounts, tax and cost for any period.
The Product Totals report shows, for each product, how many were ordered and what they brought in: subtotal, discounts, tax, cost and total.
Use it to:
- See each product's sales and margin for a month, quarter or year.
- Compare products that share an attribute, such as a brand.
Open the Report
- In the Zoey Admin, click Reports.
- Type "product totals" in Find a report.
- Click Open next to Product Totals. It's in the Products & Inventory category.
Set the Filters
| Filter | What it does |
|---|---|
| From / To | The dates to report on. To is required. |
| Show By | Shows one set of rows per Day, Month or Year. |
| Order Status | Any counts orders in every status. Choose Specified to count only the statuses you pick. |
| Filter By Attribute | Counts only products with the attribute value you choose. |
Click Refresh to run the report.
Simple and configurable productsThis report only works for simple and configurable products. Canceled orders aren't counted.
Report Columns
| Column | What it shows |
|---|---|
| Product Name | The product's name |
| Product SKU | The product's SKU |
| Quantity Ordered | How many were ordered |
| Subtotal | Price times quantity |
| Discount Amount | Discounts on those items |
| Subtotal with Discount | Subtotal minus discounts |
| Tax Amount | Tax on those items |
| Cost | Product cost times quantity |
| Product Total (Excl Tax) | Subtotal minus discounts |
| Product Total (Incl Tax) | Subtotal minus discounts, plus tax |
Export the Report
Choose CSV or Excel XML next to Export to and click Export.
Ask Zoey AI
Updated about 2 hours ago
Did this page help you?
