/
/
Find large BigCommerce orders that have no Attio deal
For sales teams who ask their AI assistant which big BigCommerce orders came from buyers with no deal in Attio.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Large store orders come from accounts sales is not working
Large BigCommerce orders can come from accounts that sales has no Attio deal for. Spotting them means working out each buyer, including guest checkouts, then searching Attio person by person and company by company.
Without PopdockAI
- Filter BigCommerce orders by total
- Work out who each guest buyer is
- Search Attio for each person and company
- Check every company for a deal
With PopdockAI
- Large orders are listed, without cancelled and refunded ones
- Buyers are identified, using billing details for guests
- Attio people, companies and deals are checked by email
- Company-only matches are labelled, 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.
**Objective:** Find orders of at least `{min-order-total}` placed since `{since-date}` in BigCommerce where the buyer has no matching deal in Attio, so sales can follow up.
Servers: `bigcommerce-*` tools are on the bigcommerce server, `attio-*` tools are on the attio server. Both must be connected.
**Step 1: List large orders (bigcommerce)**
Call `bigcommerce-get-order` with `total-including-tax.min` = `{min-order-total}` and `date-created.from` = `{since-date}`. Keep `id`, `customer-id`, `total-including-tax`, `date-created`, `status`, `billing-email`. Drop cancelled or refunded orders where `status` says so.
**Step 2: Identify the buyer (bigcommerce)**
For each distinct `customer-id`, call `bigcommerce-get-customer` with `id` to get `email`, `name` and `company`. A customer id of 0 is a guest checkout: use `billing-email` and `billing-last-name` instead.
**Step 3: Look for them in Attio (attio)**
Call `attio-get-record-people` with `email-addresses` = the email. If found, take the `company` and call `attio-get-record-deals` with `associated-company` = that company. If the person is not found and a store company is set, call `attio-get-record-companies` with `name` = the store company, then the deals call.
**Step 4: Report**
Table of orders with no deal: order id, date, total, buyer, company, and whether the buyer exists in Attio at all. Second table of orders that do have a deal, with deal name and stage. Sort the first table by total, highest first.
**Rules & Guidelines:**
* Read-only. Do not call any add, update, upsert or delete tool on either server.
* Match people on email, companies on exact name. Say when a match was by company name only.
**Validation:**
* If no orders meet the threshold, say so and stop.
* If the buyer cannot be identified at all, list the order as unattributed.Who it's for
One answer, three teams that use it
Account executives
Find buyers worth a conversation
Orders with no deal, sorted by total, show which customers deserve a personal follow-up.
Which BigCommerce orders over 3,000 since August 1 have no deal in Attio?
Sales managers
Spot accounts nobody owns
Large buyers missing from Attio entirely are called out, so you can assign them.
Show large BigCommerce orders this quarter from buyers who are not in Attio at all.
Revenue operations
Check deal coverage on big orders
A second table of orders that do have a deal shows how well the CRM reflects store revenue.
Of BigCommerce orders over 10,000 since July 1, how many have an Attio deal?
How it works
What PopdockAI does when you ask
You set a minimum order total and a start date, and your AI assistant checks each large BigCommerce buyer in Attio. Buyers it cannot identify are listed as unattributed.
01
Ask
You give a minimum order total and a start date.
02
Orders
It lists matching BigCommerce orders, skips cancelled and refunded ones, and identifies each buyer.
03
Match
It looks for the person in Attio by email, then their company and deals.
04
Report
You get orders with no deal sorted by total, then orders that do have a deal.
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.
bigcommerce-get-order
bigcommerce-get-customer
attio-get-record-people
attio-get-record-deals
attio-get-record-companies
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
Big orders with no deal, ready for follow-up
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)
