/
/
Check a BigCommerce customer against Business Central
For operations teams who want a store customer compared with the Business Central customer and balance, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Setup differences hide between two admin screens
To check that a customer was set up the same way in both places, someone opens BigCommerce and Business Central side by side. Mismatched emails, phones or a blocked flag are easy to miss, and the balance sits on another screen again.
Without PopdockAI
- Open the customer in BigCommerce
- Find the same customer in Business Central
- Compare contact details and blocked status by eye
- Open another screen for the balance
With PopdockAI
- One customer is found in each system, or it asks which
- Name, email, phone, company, location and blocked status are tabled
- Balance, balance due, credit limit and posting group are added
- Missing fields show as not available, 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:** Compare the BigCommerce customer with email `{email}` against the Business Central customer with the same email, and report every difference.
**Step 1: Find the customer in BigCommerce**
Call `bigcommerce-get-customer` with `email` = `{email}`. If more than one customer matches, list them (id, name, email) and stop. If none match, say so and stop.
**Step 2: Find the customer in Business Central**
Call `business-central-get-customer` with `email` = `{email}`. If `{company}` is given, pass it as `company`. If more than one matches, list them (customer-number, name, email) and ask which one; do not guess. If none match, retry once with `name` set to the BigCommerce `name`; if still none, report the customer as present in BigCommerce and absent from Business Central.
**Step 3: Report**
A two-column table (BigCommerce / Business Central) for: name, email, phone (`phone` vs `phone-number`), company, city and state where available, blocked status, and the Business Central `balance`, `balance-due`, `credit-limit` and `customer-posting-group`. Mark each row Match or Differs, then give a one-line verdict.
**Rules & Guidelines:**
* Tools whose names start with bigcommerce- are on the bigcommerce server; tools whose names start with business-central- are on the business-central server. Both must be connected.
* Read-only: do not call any `-add`, `-update`, `-delete`, `-create` tool on either server.
**Validation:**
* Compare emails case-insensitively and ignore surrounding spaces; compare phone numbers by digits only.
* If either side returns nothing for a field, show "not available" instead of treating it as a difference.Who it's for
One answer, three teams that use it
Order operations
Fix customer setup before it breaks orders
Differences in contact details and a blocked flag are marked row by row.
Compare the BigCommerce customer ap@contoso.com with Business Central.
Credit controllers
See balance and credit limit with the store record
Balance due and credit limit sit next to the store details for a quick credit check.
What is the Business Central balance and credit limit for BigCommerce customer lee@fabrikam.com?
ERP administrators
Check posting groups and blocked status
Posting group and blocked status show whether the customer is set up to trade.
Is the BigCommerce customer orders@northwindtraders.com blocked in Business Central company CRONUS?
How it works
What PopdockAI does when you ask
You give an email and your AI assistant compares the BigCommerce customer with Business Central in one table. It asks rather than guess between look-alikes.
01
Ask
You give the customer's email, and optionally the Business Central company.
02
Find
It finds one customer in BigCommerce and one in Business Central.
03
Compare
It tables each field and marks match or differs.
04
Report
You get the balance, balance due and credit limit with a one-line verdict.
What PopdockAI provides
The tools behind the answer
Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.
bigcommerce-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
Every setup difference and the balance in one table
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)
