Connectors

/

Wave

/

Reconcile Wave and Shopify customers
Report
Cross-Connector

Spot customers missing between Shopify and Wave

For finance teams who want their AI assistant to compare the Wave and Shopify customer lists and flag the gaps.

Try PopdockAI free
Get a live demo
Reconcile Wave and Shopify customers
Compare our Wave and Shopify customers by email and show me who is missing on either side. Company is Northwind Books.
Wave and Shopify share 212 customers, with gaps on both sides. - In both: 212 - Only in Wave: 9, outstanding USD 4,120.00 - Only in Shopify: 31, mostly guest checkouts - Name or phone mismatches: 7 Want the 5 Wave customers with no email listed too?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
shopify-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

Duplicates and typos hide between two customer lists

Comparing the accounting list with the store list by hand misses duplicates, typos and customers in only one system. Rows with no email cannot be matched at all.

Without PopdockAI

  • Export customers from Wave and Shopify
  • Line up the two lists in a spreadsheet
  • Compare emails, names and phones by eye
  • Miss the typos and the blank emails

With PopdockAI

  • Both customer lists are read for you
  • Emails are cleaned and matched exactly
  • Names and phones are compared side by side
  • 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 the customer lists in Wave and Shopify, matched on email, and report the gaps and mismatches. Only customers whose email contains `{email-filter}` are checked (default: all). Company: `{company}`.

**Step 1: Read Wave customers**

If you have access to more than one Wave company and `{company}` is empty, ask which company to use before reading anything. Call `wave-get-customer` with `email.contains` set to `{email-filter}` when given, `is-archived` false and `max-records` 500. Keep `name`, `email`, `phone`, `outstanding-amount` and `overdue-amount`. Skip rows with no email and list them separately.

**Step 2: Read Shopify customers**

Call `shopify-get-customer` with `email.contains` set to `{email-filter}` when given and `max-records` 500. Keep `customer-id`, `name`, `email`, `phone`, `orders-count` and `total-spent`.

**Step 3: Match on email**

Lower-case and trim both emails, then match. Three groups: in both, only in Wave, only in Shopify. For customers in both, compare name and phone and flag differences (ignore case and punctuation).

**Step 4: Report**

Counts for each group, then tables: only in Wave (name, email, outstanding amount), only in Shopify (name, email, orders count, total spent), and name or phone mismatches (both values side by side). Finish with the email-less Wave customers.

**Rules & Guidelines:**

* Tools named `wave-*` are on the wave-ai server; tools named `shopify-*` are on the shopify server. Both servers must be connected.
* Do not call any write tool on either server: on Wave 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, and on Shopify every `shopify-add-*` and `shopify-update-*` tool. This prompt only reads.

**Validation:**

* If either read returns 500 rows, warn that the comparison may be incomplete and suggest a narrower `{email-filter}`.
* If one server returns nothing, report that and stop rather than listing everything as missing.

Who it's for

One answer, three teams that use it

Accountants

Find store customers not in the books

See Shopify customers with orders who have no Wave customer record yet.

Which Shopify customers do not exist in Wave yet? Match on email.

Bookkeepers

Clean up mismatched details

Review name and phone differences for customers in both systems, side by side.

Show me Wave and Shopify customers with different names or phone numbers for the same email.

Ecommerce managers

Check a customer segment

Narrow the comparison to one email domain and see which of those customers are billed in Wave.

Compare Wave and Shopify customers with emails containing contoso.com.

How it works

What PopdockAI does when you ask

You ask for the comparison and your AI assistant reads Wave and Shopify. Both systems are read only, and it warns if a result may be incomplete.

Ask

You name the Wave business and, if you like, an email fragment to narrow the check.

Your AI tool

Read

It reads the Wave customers and the Shopify customers.

wave-get-customer
shopify-get-customer

Match

It matches on email and compares name and phone for customers in both.

No items found.

Report

It shows counts, the one-sided customers, the mismatches and customers with no email.

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

shopify-get-customer

Returns Shopify customers with their account state, total spent and default address. Filter by name, email, tags, customer id, city, province, created date and total spent.
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

One view of who is in the books and the store

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