Connectors

/

Wave

/

Compare a customer in Wave and BigCommerce
Report
Cross-Connector

Check a customer matches in Wave and BigCommerce

For finance and operations teams who want one customer compared between the shop and the books by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare a customer in Wave and BigCommerce
Compare priya@contoso.com in Wave and BigCommerce. Do her details match and what does she owe?
Priya Shah exists in both systems, with one difference. - Name: matches - Phone: differs (Wave 555-0142, BigCommerce 555 0143) - Company: Contoso in both - Wave balance: 480 outstanding, 0 overdue Nothing has been changed. Want the BigCommerce customer id and the date the account was created?
Wave
Sample figures. Your results come from your own account.
bigcommerce-get-customer
wave-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

Shop and books can disagree about one customer

A customer's details can differ between BigCommerce and Wave, and checking means opening both and comparing by eye. Mismatches stay hidden until something goes to the wrong person.

Without PopdockAI

  • Find the customer in BigCommerce
  • Find the same customer in Wave
  • Compare name, phone and company by eye
  • Check the balance owing separately

With PopdockAI

  • Both systems are searched by email
  • Fields are compared ignoring case, spacing and punctuation
  • Balance owing is shown with the differences
  • Several matches or a missing side are reported, 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.

Prompt
**Objective:** Find the customer with email `{email}` in both Wave (company `{company}`, optional) and BigCommerce and report where the two records agree and differ.

**Step 1: Look up the BigCommerce customer**

Call `bigcommerce-get-customer` (BigCommerce server) with `email` set to `{email}`. If nothing comes back, try `email.contains`. If more than one customer matches, list them (id, name, email) and stop.

**Step 2: Look up the Wave customer**

Call `wave-get-customer` (Wave server) with `email` set to the email from step 1 (or `{email}` if step 1 found nothing). Pass `company` only if `{company}` is not empty. If more than one matches, list them and stop.

**Step 3: Compare**

Compare name, first-name, last-name, phone and company (BigCommerce) against name, first-name, last-name, phone and mobile (Wave). Ignore case, spacing and punctuation in phone numbers.

**Step 4: Report**

Give a short table: field, BigCommerce value, Wave value, match or differ. Add the Wave outstanding-amount and overdue-amount, and the BigCommerce customer id and date-created. End with one line stating whether the customer exists in both, only BigCommerce or only Wave.

**Rules & Guidelines:**

* `bigcommerce-get-customer` is on the BigCommerce server; `wave-get-customer` is on the Wave server.
* Do not call any write tool on either server: no `wave-add-*`, `wave-update-*`, `wave-delete-*`, `wave-send-*`, `wave-mark-*`, `wave-approve-*`, `wave-archive-*` or `wave-clone-*` tools, and no `bigcommerce-*-add`, `bigcommerce-*-update` or `bigcommerce-*-delete` tools.

**Validation:**

* If the customer is missing on one side, report that side as absent and still show the other record.
* If the two systems format a value differently (for example phone), say so rather than calling it a conflict.

Who it's for

One answer, three teams that use it

Bookkeepers

Check the books match the shop

Confirm a customer's name, phone and company agree in Wave and BigCommerce before sending an invoice.

Compare tom@fabrikam.com in Wave and BigCommerce and show any fields that differ.

E-commerce managers

Find customers missing from the books

See at once when a shop customer has no record in Wave, or the other way round.

Is dana@northwindtraders.com in both BigCommerce and Wave? Say which side is missing if not.

Credit controllers

See what a shop customer owes

Get the outstanding and overdue amounts from Wave next to the shop record before a reminder.

Show what jamie@contoso.com owes in Wave and confirm the details match the BigCommerce customer.

How it works

What PopdockAI does when you ask

You give an email and your AI assistant looks the customer up in both systems. It only reads, and it stops to ask rather than choose between several matches.

Ask

You give the customer's email.

Your AI tool

Find

It looks the customer up in BigCommerce, then in Wave, and stops if several match.

bigcommerce-get-customer
wave-get-customer

Compare

It compares name, phone and company details, ignoring case, spacing and phone punctuation.

No items found.

Report

You get a field table with the balance owing and whether the customer exists in both.

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

bigcommerce-get-customer

Returns customers from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
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 customer, one consistent record

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