By Category Report

See products ordered in a category, with revenue and cost, for any period.

The By Category report lists the products ordered from a category in each day, month or year, with quantity, revenue and cost. You can break it down by Account or customer.

Use it to:

  • See how a category sold this month, quarter or year.
  • Find which Accounts or customers buy from a category.

Open the Report

  1. In the Zoey Admin, click Reports.
  2. Type "category" in Find a report.
  3. Click Open next to By Category. 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.
CategoryThe category to report on. Tick Include Child Categories to include its subcategories. All Categories counts every product.
Order StatusAny counts orders in every status. Choose Specified to count only the statuses you pick.
Group ByAdds rows for each Account or Customer.

Click Refresh to run the report.

🚧

Current category only

Only products currently in the category are shown. If a product was in the category when it was ordered and was later removed, it isn't counted. The report only works for simple and configurable products.

Report Columns

ColumnWhat it shows
Account ID and Account NameThe Account, when grouped by Account
Contact ID and Contact EmailThe customer, when grouped by Customer
Product NameThe product's name
Product SKUThe product's SKU, linked to the product
Product StatusWhether the product is enabled
CategoryThe product's category
Quantity OrderedHow many were ordered. Click it to see the orders.
Revenue (Excl Tax)Revenue before tax
Revenue (Incl Tax)Revenue including tax
Total CostProduct cost times quantity

Export the Report

Choose CSV or Excel XML next to Export to and click Export.

Ask Zoey AI

💬

Ask about category sales

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

  • "Which categories sold the most last quarter?"
  • "Which accounts bought the most from one category this year?"

See Running Reports with Zoey AI.


Did this page help you?