/
/
Find customers missing between WooCommerce and Wave
For finance teams who ask their AI assistant to compare WooCommerce and Wave customers and list the differences.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
The store and the books drift apart
Comparing WooCommerce customers with the Wave customer list by hand misses customers who exist in only one system. Rows with no email cannot be matched, so they are easy to overlook.
Without PopdockAI
- Export customers from Wave and WooCommerce
- Combine both lists in a spreadsheet
- Compare emails and names by eye
- Overlook rows with no email
With PopdockAI
- Both lists are read for you
- Emails are matched exactly after cleaning
- Names are compared for matched customers
- Blank emails are listed apart, 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:** Compare customers in Wave and WooCommerce and report who exists in only one system or differs between them. Optional filter: `{email-contains}` (leave empty for all). Company: `{company}` (leave empty if the Wave login has one business).
**Step 1: Read Wave customers**
Call `wave-get-customer` (Wave server) with `email.contains` set to `{email-contains}` when given, and `max-records` 500. Keep `name`, `email`, `display-id`, `outstanding-amount`, `is-active`.
**Step 2: Read WooCommerce customers**
Call `woocommerce-get-customer` (WooCommerce server) with `email.contains` set to `{email-contains}` when given, and `max-records` 500. Keep `customer-id`, `email`, `first-name`, `last-name`, `billing-country`.
**Step 3: Match**
Match on email, lower-cased and trimmed. Rows with no email on either side cannot be matched: list them separately. For matched pairs compare the name (Wave `name` against WooCommerce `first-name` + `last-name`) and flag differences.
**Step 4: Report**
Three lists: in Wave only, in WooCommerce only, matched with differences. End with counts and say if either read hit its `max-records` limit.
**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 either read returns nothing, say which system is empty and stop.
* Never treat a different spelling of a name as a different customer when the email matches.Who it's for
One answer, three teams that use it
Bookkeepers
Find store customers missing from Wave
List WooCommerce customers who have no Wave customer record, ready to add.
Which WooCommerce customers are not in Wave? Match on email.
Finance managers
Check customer data quality
See name differences between the store and the books for the same email.
Show me customers whose name differs between Wave and WooCommerce.
Store owners
Check a group of customers
Narrow the check to one domain when you want to confirm a set of accounts is set up.
Compare Wave and WooCommerce customers with emails containing fabrikam.com.
How it works
What PopdockAI does when you ask
You ask for the comparison and your AI assistant reads Wave and WooCommerce. It only reads on both sides, and tells you if a read hit its limit.
Ask
You say which customers to check, or leave it open, and name the Wave business if needed.
Read
It reads the Wave and WooCommerce customer lists.
Match
It matches on email and compares the names of matched pairs.
Report
It lists Wave only, WooCommerce only and matched with differences, with counts.
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
woocommerce-get-customer
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
A clear list of who is missing or different
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)
