/
/
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.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the Wave customers and the Shopify customers.
Match
It matches on email and compares name and phone for customers in both.
Report
It shows counts, the one-sided customers, the mismatches and customers with no email.
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
shopify-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
One view of who is in the books and the store
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)
