Connectors

/

Wave

/

Wave and WooCommerce customer revenue view
Report
Cross-Connector

See a customer's WooCommerce orders and Wave balance together

For sales teams who want one customer's WooCommerce orders, refunds and Wave balance in a single answer from their AI assistant.

Try PopdockAI free
Get a live demo
Wave and WooCommerce customer revenue view
What has dana@northwindtraders.example bought in WooCommerce and what does she owe in Wave?
Northwind Traders has bought regularly and has one open Wave invoice. - Wave: outstanding 320.00, overdue 0.00, 6 invoices - WooCommerce: 9 orders, total spent 2,640.00, 1 refund of 45.00 - Orders with no matching Wave invoice: #3141, #3158 - Outstanding in Wave: INV-1042, 320.00 Want the orders listed by status?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
wave-get-invoice
woocommerce-get-customer
woocommerce-get-order
woocommerce-get-refund

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

Sales and debt sit in two systems

To see what a customer has bought and owes you open WooCommerce, then Wave, and add it up. Orders without invoices and mixed currencies make the total easy to get wrong.

Without PopdockAI

  • Find the customer in Wave and read their balance
  • Find the same customer in WooCommerce
  • Read orders and refunds separately
  • Match orders to invoices and total by hand

With PopdockAI

  • The customer is found by email in both systems
  • Wave balance and WooCommerce orders and refunds come back together
  • Orders with no matching invoice are flagged
  • Amounts stay in their own currency and nothing is written

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Build one view of the customer with email `{customer-email}` across Wave and WooCommerce. Company: `{company}`.

**Step 1: Wave side**

Call `wave-get-customer` (Wave server) with `email` = `{customer-email}`. If it returns more than one customer, list them and stop. Keep `name`, `outstanding-amount`, `overdue-amount`. Then call `wave-get-invoice` with `customer-name` = that name and `max-records` 100.

**Step 2: WooCommerce side**

Call `woocommerce-get-customer` (WooCommerce server) with `email` = `{customer-email}`; keep `customer-id`. Call `woocommerce-get-order` with `customer-email` = `{customer-email}` and `max-records` 100, and `woocommerce-get-refund` with `customer-email` = `{customer-email}`.

**Step 3: Report**

Sections: Wave (balance, overdue, invoices by status), WooCommerce (orders by status, total spent, refunds), then a short comparison: orders with no matching invoice by order number and outstanding invoices on the Wave side. State if either system has no record of the customer.

**Rules & Guidelines:**

* Wave tools (server wave-ai) take an optional `company` argument; pass it on every Wave call when `{company}` is given.
* Read-only. Do NOT call any write tool on either server: on Wave (wave-ai) never call `wave-add-customer`, `wave-update-customer`, `wave-add-invoice`, `wave-add-product` or any other add, update, delete, send, archive or approve tool; on WooCommerce never call `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-update-order`, `woocommerce-add-refund` or any other add or update tool.

**Validation:**

* If the customer exists in only one system, report that side and say the other has no match for the email.
* Report amounts in their own currency and never add across currencies.

Who it's for

One answer, three teams that use it

Sales reps

Check a customer's history before outreach

See their orders, refunds and open invoices in one reply before you call about a new order.

Show priya@contoso.example's WooCommerce orders and refunds and any outstanding balance in Wave.

Shop owners

Find orders that never reached the books

Spot WooCommerce orders with no matching Wave invoice so nothing goes unbilled.

Which WooCommerce orders for tom@fabrikam.example have no matching invoice in Wave, company Fabrikam Holdings?

Bookkeepers

Reconcile a customer across shop and ledger

Compare orders, refunds and invoices for one customer without switching between systems.

Compare WooCommerce orders and Wave invoices for accounts@adventure-works.example and list any refunds.

How it works

What PopdockAI does when you ask

You give an email and your AI assistant reads Wave, then WooCommerce. It stops on unclear Wave matches and never changes a record.

Ask

You give a customer email and the Wave company if needed.

Your AI tool

Wave

It finds the customer, stopping on several matches, and reads balance and invoices.

wave-get-customer
wave-get-invoice
woocommerce-get-customer
woocommerce-get-order
woocommerce-get-refund

WooCommerce

It reads the customer's orders and refunds by email.

No items found.

Report

It shows both sides and compares orders with invoices and outstanding amounts.

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-customer

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

wave-get-invoice

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

woocommerce-get-customer

Returns WooCommerce customer accounts with name, billing address, role and whether they have paid for an order. Filter by email, id, last name, billing country or state, role and created date range.
get-data

woocommerce-get-order

Returns WooCommerce orders with status, totals, discounts, shipping, payment method and paid date. Filter by status, customer email or id, order number, created date range, total range or billing last name.
get-data

woocommerce-get-refund

Returns WooCommerce refunds with amount, reason, who made them and whether the gateway returned the money. Filter by order, customer, amount range and date range.
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

Revenue and balance in one customer view

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