Connectors

/

BigCommerce

/

BigCommerce and Attio customer 360 by email
Report
Cross-Connector

See a customer's orders and CRM record in one view

For sales reps who ask their AI assistant for one email's BigCommerce order history next to the Attio person, company and deals.

Try PopdockAI free
Get a live demo
BigCommerce and Attio customer 360 by email
Pull everything on dana@northwindtraders.com from BigCommerce and Attio before my call at 2pm.
Dana Whitfield is a BigCommerce customer with 6 orders worth 3,420 and an Attio person at Northwind Traders with one open deal. - Store: latest order Oct 14, 5 completed and 1 pending - Attio person: Head of Operations, last interaction Oct 9 - Deal: Renewal 2026, stage Negotiation, 48,000, owner Sam Patel - Difference: the store lists the company as Northwind, Attio as Northwind Traders Want to try another email or a longer order window?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
bigcommerce-get-order
attio-get-record-people
attio-get-record-companies
attio-get-record-deals

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

Call prep means searching two systems that never line up

Before a call a rep searches BigCommerce for a customer's orders, then Attio for the person, company and deals. Company names differ or one side has no record, and the preparation can take longer than the call.

Without PopdockAI

  • Search BigCommerce for the customer and add up orders
  • Search Attio for the person and their company
  • Open each deal to see where it stands
  • Guess whether the two records are the same customer

With PopdockAI

  • The customer is found in both systems by email, ignoring case
  • Orders are totalled beside the Attio person, company and deals
  • A missing or duplicate match is reported, never guessed
  • It closes by saying whether name and company agree

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Build a single view of the person with email `{email}`, combining their BigCommerce store history with their Attio CRM record. Look back `{lookback-days}` days for orders (default 365).

Servers: `attio-*` tools are on the attio server, `bigcommerce-*` tools are on the bigcommerce server. Both must be connected.

**Step 1: Find the store customer (bigcommerce)**

Call `bigcommerce-get-customer` with `email` = `{email}`. If nothing comes back, say the person is not a store customer and continue to Step 3. If more than one matches, list them (id, name, email) and stop.

**Step 2: Get their orders (bigcommerce)**

Call `bigcommerce-get-order` with `customer-id` = the `id` from Step 1 and `date-created.from` set to today minus the look-back. Total the orders (`total-including-tax`), note the latest `date-created`, and count by `status`.

**Step 3: Find the CRM person (attio)**

Call `attio-get-record-people` with `email-addresses` = `{email}`. If nothing comes back, report the person as in the store but absent from Attio and skip Step 4. If more than one matches, list them and stop.

**Step 4: Get company and deals (attio)**

Take `company` from the person record and call `attio-get-record-companies` with `name` set to it. Then call `attio-get-record-deals` with `associated-company` set to the company name. List each deal with `deal-name`, `deal-stage`, `deal-value` and `deal-owner`.

**Step 5: Report**

Give: store profile (name, company, group, created date); order count, revenue and latest order; CRM person (job title, last interaction, `web-url` if present); company; open and closed deals. End with one line saying whether the CRM and the store agree on name and company, and what differs.

**Rules & Guidelines:**

* Read-only. Do not call any add, update, upsert or delete tool on either server (for example `attio-add-person`, `attio-update-person`, `bigcommerce-customer-update`).
* The join key is the email address. Compare it case-insensitively.

**Validation:**

* If the store company and the Attio company name differ, show both and do not pick one.
* If the person has no orders in the window, say so rather than leaving the section blank.

Who it's for

One answer, three teams that use it

Account executives

Walk into calls knowing what they bought

See order count, revenue and the latest order next to the open deals, so the conversation starts from facts.

Before my call, show me sam@contoso.com orders in BigCommerce and their deals in Attio.

Customer success managers

Check account health across store and CRM

Order activity and deal status side by side tell you whether a customer is growing or going quiet.

How much has Fabrikam bought in BigCommerce this year, and what deals do we have open with them in Attio? Contact is lee@fabrikam.com.

Revenue operations

Find records that disagree between systems

Name and company mismatches are shown plainly, so you know which records need a tidy up.

Compare jo@northwindtraders.com in BigCommerce and Attio and tell me if the name or company differ.

How it works

What PopdockAI does when you ask

You give an email and your AI assistant reads BigCommerce and Attio for that customer. It changes nothing and tells you when the two sides do not agree.

01

Ask

You give an email and, optionally, how many days of orders to include.

Your AI tool

02

Store

It finds the BigCommerce customer and totals their orders by status.

bigcommerce-get-customer
bigcommerce-get-order

03

CRM

It finds the Attio person, then the company and its deals.

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

04

Report

You get both sides together, ending with whether name and company agree.

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

attio-get-record-people

Returns people 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.
get-data

attio-get-record-deals

Returns deals 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

Store history and CRM context in one view before every call

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