Connectors

/

Wave

/

Wave sales by product report
Report

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.

Try PopdockAI free
Get a live demo
Wave sales by product report
Report Wave sales by product from 1 July to 30 September for Northwind Traders.
Three products earned 62% of Q3 revenue. - Top: Pro Annual 18,400.00 (31%), Consulting Day 11,200.00 (19%), Pro Monthly 7,100.00 (12%) - Price variation: Consulting Day ranged from 800.00 to 950.00 per unit - Unassigned lines: 1,350.00 - No sales in range: Legacy Support Pack, Pro Trial Want the full table of all 10 top products?
Wave
Sample figures. Your results come from your own account.
wave-get-invoice-item
wave-get-product

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Wave

Wave
Run it on your own Wave data.

Connect Wave, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It reads invoice lines in the range, leaving out draft and void invoices.

wave-get-invoice-item
wave-get-product

Group

It totals quantity, revenue and average price by product and checks sold products for zero sales.

No items found.

Report

It ranks the top 10 with share of revenue and flags price variation and unsold products.

Your AI tool

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.

get-data

wave-get-invoice-item

Returns invoice lines from Wave. Wave connector tool; filter by the parameters it offers.
get-data

wave-get-product

Returns products from Wave. Wave connector tool; filter by the parameters it offers.
Read only.Nothing in Wave Changes

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.

How Popdock AI secures your data

The outcome

Product performance without the pivot table

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation