/
/
Compare a Shopify customer with their FreshBooks client
For finance teams who want customer details checked across both systems by asking their AI assistant with an email address.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Customer details drift between Shopify and FreshBooks
Comparing a Shopify customer with the FreshBooks client for the same person means opening two screens and reading fields side by side. Mismatched emails, names, phones or countries go unnoticed until an invoice or message goes to the wrong place.
Without PopdockAI
- Open the customer in Shopify
- Find the client in FreshBooks
- Read name, email, phone and country side by side
- Miss differences in case or country format
With PopdockAI
- The Shopify customer and FreshBooks client are found by email
- Several matches on either side stop it with a list
- Each detail is marked Match or Differs, ignoring case
- Order count and spend are shown, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find the Shopify customer with email `{email}` and the FreshBooks client with the same email, and report whether their details agree. FreshBooks company: `{company}` (ask if the account has more than one and none is given).
**Step 1: Find the Shopify customer** (shopify server)
Call `shopify-get-customer` with `email` set to `{email}`. If more than one customer returns, list them (customer-id, name, email) and stop. Keep customer-id, first-name, last-name, phone, default-address-country-code, orders-count and total-spent.
**Step 2: Find the FreshBooks client** (freshbooks server)
Call `freshbooks-get-client` with `email` set to the same value and `company` set to `{company}`. If nothing returns, report the customer as present in Shopify and absent from FreshBooks, then skip to Step 3. If more than one returns, list them and stop.
**Step 3: Report**
Show a side-by-side table: first name, last name, email, phone (compare Shopify phone with FreshBooks mobile-phone and business-phone), country (Shopify default-address-country-code against FreshBooks billing-country). Mark each row Match or Differs. Add one line on the Shopify orders-count and total-spent.
**Rules & Guidelines:**
* `shopify-get-customer` is on the shopify server; `freshbooks-get-client` is on the freshbooks server.
* Read-only. Do not call `freshbooks-add-client`, `freshbooks-update-client`, `shopify-add-customer` or `shopify-update-customer`.
**Validation:**
* Compare emails case-insensitively and names ignoring case and extra spaces.
* Country codes in Shopify are two-letter; FreshBooks may hold a full name. Treat them as matching when they refer to the same country.
* If neither side returns a record, say so and stop.Who it's for
One answer, three teams that use it
Bookkeepers
Send invoices to the right place
Check that the client's email and country match the store before an invoice goes out.
Compare the Shopify customer alex@contoso.com with her FreshBooks client.
Customer service reps
Confirm details when a customer calls
See both records side by side, so you can tell the customer which details need updating.
Does the phone number for sam@fabrikam.com match between Shopify and FreshBooks?
Store owners
Keep one picture of each customer
Spot where store and accounting records disagree, along with how much the customer has spent.
What does not match between Shopify and FreshBooks for jordan@northwindtraders.com?
How it works
What PopdockAI does when you ask
You give an email, and your AI assistant finds the customer in both systems and compares their details. It only reads and tells you if the client is missing.
01
Ask
You give the customer email and the FreshBooks company.
02
Find
It looks up the Shopify customer and the FreshBooks client, and stops if several match.
03
Compare
It checks name, email, phone and country, ignoring case and spacing.
04
Report
You get a side by side table with each row marked Match or Differs.
What PopdockAI provides
The tools behind the answer
Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.
shopify-get-customer
freshbooks-get-client
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
Detail mismatches spotted in one view
Related use cases
More ways to put this data to work
Shopify customer orders against FreshBooks balance
Ask your AI for a customer's Shopify orders beside their FreshBooks invoiced, paid and outstanding totals. Currencies stay separate and nothing is changed.
Learn More
Match a Shopify order to its FreshBooks invoice
Ask your AI to find the FreshBooks invoice for a Shopify order. It compares total, currency and payment status, and flags cancelled orders without guessing.
Learn More
Compare Shopify products with FreshBooks items by SKU
Ask your AI to match Shopify variants and FreshBooks items by SKU. It lists items missing on either side and price differences, and fixes nothing.
Learn More
Find unbilled Shopify orders in FreshBooks
Ask your AI which paid Shopify orders have no FreshBooks invoice. It lists them with totals and whether the client exists, and creates nothing.
Learn More
Add missing Shopify customers to a Constant Contact list
Ask your AI to add missing Shopify customers to Constant Contact and it finds opted-in buyers not already there, skips anyone who unsubscribed and adds them after you confirm.
Learn More
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.