/
/
Match a BigCommerce customer to their Salesforce record
For sales reps who want store customers compared with Salesforce contacts, leads and accounts, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Mismatched details go unnoticed until the wrong email goes out
A rep checking a BigCommerce customer against Salesforce has two tabs open, copying an email across and comparing names, phones and companies by eye. Mismatches and duplicate records go unnoticed until someone emails the wrong person.
Without PopdockAI
- Copy the email from BigCommerce
- Search Salesforce contacts, then leads
- Compare each field by eye
- Miss a duplicate record
With PopdockAI
- The customer is found in BigCommerce, stopping on several
- The Salesforce contact, lead or account is found by email
- Name, phone, email, company and owner are tabled with match flags
- Duplicates are flagged and listed, 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 `{customer-email}` with the Salesforce records for the same person and report every difference.
**Step 1: Find the customer in BigCommerce**
Call `bigcommerce-get-customer` (BigCommerce server) with `email` set to `{customer-email}`. If nothing comes back, report that the customer is not in BigCommerce and stop. If more than one row comes back, list them with `id` and `name` and stop.
**Step 2: Find the person in Salesforce**
Call `salesforce-get-contact` (Salesforce server) with `email` set to the BigCommerce `email`. If no contact matches, call `salesforce-get-lead` with the same `email`. If the BigCommerce customer has a `company`, also call `salesforce-get-account` with `name` set to that company.
**Step 3: Report**
Show one table with a row per field and three columns: BigCommerce, Salesforce, Match. Compare name (BigCommerce `name` against Salesforce `name`), `phone`, `email`, company (BigCommerce `company` against the Salesforce `account-name` or lead `company`), and owner. Then state one of: contact found, lead only, account only, or not in Salesforce.
**Rules & Guidelines:**
* `bigcommerce-get-customer` is on the BigCommerce server. `salesforce-get-contact`, `salesforce-get-lead` and `salesforce-get-account` are on the Salesforce server.
* This prompt is read-only. Do not call any `bigcommerce-customer-add`, `bigcommerce-customer-update`, `salesforce-add-contact`, `salesforce-add-lead`, `salesforce-add-account` or `salesforce-update-contact` tool.
* Compare emails case-insensitively and phone numbers by digits only.
**Validation:**
* If more than one Salesforce record matches the email, list them all and flag the duplicate.
* If either server returns an error, say which server and stop; do not guess the other side.Who it's for
One answer, three teams that use it
Sales reps
Contact the right record
Know whether the buyer is a contact, a lead or not in Salesforce before you reach out.
Is jo@contoso.com from BigCommerce a contact or a lead in Salesforce?
Salesforce administrators
Find duplicate records
Several matching records are listed and flagged, so you can merge them.
Does lee@fabrikam.com from BigCommerce match more than one Salesforce record?
Sales operations
Fix field differences
A field-by-field table shows which phone, company or name needs correcting.
Show every field that differs between BigCommerce and Salesforce for sam@northwindtraders.com.
How it works
What PopdockAI does when you ask
You give a customer email and your AI assistant matches the BigCommerce customer to Salesforce. It stops and names the system if anything errors.
01
Ask
You give the customer's email address.
02
Find
It looks up the customer in BigCommerce, stopping if there are several.
03
Match
It finds the Salesforce contact, then a lead or account if needed.
04
Report
You get a field-by-field table with match flags and 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
salesforce-get-contact
salesforce-get-lead
salesforce-get-account
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 field difference in one table, duplicates flagged
Related use cases
More ways to put this data to work
Find BigCommerce customers missing from Salesforce
Ask your AI which recent BigCommerce customers are not in Salesforce contacts or leads and it lists them, flags a capped list and creates nothing.
Learn More
BigCommerce order and Salesforce pipeline summary
Ask your AI to join a customer's BigCommerce orders with their Salesforce open opportunities and cases in one summary.
Learn More
Show BigCommerce order history for a Salesforce case
Ask your AI for the BigCommerce orders behind a Salesforce case and it finds the customer by email and lists their orders, flagging the likely related one.
Learn More
Compare BigCommerce products with Salesforce
Ask your AI to compare a SKU in BigCommerce with the Salesforce product and price book entries for name, status and price, with missing sides reported and nothing changed.
Learn More
Review large BigCommerce orders against Salesforce
Ask your AI to review large BigCommerce orders against Salesforce and it shows each buyer's contact and open opportunity, listing orders it cannot match.
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.