/
/
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.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
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.
**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.
Wave
It finds the customer, stopping on several matches, and reads balance and invoices.
WooCommerce
It reads the customer's orders and refunds by email.
Report
It shows both sides and compares orders with invoices and outstanding amounts.
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-customer
wave-get-invoice
woocommerce-get-customer
woocommerce-get-order
woocommerce-get-refund
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
Revenue and balance in one customer view
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)
