Connectors

/

BigCommerce

/

Show BigCommerce order history for a Salesforce case
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Show BigCommerce order history for a Salesforce case
Show me the BigCommerce orders for Salesforce case 00012345 so I can see what the customer is asking about.
Case 00012345, Damaged item on delivery, status open, priority high. Dana Whitfield has 3 orders in the last 180 days. - Order 10471: 4 September, shipped, paid, 312.00 - Order 10488: 2 October, delivered, paid, 96.50, refunded 0.00 - Order 10492: 9 October, awaiting fulfillment, paid, 148.00 - Likely related: order 10488, delivered shortly before the case opened Want the items on order 10488?
BigCommerce
Sample figures. Your results come from your own account.
salesforce-get-case
salesforce-get-contact
bigcommerce-get-customer
bigcommerce-get-order
bigcommerce-get-order-product

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

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.

Prompt
**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.

Your AI tool

02

Read

It reads the case and the contact's email.

salesforce-get-case
salesforce-get-contact

03

Find

It finds the BigCommerce customer and their orders, stopping if the match is unclear.

bigcommerce-get-customer
bigcommerce-get-order

04

Report

You get the case summary, an orders table and the items on the likely order.

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

salesforce-get-case

Returns Salesforce support cases with their subject, status, priority, origin, owner, account, contact and whether they are escalated or closed. Filter by case number, subject, status, priority, owner, account, contact email, closed flag and created date.
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

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

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

bigcommerce-get-order-product

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

The customer's orders beside the case, likely one flagged

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