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.

Please Note:


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

Filter

  • Products (multi-select)
  • Product Category (multi-select)
  • Order Type
  • Order Status
  • Date (defaults to last 30 days - click the Clear Filter link to view all time or change the date range in the filter)
  • Order #
  • Purchaser Name
  • Related Event

Display Columns

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.

  • Product
  • Order #
  • Date
  • Order Type - store, admin, event add-on, or membership add-on
  • Order Status - open, fulfilled, or cancelled
  • Payment Status - invoice or sales receipt, paid or unpaid, blank for free products
  • Quantity
  • Price Paid
  • Discount
  • Net Amount
  • Related Event
  • 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
  • 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

Totals

At the bottom of the list, admins can see totals for the following columns:

  • Quantity
  • Discount
  • Net Amount

Important Notes:

  • 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).
Did this answer your question?