Connectors

/

BigCommerce

/

Find BigCommerce customers missing from Capsule CRM
Report
Cross-Connector

Find BigCommerce customers missing from Capsule CRM

For sales teams who want new store customers checked against Capsule CRM contacts by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find BigCommerce customers missing from Capsule CRM
Which BigCommerce customers from the last 30 days are missing from Capsule CRM?
Of 50 new customers checked, 41 are in Capsule CRM, 7 are missing and 2 cannot be checked. - Missing: Priya Rao, priya@contoso.com, Contoso, 2 orders, latest 310.00 - Missing: Tom Alvarez, tom@fabrikam.com, Fabrikam, 1 order, latest 89.00 - Cannot check: 2 customers with no email - The limit of 50 was reached, so there may be more Want the full table of the 7 missing customers?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
capsule-crm-get-party
bigcommerce-get-order

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

New store customers go without a CRM follow-up

New BigCommerce customers never reach Capsule CRM, so nobody follows them up. Finding them means exporting the store customer list and checking Capsule CRM contacts one by one by email.

Without PopdockAI

  • Export new customers from BigCommerce
  • Search Capsule CRM for each email
  • Look up orders for the ones you find missing
  • Give up before the list is done

With PopdockAI

  • New customers since your date are listed, up to your limit
  • Each email is checked in Capsule CRM, ignoring case
  • Missing customers come with order count and latest total
  • No-email customers are kept apart, 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.

Prompt
**Objective:** List the BigCommerce customers created on or after `{since-date}` (default: 30 days ago) that have no Capsule CRM contact with the same email, checking at most `{max-customers}` customers (default 50).

**Step 1: List the new customers**

Call `bigcommerce-get-customer` with `date-created.from` = `{since-date}` and `max-records` = `{max-customers}`. Keep `id`, `name`, `email`, `company`, `date-created`. If none come back, say so and stop.

**Step 2: Look each one up in Capsule CRM**

For each customer that has an `email`, call `capsule-crm-get-party` with `email` = that email. Record found (with `party-id` and `owner-name`) or missing. Customers with no email go in a separate "cannot check" list.

**Step 3: Report**

Give counts (checked, found, missing, cannot check), then a table of the missing customers: BigCommerce id, name, email, company, date-created. For each missing customer, call `bigcommerce-get-order` with `customer-id` = the id and `max-records` = 5 and add the order count and latest `total-including-tax`. Finish by pointing to the add-bigcommerce-customer-to-capsule-crm prompt for any customer the user wants to add.

**Rules & Guidelines:**

* Tools whose names start with bigcommerce-  are on the bigcommerce server; tools whose names start with capsule-crm-  are on the capsule-crm server. Both must be connected.
* Read-only: do not call any add, update or delete tool on either server (for example `bigcommerce-customer-update` or `capsule-crm-add-note`).
* Customers are matched across the two systems by email address, compared case-insensitively.

**Validation:**

* If `{since-date}` is empty use 30 days ago; if `{max-customers}` is empty use 50.
* If the BigCommerce call returns the full `max-records` rows, say there may be more and suggest a narrower date range.
* A contact found by email but under a different name is still a match; mention it only if the names clearly differ.

Who it's for

One answer, three teams that use it

Sales reps

Follow up on new buyers

Missing customers with their orders show who to contact first.

Which BigCommerce customers from the last 14 days have no Capsule CRM contact?

Sales managers

Make sure no customer is ignored

Counts of found and missing show whether new store buyers are reaching the team.

How many new BigCommerce customers this month are missing from Capsule CRM?

Business owners

See which new customers spent the most

Order count and latest total help you decide who deserves a personal hello.

List new BigCommerce customers since September 1 not in Capsule CRM, with what they have spent.

How it works

What PopdockAI does when you ask

You give a start date and a limit, and your AI assistant checks each new BigCommerce customer in Capsule CRM. It points you to the separate add contact job for any you want to add.

01

Ask

You give a start date and a maximum number of customers.

Your AI tool

02

Read

It lists the new BigCommerce customers created since that date.

bigcommerce-get-customer

03

Check

It looks up each email in Capsule CRM and sets aside customers with no email.

capsule-crm-get-party

04

Report

It shows counts and a table of missing customers with order count and latest total.

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

capsule-crm-get-party

Returns people and organizations from Capsule CRM with email, phone, job title, organization, location, owner and last contacted date. Filter by name, email, type, organization, owner, city, state or country.
get-data

bigcommerce-get-order

Returns orders from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
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

Every new buyer accounted for in Capsule CRM

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