--- title: Product Reports description: Track product performance in WizCommerce—view top sellers by revenue and quantity, analyze sales by category, and export data to plan stock. --- [Skip to content](https://knowledge.wizcommerce.com/product-reports#main-content) [![Asset 9](https://knowledge.wizcommerce.com/hs-fs/hubfs/Asset%209.png?width=223&height=30&name=Asset%209.png)](https://wizcommerce.com/) Open main navigation Close main navigation - [Contact us](https://mail.google.com/mail/?view=cm&fs=1&to=help@wizcommerce.com) [Contact us](https://mail.google.com/mail/?view=cm&fs=1&to=help@wizcommerce.com) Hi, how can we help? - There are no suggestions because the search field is empty. 1. [WizCommerce Help Centre](https://knowledge.wizcommerce.com/) 2. [Reports & Analytics](https://knowledge.wizcommerce.com/reports-analytics) 3. [Business Reports](https://knowledge.wizcommerce.com/reports-analytics#business-reports) June 5, 2026 # Product Reports 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](https://knowledge.wizcommerce.com/product-reports#section-a) | | **B** | [Track Category and Collection Performance](https://knowledge.wizcommerce.com/product-reports#section-b) | | **C** | [Filter the Product Report](https://knowledge.wizcommerce.com/product-reports#section-c) | | **D** | [Export the Product Report](https://knowledge.wizcommerce.com/product-reports#section-d) | | **E** | [FAQs](https://knowledge.wizcommerce.com/product-reports#faq) | --- #### 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 ![PR1-1](https://knowledge.wizcommerce.com/hs-fs/hubfs/PR1-1.png?width=670&height=321&name=PR1-1.png)  **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 ![PR2](https://knowledge.wizcommerce.com/hs-fs/hubfs/PR2.png?width=670&height=321&name=PR2.png)  **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 1. Click the ***Export*** button to download a PDF of the Product Report. ![PR3](https://knowledge.wizcommerce.com/hs-fs/hubfs/PR3.png?width=670&height=320&name=PR3.png) 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*](https://knowledge.wizcommerce.com/?hsLang=en-us), reach out to your Customer Success Manager, or contact our [*Support Team*](mailto:help@wizcommerce.com). - [Getting started](https://knowledge.wizcommerce.com/getting-started#main-content) - [Product Overview](https://knowledge.wizcommerce.com/getting-started#product-overview) - [Key Concepts You Should Know](https://knowledge.wizcommerce.com/getting-started#key-concepts-you-should-know) - [Product Guides](https://knowledge.wizcommerce.com/getting-started#product-guides) - [Trade Show Checklist](https://knowledge.wizcommerce.com/getting-started#trade-show-checklist) - [Product Search & Discovery](https://knowledge.wizcommerce.com/product-search-discovery#main-content) - [AI Product Recommendations](https://knowledge.wizcommerce.com/product-search-discovery#ai-product-recommendations) - [Filter and Navigate](https://knowledge.wizcommerce.com/product-search-discovery#filter-and-navigate) - [Catalog](https://knowledge.wizcommerce.com/product-search-discovery#catalog) - [Product Selection & Ordering](https://knowledge.wizcommerce.com/product-selection-ordering#main-content) - [Orders](https://knowledge.wizcommerce.com/product-selection-ordering#orders) - [Quotes](https://knowledge.wizcommerce.com/product-selection-ordering#quotes) - [Cart](https://knowledge.wizcommerce.com/product-selection-ordering#cart) - [Presentations](https://knowledge.wizcommerce.com/product-selection-ordering#presentations) - [Wishlist](https://knowledge.wizcommerce.com/product-selection-ordering#wishlist) - [Item History](https://knowledge.wizcommerce.com/product-selection-ordering#item-history) - [Invoices](https://knowledge.wizcommerce.com/product-selection-ordering#invoices) - [Customers & Accounts](https://knowledge.wizcommerce.com/customers-accounts#main-content) - [Customer Relationship Management (CRM)](https://knowledge.wizcommerce.com/customers-accounts#customer-relationship-management-crm) - [Inventory & Warehousing](https://knowledge.wizcommerce.com/inventory-warehousing#main-content) - [Inventory availability](https://knowledge.wizcommerce.com/inventory-warehousing#inventory-availability) - [Payments](https://knowledge.wizcommerce.com/payments#main-content) - [Payment Dashboard](https://knowledge.wizcommerce.com/payments#payment-dashboard) - [Pricing & Commercials](https://knowledge.wizcommerce.com/pricing-commercials#main-content) - [Pricelist](https://knowledge.wizcommerce.com/pricing-commercials#pricelist) - [Discounts & Promotions](https://knowledge.wizcommerce.com/pricing-commercials#discounts-promotions) - [Claims & Credits](https://knowledge.wizcommerce.com/pricing-commercials#claims-credits) - [AI Co-Workers](https://knowledge.wizcommerce.com/ai-co-workers#main-content) - [Ella - AI Order Entry Assistant](https://knowledge.wizcommerce.com/ai-co-workers#ella-ai-order-entry-assistant) - [WizPilot - AI Assistant](https://knowledge.wizcommerce.com/ai-co-workers#wizpilot-ai-assistant) - [WizStudio](https://knowledge.wizcommerce.com/wizstudio#main-content) - [Creating & Editing Images](https://knowledge.wizcommerce.com/wizstudio#creating-editing-images) - [Lifestyle Generator](https://knowledge.wizcommerce.com/wizstudio#lifestyle-generator) - [Silo Editor](https://knowledge.wizcommerce.com/wizstudio#silo-editor) - [Bulk Silo Editor](https://knowledge.wizcommerce.com/wizstudio#bulk-silo-editor) - [Asset Library (Assets)](https://knowledge.wizcommerce.com/wizstudio#asset-library-assets) - [AI Image Expander](https://knowledge.wizcommerce.com/wizstudio#ai-image-expander) - [Reports & Analytics](https://knowledge.wizcommerce.com/reports-analytics#main-content) - [Business Reports](https://knowledge.wizcommerce.com/reports-analytics#business-reports) - [Manage your WizCommerce (Admin)](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#main-content) - [Import / Export](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#import-export) - [Organizational Settings](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#organizational-settings) - [Product Management](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#product-management) - [Managing Your WizShop Website](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#managing-your-wizshop-website) - [Integration & Apps](https://knowledge.wizcommerce.com/integration-apps#main-content) - [Marketing Integration](https://knowledge.wizcommerce.com/integration-apps#marketing-integration) - [Integration Dashboard](https://knowledge.wizcommerce.com/integration-apps#integration-dashboard) - [Help & FAQs](https://knowledge.wizcommerce.com/help-faqs#main-content) - [Help with Orders](https://knowledge.wizcommerce.com/help-faqs#help-with-orders) - [Help with Quotes](https://knowledge.wizcommerce.com/help-faqs#help-with-quotes) - [Help with Presentation](https://knowledge.wizcommerce.com/help-faqs#help-with-presentation) - [Help with Inventory](https://knowledge.wizcommerce.com/help-faqs#help-with-inventory) - [Help with User Management](https://knowledge.wizcommerce.com/help-faqs#help-with-user-management) - [Help with Pricelist & Discounts](https://knowledge.wizcommerce.com/help-faqs#help-with-pricelist-discounts) - [Help with WizStudio](https://knowledge.wizcommerce.com/help-faqs#help-with-wizstudio) - [Help with Ella](https://knowledge.wizcommerce.com/help-faqs#help-with-ella) - [Help with Org Settings (Admin)](https://knowledge.wizcommerce.com/help-faqs#help-with-org-settings-admin) - [Help with Emails](https://knowledge.wizcommerce.com/help-faqs#help-with-emails) - [Help with Products](https://knowledge.wizcommerce.com/help-faqs#help-with-products) - [Help with Import/Export](https://knowledge.wizcommerce.com/help-faqs#help-with-import-export) - [Help with WizShop](https://knowledge.wizcommerce.com/help-faqs#help-with-wizshop) - [Help with Integration](https://knowledge.wizcommerce.com/help-faqs#help-with-integration) - [Help with Categories and Collections](https://knowledge.wizcommerce.com/help-faqs#help-with-categories-and-collections) - [Help With Customers](https://knowledge.wizcommerce.com/help-faqs#help-with-customers) - [Help with Trade Show](https://knowledge.wizcommerce.com/help-faqs#help-with-trade-show) [![Asset 10](https://knowledge.wizcommerce.com/hs-fs/hubfs/Asset%2010.png?width=238&height=32&name=Asset%2010.png "Asset 10")](https://wizcommerce.com/)   [mailto:help@wizcommerce.com](mailto:help@wizcommerce.com) Copyright © 2025, WizCommerce