Connectors

/

Wave

/

Reconcile Wave and WooCommerce customers
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile Wave and WooCommerce customers
Compare our Wave customers with WooCommerce customers and tell me who is missing from either one.
Most customers match, but there are gaps on both sides. - In Wave only: 6, outstanding USD 1,980.00 - In WooCommerce only: 18 - Matched with name differences: 5 - Rows with no email: 4, listed separately Do you want these narrowed to one email domain?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
woocommerce-get-customer

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

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.

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

Your AI tool

Read

It reads the Wave and WooCommerce customer lists.

wave-get-customer
woocommerce-get-customer

Match

It matches on email and compares the names of matched pairs.

No items found.

Report

It lists Wave only, WooCommerce only and matched with differences, with counts.

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

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

A clear list of who is missing or different

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