For admins who want to see more information about the sales of an Ecommerce Product, the Purchases tab of the product shows line item details from various orders that contain this particular product.
To view this data, go to Ecommerce > Products > click on the product Name (or the Edit link in the Action column). This will open the product in a full page view with multiple tabs. This article explains the Purchases tab.
Please Note: Subscription renewals will not show in the Purchases list because they are not new orders.
Each product in Novi has the following information available on the Purchases tab:
The Order # represents the entire order that contained this particular product (i.e. line item). Clicking the Order # will open the order in a pop-up modal (same as clicking the "Edit Order" link in the Action column). The order may or may not include other products.
Within the pop-up modal, admins can edit the Order Status, Email, Phone, and Purchaser Information. There's also a summary of the order information, a button to view the related transaction, and a link to the Audit Log for this order.
Information about the user who placed the order - name, parent company, phone, email, billing address, membership status, expiration date.
If the user was logged in, their name will be linked to their member record.
If they were not logged in, they will be listed as a Novi Guest (no link). Also note: If you build a Group based on product purchases, guest purchasers are not included in the Group.
Information entered in the "Deliver To" fields at the time of purchase - name, phone, email, and address.
The date the order was created. The list can also be filtered by a date range.
The source of the product purchase. This column is also available as a filter.
Placed by Admin - order placed on the backend
Store - order placed on the frontend website
Event Add-on - purchased along with an event ticket
Membership Add-on - purchased while joining
Connected App - order created by an incoming API feed
The current status of the order. Orders that require fulfillment will be listed as "Open" until an admin updates the status to "Fulfilled" (or the order is canceled). This column is also available as a filter.
This column shows if the transaction is an Invoice or a Sales Receipt, and whether it is Paid or Unpaid. Clicking on the transaction will open the Product Invoice or the Sales Receipt in a modal.
Within the pop-up modal, there's a button to receive payment on invoices, email or print the transaction, and a link to the Audit Log.
The quantity purchased for this particular product. Note that the order may have other products as well, which would not be included here.
The amount charged for the product. Note that this is the cost for a quantity of 1 and will not change based on the quantity in the order.
The amount deducted from the Price Paid, based on the use of a Promo Code.
The amount paid after any discounts were deducted from the original price. Note that this total represents all pages of the Purchases list (based on the filter) - not just the total for the items on page 1.
For purchases with an order type of Event Add-on, this column displays the name of the event where the product was purchased as a registration add-on. Clicking on the name of the event will open the event (on the backend, in a new tab).
Custom fields that are visible in the Ecommerce section will be available as display columns (under the gear icon). This is the setting on the custom field:
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. This is the setting on the custom field:
Additional Options on the Purchases Tab
Search & Filter
Use the search box at the top of the Purchases list to filter by:
Use the Filter drop-down to filter the Purchases list by:
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.
Use the gear icon (on the top right of the Purchases list) to determine the number of rows displayed on each page, and to enable or disable display columns.
Some of the data in this list 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 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
At the bottom of the Purchases list, admins can see totals for the following columns:
Important Note: The totals only reflect what's in Novi. Final accounting reports should be pulled from QuickBooks Online.