/
/
Show the BigCommerce orders behind a Salesforce case
For support agents who want a case's customer matched to their store orders, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
The case is in one system and the orders are in another
An agent handling a Salesforce case copies the customer email into BigCommerce to find the order being discussed. The case and orders live in different systems, and picking the wrong order wastes time on the call.
Without PopdockAI
- Read the case and copy the contact email
- Search BigCommerce for the customer
- Scroll through orders to guess the right one
- Open items to confirm
With PopdockAI
- The case subject, status, priority and contact email are read
- The BigCommerce customer and orders are found, stopping if unclear
- Items are read for the order that looks related
- It says which order seems relevant and why, and changes nothing
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Show the BigCommerce orders that give context to Salesforce case `{case-number}`, looking back `{lookback-days}` days (default 180).
**Step 1: The case in Salesforce**
Call `salesforce-get-case` (Salesforce server) with `case-number` set to `{case-number}`. If nothing comes back, report that and stop. Keep `subject`, `status`, `priority` and the contact details. Call `salesforce-get-contact` with the case's contact email or `account-id` to get the contact `email`.
**Step 2: Orders in BigCommerce**
Call `bigcommerce-get-customer` (BigCommerce server) with `email` set to the contact email. If none matches, report the contact as not a store customer and stop. Otherwise call `bigcommerce-get-order` with `customer-id` and `date-created.from`, and for any order that looks related to the subject call `bigcommerce-get-order-product` with `order-id`.
**Step 3: Report**
Case summary, then a table of orders (id, date, status, payment status, total, refunded amount) and the items on the most likely related order. Say which order seems relevant and why, or that none obviously is.
**Rules & Guidelines:**
* `salesforce-get-case` and `salesforce-get-contact` are on the Salesforce server; `bigcommerce-get-customer`, `bigcommerce-get-order` and `bigcommerce-get-order-product` are on the BigCommerce server.
* Read-only. Do not call `salesforce-update-case`, `salesforce-add-case` or any BigCommerce write tool.
**Validation:**
* If the case has no contact, say the orders cannot be linked and stop.
* If the contact matches more than one BigCommerce customer, list them and stop.Who it's for
One answer, three teams that use it
Support agents
Find the order the customer means
The likely related order and its items are shown next to the case subject.
Which BigCommerce order is Salesforce case 00045821 about?
Support team leads
Review cases with order context
Order dates, payment status and refunds help you judge an escalation quickly.
Show BigCommerce orders from the last 90 days for the contact on case 00039917.
Returns coordinators
Check what was refunded
Refunded amounts on each order help you handle return and refund cases.
For Salesforce case 00041102, list the customer's BigCommerce orders and any refunds.
How it works
What PopdockAI does when you ask
You give a case number and your AI assistant finds the BigCommerce orders behind it. It stops when the case has no contact or the match is ambiguous.
01
Ask
You give the Salesforce case number and optionally a lookback period.
02
Read
It reads the case and the contact's email.
03
Find
It finds the BigCommerce customer and their orders, stopping if the match is unclear.
04
Report
You get the case summary, an orders table and the items on the likely order.
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.
salesforce-get-case
salesforce-get-contact
bigcommerce-get-customer
bigcommerce-get-order
bigcommerce-get-order-product
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
The customer's orders beside the case, likely one flagged
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)
