/
/
See which products earn the most in Wave
For sales teams who want revenue by product, share of total and slow sellers from Wave by asking their AI assistant.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Product revenue needs an export and a pivot
To see which products earn the most in Wave you export invoice lines and pivot them by hand. Draft lines can creep in and slow sellers or price drift go unnoticed.
Without PopdockAI
- Export invoice lines for the period
- Remove draft and void lines by hand
- Build a pivot table by product
- Miss products with no sales and price drift
With PopdockAI
- Invoice lines are read for your date range
- Draft and void invoices are excluded
- Revenue, share and average price are grouped by product
- Unsold products and partial totals are flagged and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Report which products and services earned the most from `{from-date}` to `{to-date}`, optionally limited to products containing `{product-filter}`. Company: `{company}`.
**Step 1: Read invoice lines**
If the user has access to more than one Wave company and `{company}` is empty, ask which company to use before reading anything. Call `wave-get-invoice-item` with `invoice-invoice-date.from`, `invoice-invoice-date.to`, `product-name.contains` if a filter was given, and `max-records` 2000. Exclude lines whose `invoice-status` is Draft or Void.
**Step 2: Aggregate**
Group by `product-name`: quantity, subtotal, taxes-amount, total and average `unit-price`. Note lines with no product name as "Unassigned".
**Step 3: Enrich**
Call `wave-get-product` with `is-archived` false and `is-sold` true to flag sold products with zero lines in the range.
**Step 4: Report**
Top 10 products by revenue with share of total, a note on unusual unit-price variation within one product, the unassigned total, and products with no sales.
**Rules & Guidelines:**
* Do not call any write tool (every `wave-add-*`, `wave-update-*`, `wave-delete-*`, `wave-archive-*`, `wave-send-*`, `wave-approve-*`, `wave-mark-*`, `wave-clone-*`, `wave-convert-*`, `wave-reset-*` and `wave-generate-*` tool). This prompt only reads.
* Report each currency separately if more than one appears.
**Validation:**
* If no lines are returned, say so and stop.
* If the maximum records is reached, say the totals are partial.Who it's for
One answer, three teams that use it
Sales managers
See which products carry the revenue
Rank products by revenue and share of total to decide where to focus selling effort.
What were our top Wave products by revenue last quarter, with each one's share of the total?
Product owners
Find slow sellers
Spot sold products with no invoice lines in the period so you can review or retire them.
Which Wave products had no sales between 1 January and 30 June?
Finance analysts
Check for price drift
See unusual unit price variation within one product across invoices in a period.
Report Wave sales for products containing Consulting this year and note any unusual price variation, company Fabrikam Holdings.
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant reads the invoice lines in Wave. It only reads, and it tells you when the totals are partial.
Ask
You give a date range and optionally part of a product name and the Wave company.
Read
It reads invoice lines in the range, leaving out draft and void invoices.
Group
It totals quantity, revenue and average price by product and checks sold products for zero sales.
Report
It ranks the top 10 with share of revenue and flags price variation and unsold products.
What PopdockAI provides
The tools behind the answer
Ready made tools for Wave and one secure connection to your AI tool. No code, no exports.
wave-get-invoice-item
wave-get-product
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Product performance without the pivot table
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
