The Product Sales Report gives you the opportunity to view a list of all product purchases entered in Novi, so you can filter product orders and act on that data.
The Product Sales Report in Novi includes item-level sales for all product orders processed through Novi.
For a full item-level report, you'll still want to pull a Sales by Product Detail Report from QuickBooks.
View Product Sales Report
To access the report, go to Reporting > Product Sales.
The default view will display the last 30 days.
See the Functionality section below for more information on how to pull the specific information you need for your report.
Product Sales Report Functionality
Product Category (multi-select)
Date (defaults to last 30 days - click the Clear Filter link to view all time or change the date range in the filter)
Some columns show by default, others are available under the gear icon. The report can be sorted by any of the columns (except Payment Status) by clicking on the column header.
Order Type - store, admin, event add-on, membership add-on, or connected app
Order Status - open, fulfilled, or cancelled
Payment Status - invoice or sales receipt, paid or unpaid, blank for free products
Delivery Info - name, phone, email, address
Purchaser Info - name, parent company, phone, email, billing address, membership status, expiration date
Custom fields that are visible in the Ecommerce section
Custom fields that are visible in the Member List View will also be available here - they will have "Purchaser" in front of the custom field name
Some of the data in this report is displayed as a hyperlink so you can jump to those items on the backend. Tip: Open these links in new tabs so you don't lose your report filters.
You can click on a specific Product from this report page to go to the product on the backend
To open a specific order, you can click on the Order # or the Edit link in the Action column
To open a transaction, click on the Invoice or Sales Receipt in the Payment Status column
In the Purchaser column, you can click on the Purchaser's Name or the Purchaser's Parent Company (if applicable) to open the corresponding member record
If the Order Type is an event add-on, you can click the Related Event link to open the event on the backend
Print & Export
Use the printer icon to print or save the list as a PDF file
Use the Excel icon to export the list as a CSV file
At the bottom of the list, admins can see totals for the following columns:
The totals only reflect what's in Novi. Final accounting reports should be pulled using the Sales by Product Detail Report from QuickBooks Online.
The totals are based on the filter(s) - if the results of your filters are displayed on 3 pages, the totals will reflect all 3 pages (not just page 1).