Connectors

/

BigCommerce

/

Find BigCommerce customers missing from Salesforce
Report
Cross-Connector

Find BigCommerce customers missing from Salesforce

For marketing teams who want new store customers in Salesforce, by asking their AI assistant to check.

Try PopdockAI free
Get a live demo
Find BigCommerce customers missing from Salesforce
Which BigCommerce customers from the last 30 days are not in Salesforce? Check up to 25.
4 of the 25 customers checked are missing from Salesforce. - In contacts: 17 - In leads: 3 - No email: 1 - Missing: Dana Whitfield, dana@northwindtraders.com, Northwind Traders, 555-0142 The limit of 25 was reached, so the list may be incomplete. Want the other 3 missing customers?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
salesforce-get-contact
salesforce-get-lead

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

Connect BigCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Checking contacts and leads one email at a time

New BigCommerce customers never reach Salesforce, and finding them means exporting emails and searching one at a time. Contacts and leads both have to be checked, and customers with no email cannot be matched at all.

Without PopdockAI

  • Export new customer emails from BigCommerce
  • Search Salesforce contacts for each one
  • Search leads for those not found
  • Lose track of customers with no email

With PopdockAI

  • Recent customers are read, up to your limit
  • Each email is checked in contacts, then in leads
  • Customers are marked in contacts, in leads or missing
  • No-email customers are listed apart, and no leads are created

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 BigCommerce customers created in the last `{lookback-days}` days (default 30) that do not exist in Salesforce, checking at most `{max-customers}` customers (default 25).

**Step 1: Recent customers in BigCommerce**

Call `bigcommerce-get-customer` (BigCommerce server) with `date-created.from` set to the start of the window and `max-records` set to the limit. Keep `id`, `name`, `email`, `company` and `phone`.

**Step 2: Check each one in Salesforce**

For each customer with an `email`, call `salesforce-get-contact` (Salesforce server) with that `email`. If nothing matches, call `salesforce-get-lead` with the same `email`. Mark the customer as in-contacts, in-leads or missing. Customers with no email are listed separately as unmatchable.

**Step 3: Report**

First a count line: checked, in contacts, in leads, missing, no email. Then a table of the missing customers with `name`, `email`, `company`, `phone` and the BigCommerce `date-created`.

**Rules & Guidelines:**

* `bigcommerce-get-customer` is on the BigCommerce server; `salesforce-get-contact` and `salesforce-get-lead` are on the Salesforce server.
* Read-only. Do not call `salesforce-add-lead`, `salesforce-add-contact` or `bigcommerce-customer-update`; the user can ask for leads to be created afterwards.
* Compare emails case-insensitively.

**Validation:**

* If BigCommerce returns no customers in the window, say so and stop.
* If the limit was reached, say the list may be incomplete.

Who it's for

One answer, three teams that use it

Marketing operations

Get new buyers into the CRM

A clear list of missing customers is ready to import or route to the team.

Which BigCommerce customers from the last 30 days are missing from Salesforce? Check 50.

Sales development reps

Find buyers with no record

Customers in neither contacts nor leads are new people to reach out to.

List new BigCommerce customers this week with no Salesforce contact or lead.

Salesforce administrators

Measure the gap between store and CRM

Counts by status show how many new customers reach Salesforce on their own.

Of the last 100 BigCommerce customers, how many are contacts, leads or missing in Salesforce?

How it works

What PopdockAI does when you ask

You say how far back to look and how many to check, and your AI assistant checks new BigCommerce customers in Salesforce. It says when the limit was reached.

01

Ask

You say how many days back to look and how many customers to check.

Your AI tool

02

Read

It reads recent BigCommerce customers up to that number.

bigcommerce-get-customer

03

Check

It looks each email up in Salesforce contacts, then in leads, and sets aside customers with no email.

salesforce-get-contact
salesforce-get-lead

04

Report

It shows counts first, then a table of the missing customers.

Your AI tool

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.

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

salesforce-get-contact

Returns Salesforce contacts with their account, title, department, email, phone, mailing address, owner and lead source. Filter by name, email, account, title, owner, lead source and mailing city or state.
get-data

salesforce-get-lead

Returns Salesforce leads with their company, status, source, owner, contact details, location and whether they are converted. Filter by name, company, email, status, lead source, owner, state, converted flag and created date.
Read only.Nothing in BigCommerce 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

Store customers missing from Salesforce, ready for follow-up

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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