Recorded product line amount
Record grain: orderLine
Date basis: Parent order created date; current completed orders
Rules: Line amount before tax; header totals never repeated
Commerce · Google Sheets sample
GoHighLevel Product Sales report template
Inspect sold quantities and recorded sale-time product-line amounts. Missing catalog entries retain the labels recorded with the sale so historical lines remain readable.
Product Sales
Invented sample · Fixed as of October 13, 2026 · USD · America/Chicago
Change filters to explore the sample locally. No account connection.
Recorded product line amount$2,800.00Parent order created date; current completed orders
Units sold6Recorded date in selected period
Orders with sold lines2Recorded date in selected period
Lines without catalog match1Recorded date in selected period
Recorded product line amount over time
2026-10-01–2026-10-13 · Daily · Parent order created date
View chart data
| Group | Value |
|---|---|
| 2026-10-01 | $0.00 |
| 2026-10-02 | $0.00 |
| 2026-10-03 | $0.00 |
| 2026-10-04 | $2,200.00 |
| 2026-10-05 | $0.00 |
| 2026-10-06 | $0.00 |
| 2026-10-07 | $0.00 |
| 2026-10-08 | $600.00 |
| 2026-10-09 | $0.00 |
| 2026-10-10 | $0.00 |
| 2026-10-11 | $0.00 |
| 2026-10-12 | $0.00 |
| 2026-10-13 | $0.00 |
Units sold by product
View chart data
| Group | Value |
|---|---|
| Retired service · sale-time label (catalog missing) | 3 |
| Service package | 2 |
| Consultation | 1 |
| Order | Product at sale | Price ID at sale | Quantity | Recorded line amount | Catalog match |
|---|---|---|---|---|---|
| or1 | Service package · sold line | price1 | 2 | $2,000 | Matched |
| or1 | Consultation · sold line | consultation-price | 1 | $200 | Matched |
| or2 | Retired service · sale-time label | retired-price | 3 | $600 | Missing |
What the metrics mean
Units sold
Record grain: orderLine
Date basis: Recorded date in selected period
Rules: One contributing record per typed ID
Orders with sold lines
Record grain: order
Date basis: Recorded date in selected period
Rules: One contributing record per typed ID
Lines without catalog match
Record grain: orderLine
Date basis: Recorded date in selected period
Rules: One contributing record per typed ID
Required data and boundaries
- Order headers
- Sale-time order lines
- Product references
- Accepted price/interval data
Product-line amounts are distinct from order-header totals. No store visits, advertising return, or profit is inferred from the current product and order sources.
Historic sale-time amounts and labels are authoritative. Current catalog prices do not rewrite past sales. No allocated refunds, cost or margin without a verified line-level ledger.
CRM coverage only · USD; other currencies excluded. Financial units and relationship namespaces are simulated, not provider-validated.
Early access · These public previews use invented records. Join early access to discuss connecting your own GoHighLevel account.
From this sample to a connected report
Choose the template
Use the report whose definitions match the decision you need to make.
Check required inputs
Confirm source access, relevant mappings, history, and any configured goals.
Create the worksheet
The early-access design reuses compatible imports and creates a report worksheet.
Choose freshness
Select source refreshes deliberately. New executions transferring records add usage.
Related report samples
Payments & invoices
Invoice Line Items
Invoice line amounts, quantities and customer detail.
Explore sample →Payments & invoices
Payment Collections
Successful collections, transaction counts and payment types.
Explore sample →Bring your own reporting question.
Make this your reporting workflow.
Explore the samples now. Join the existing waitlist to request connected early access, or discuss a predictable subscription for larger workloads.