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
- In the Zoey Admin, click Reports.
- Type "category" in Find a report.
- Click Open next to By Category. 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. |
| Category | The category to report on. Tick Include Child Categories to include its subcategories. All Categories counts every product. |
| Order Status | Any counts orders in every status. Choose Specified to count only the statuses you pick. |
| Group By | Adds rows for each Account or Customer. |
Click Refresh to run the report.
Current category onlyOnly 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
| Column | What it shows |
|---|---|
| Account ID and Account Name | The Account, when grouped by Account |
| Contact ID and Contact Email | The customer, when grouped by Customer |
| Product Name | The product's name |
| Product SKU | The product's SKU, linked to the product |
| Product Status | Whether the product is enabled |
| Category | The product's category |
| Quantity Ordered | How many were ordered. Click it to see the orders. |
| Revenue (Excl Tax) | Revenue before tax |
| Revenue (Incl Tax) | Revenue including tax |
| Total Cost | Product cost times quantity |
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?
