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

  1. In the Zoey Admin, click Reports.
  2. Type "product totals" in Find a report.
  3. Click Open next to Product Totals. It's in the Products & Inventory category.

Set the Filters

FilterWhat it does
From / ToThe dates to report on. To is required.
Show ByShows one set of rows per Day, Month or Year.
Order StatusAny counts orders in every status. Choose Specified to count only the statuses you pick.
Filter By AttributeCounts only products with the attribute value you choose.

Click Refresh to run the report.

🚧

Simple and configurable products

This report only works for simple and configurable products. Canceled orders aren't counted.

Report Columns

ColumnWhat it shows
Product NameThe product's name
Product SKUThe product's SKU
Quantity OrderedHow many were ordered
SubtotalPrice times quantity
Discount AmountDiscounts on those items
Subtotal with DiscountSubtotal minus discounts
Tax AmountTax on those items
CostProduct 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

💬

Ask about product sales

Click Ask next to Product Totals on the Reports page, or press Ctrl+J (Cmd+J on Mac), and try:

  • "What were our sales and margin by product last quarter?"
  • "Which products had the biggest discounts this month?"

See Running Reports with Zoey AI.


Did this page help you?