Connectors

/

BigCommerce

/

Find big BigCommerce orders with no Attio deal
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find big BigCommerce orders with no Attio deal
Show BigCommerce orders over 5,000 since September 1 where the buyer has no deal in Attio.
4 of 9 orders over 5,000 since September 1 have no deal in Attio. - Order 10482, Oct 3, 12,400, Contoso Ltd, buyer not in Attio - Order 10517, Oct 11, 7,850, Northwind Traders, person in Attio but no deal - Order 10533, Oct 15, 5,300, guest checkout, matched by company name only - Other: 1 more order with no deal Want to lower the minimum total?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order
bigcommerce-get-customer
attio-get-record-people
attio-get-record-deals
attio-get-record-companies

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

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.

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

Your AI tool

02

Orders

It lists matching BigCommerce orders, skips cancelled and refunded ones, and identifies each buyer.

bigcommerce-get-order
bigcommerce-get-customer

03

Match

It looks for the person in Attio by email, then their company and deals.

attio-get-record-people
attio-get-record-companies
attio-get-record-deals

04

Report

You get orders with no deal sorted by total, then orders that do have a deal.

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

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

attio-get-record-people

Returns people from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-deals

Returns deals from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-companies

Returns companies from Attio CRM. Read-only; filter by the fields the tool offers.
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

Big orders with no deal, ready for follow-up

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