The Product Report tracks how individual SKUs, categories, and collections are performing; showing revenue, quantity sold, and the number of customers who ordered each item. This article explains the Top Sellers table, Sales by Category, Sales by Collection, and how to filter and export product performance data.
Platform: WizOrder | Who is this for: Admins & Sales Reps
To Get There: Reports > Products
Table of Contents
| Sections | Topics |
| A | View Product Rankings |
| B | Track Category and Collection Performance |
| C | Filter the Product Report |
| D | Export the Product Report |
| E | FAQs |
Before You Begin
- Ensure you have access to the Reports section in WizOrder.
- All metrics update in real time as you apply filters — changing the date range, product, customer, or rep filter immediately recalculates all data on the page.
A. View Product Rankings
The ranking table is sortable by revenue (default), quantity sold, or order count.
Top Sellers
The Top Sellers table shows your best-performing products ranked by how much they've sold within your selected filters. Each row shows:
- Image: A thumbnail of the product so you can identify it at a glance
- Product Name: The name of the product
- SKU ID: The specific variant or SKU that was sold
- Category: The product category it belongs to
- Qty Sold: Total units sold for that SKU
- Value Sold: Total revenue generated — colour-coded in green (darker green = higher revenue, making your top earners easy to spot instantly)
- Order Count: How many orders included this product
- Customers Who Ordered: How many unique customers purchased it
Note:
- The same product can appear more than once if it has multiple SKUs — for example, the Handmade Beaded Chandelier appears twice because two different variants (VANJADE and COKE) are tracked separately.
- A high Qty Sold with a low Order Count often means a single large bulk order — worth checking before concluding demand.
- A high Customers Who Ordered count signals broad, consistent demand across your customer base — very different from a one-off large order.
B. Track Category and Collection Performance
Sales by Category
The Sales by Category table breaks down product performance by category and sub-category. Instead of looking at individual products, this view helps you understand which parts of your catalog are driving the most activity.
Each row shows a category and sub-category pair with the following columns:
- Category: The top-level product grouping (e.g., Cushions, Rugs, Furniture)
- Sub Category: The specific collection or line within that category (e.g., Evan Osiris, Sierra, Temara)
- Qty Sold: Total units sold within that sub-category
- Customers Who Ordered: How many unique customers placed orders in this sub-category
- Confirmed Order Count: Number of confirmed orders, shown with a visual bar for quick comparison
- Confirmed Order Amount: Total revenue from confirmed orders
- Draft Order Count: Number of orders still in draft state
- Draft Order Amount: Total value of orders not yet confirmed
Sales by Collection
The Sales by Collection table shows the same breakdown as Sales by Category — but grouped by collection instead. Use it when your catalog is organised around product lines or themed groups rather than just categories.
Each row shows:
- Collection: The collection name (e.g., Living Room Furniture, Couture Lighting)
- Qty Sold: Total units sold within that collection
- Customers Who Ordered: Unique customers who placed orders from this collection
- Confirmed Order Count: Confirmed orders with a visual bar indicator
- Confirmed Order Amount: Total revenue from confirmed orders
- Draft Order Count: Orders still in draft
- Draft Order Amount: Total value of unconfirmed orders
Note:
- Collections like Living Room Furniture (3,167 units, 15 customers) show strong volume from a small customer base — a sign that a few key accounts are driving most of the demand.
- Use Sales by Collection alongside Sales by Category to get a complete picture. Some products may belong to a high-performing collection but a slow-moving category, or vice versa.
C. Filter the Product Report
Use the available filters to narrow down your data:
- Date Range: Select a predefined period or set a custom date range
- Product Name or SKU: Filter by a specific product or variant
- Category: Narrow by product category
- Customer: Filter by a specific customer account
- Sales Representative: Filter by the rep who placed the order
All metrics update in real time as you apply filters. To learn more about how to use filters on your reports, see the Reports Dashboard & Navigation article.
D. Export the Product Report
- Click the Export button to download a PDF of the Product Report.
The downloaded file includes the ranking table, charts, and all applied filters.
Note: You can also download individual data sets by clicking the download icon next to each section on the page.
FAQs
1. Why does the same product appear more than once in the Top Sellers table?
A. A product appears separately for each SKU it has. For example, if a chandelier has two variants, such as VANJADE and COKE, each variant is tracked and ranked independently in the table.
2. What is the difference between Sales by Category and Sales by Collection?
A. Sales by Category groups performance by your top-level product categories and sub-categories. Sales by Collection groups performance by themed product lines or collections. Use both together to get a full picture of your catalog performance.
3. Can I filter the Product Report by a specific customer or sales rep?
A. Yes. Use the filters at the top of the Product Report page to filter by customer, sales rep, date range, product name, SKU, or category. All metrics and tables recalculate immediately when you change a filter.
Not finding what you need? Browse the WizCommerce Help Center, reach out to your Customer Success Manager, or contact our Support Team.