Run the Product Sales by Customer Report – Vagaro Support

The Product Sales by Customer report shows each customer's product purchases, including quantity bought and total amount spent. Use this report to identify your top product buyers and most valuable customers.

Prerequisites: This feature is available for all Vagaro businesses.

Run the Report

On a Phone

On a phone, the report shows a separate card for each customer who purchased a product during the date range you set.

To run the report:

Select More → Reports → Product Sales by Customer.
At the top of the screen, select the Date Range to report on. The report updates automatically each time you change the date range.
Optionally, in the top-right corner, select Filters , set any of the following filters, and then select Run Report.
- Search: Search for a specific customer, brand, product, or date.
- Transaction Type: Show data for customers who purchased products in-house and/or online.
- Customer General Tag: Show data for customers with a specific customer tag.
- Business Location: If your business has multiple locations, show data for all locations or a specific set of locations.
- Include Past Employees: Include data for employee profiles removed from your business.
- Sort By: Reorder the report.
Optionally, in the top-right corner, select Action to:
- Star or Remove Star: Add or remove a bookmark for this report.
- Print: Print a hard copy of the report.
- Export PDF or Export Excel: Save the report to a PDF or Excel file.
If you sell partial-use products, you can select the Product to see more information.

On a Computer, Tablet, Pay Desk, or PayPro

The report lists the customers who purchased a product during the date range.

To run the report:

Select Reports → Product Sales by Customer.
Optionally, in the top-right corner, select Filters , set any of the following filters, and then select Run Report.
- Date Range: Show data based on the product's purchase date.
- Transaction Type: Show data for customers who purchased products in-house and/or online.
- Search: Search for a specific customer, brand, product, or date.
- Business Location: If your business has multiple locations, show data for all locations or a specific set of locations.
- Customer General Tag: Show data for customers with a specific customer tag.
- Include Past Employees: Include data for employee profiles removed from your business.
Optionally, sort, print, or export the report:
- Select the column headers at the top of the report to sort.
- Select Print to print a hard copy.
- Select Export , then select PDF or Excel for a digital copy.
If you sell partial-use products, you can select the Product to see more information.

What's in This Report?

Generating this report will show the following information about your product sales:

Business Name: The location where this product was purchased.
Customer: The customer who purchased this product.
Purchased Date: The date this product was purchased.
Brand: The brand of the product.
Product: The name of the product.
Quantity: How many times this product was purchased by your customer.
Net Sales: How much revenue you've made from each customer.

Note

On the phone, scroll to the bottom of the screen to see Quantity and Net Sales.