Connectors

/

BigCommerce

/

Review large BigCommerce orders against Salesforce
Report
Cross-Connector

Find large BigCommerce orders from buyers not in Salesforce

For sales teams who want big web orders checked against Salesforce contacts and open opportunities, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review large BigCommerce orders against Salesforce
Which BigCommerce orders over 1,500 in the last 14 days are from buyers who are not in Salesforce yet?
Found 5 orders of 1,500 or more in the last 14 days, all in USD. - Order 10490: Contoso Ltd, 2,300.00, paid, no Salesforce contact - Order 10486: Fabrikam Supply, 1,820.00, paid, contact without open opportunity - Order 10479: Northwind Traders, 3,100.00, open opportunity Renewal, Negotiation stage - Order 10475: no billing email, unmatchable Want the follow-up list for the unmatched buyers?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order
salesforce-get-contact
salesforce-get-opportunity

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

Big web orders arrive and sales does not know the buyer

Big BigCommerce orders arrive and nobody in sales knows whether the buyer is already in the pipeline. Finding out means pulling the order list, then searching Salesforce for each buyer's contact and open opportunities.

Without PopdockAI

  • Filter BigCommerce orders by total
  • Search Salesforce for each buyer
  • Check their open opportunities
  • Build a follow-up list by hand

With PopdockAI

  • Large orders in the window are listed
  • Each buyer's email is checked for a Salesforce contact and open opportunity
  • Orders with no contact become a follow-up list
  • Unmatchable orders are listed, currencies kept apart, nothing 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:** Review BigCommerce orders of at least `{min-order-total}` placed in the last `{lookback-days}` days (default 14) and check Salesforce for each buyer.

**Step 1: Large orders in BigCommerce**

Call `bigcommerce-get-order` (BigCommerce server) with `total-including-tax.min` set to the minimum and `date-created.from` set to the start of the window. Keep `id`, `customer-id`, `billing-email`, `total-including-tax`, `currency-code`, `status` and `payment-status`.

**Step 2: Buyer in Salesforce**

For each distinct `billing-email`, call `salesforce-get-contact` (Salesforce server) with that `email`. If a contact is found, call `salesforce-get-opportunity` with its `account-id` and `closed` set to false.

**Step 3: Report**

Table per order: order id, buyer email, total with currency, payment status, Salesforce result (no contact, contact without open opportunity, or the open opportunity name and stage). Finish with the orders that have no Salesforce contact, as follow-ups for sales.

**Rules & Guidelines:**

* `bigcommerce-get-order` is on the BigCommerce server; `salesforce-get-contact` and `salesforce-get-opportunity` are on the Salesforce server.
* Read-only. Do not call `salesforce-add-opportunity`, `salesforce-update-opportunity` or any BigCommerce write tool.
* Do not compare totals across currencies.

**Validation:**

* If no order meets the minimum, say so and stop.
* If an order has no `billing-email`, list it as unmatchable.

Who it's for

One answer, three teams that use it

Account executives

Reach big buyers first

Large orders from buyers with no contact are new accounts to work.

Which BigCommerce orders over 2,500 in the last 7 days are from buyers not in Salesforce?

Sales managers

See which big buyers already have deals

Open opportunities beside each large order show who is already being worked.

Show BigCommerce orders over 5,000 this month and any open Salesforce opportunity for the buyer.

Sales development reps

Build an outreach list from orders

The follow-up list of unmatched buyers is a ready-made call list.

Give me a follow-up list of large BigCommerce buyers from the last 30 days with no Salesforce contact.

How it works

What PopdockAI does when you ask

You set a minimum order total and your AI assistant checks each large BigCommerce buyer in Salesforce. It only reads both systems.

01

Ask

You give a minimum order total and optionally a lookback period.

Your AI tool

02

Find

It lists large BigCommerce orders in the window.

bigcommerce-get-order

03

Match

It looks up each buyer in Salesforce and any open opportunity.

salesforce-get-contact
salesforce-get-opportunity

04

Report

You get a table per order and a follow-up list of unmatched buyers.

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-order

Returns orders 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-opportunity

Returns Salesforce opportunities with their account, stage, amount, probability, close date, next step, owner and whether they are closed or won. Filter by name, account, stage, owner, amount, close date and closed and won flags.
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

A follow-up list of big buyers not yet in Salesforce

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