The Ecommerce 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:
The Ecommerce Sales Report in Novi includes item-level sales for all product orders processed through Novi.
For a full item-level report, including events and membership, you'll want to view the Item Sales Detail Report or use the Sales by Product Detail Report from QuickBooks.
View Ecommerce Sales Report
To access the report, go to Reporting > Ecommerce 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 - delete the date from to view all time or change the date range in the filter)
Search
Order #
Purchaser Name
Related Event
Display Columns
Some columns show by default, others are available under the gear icon. Reference this article for a full list of all available columns: Available Columns in List Views & Exports. 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, 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
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
Hyperlinks
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
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).