Connectors

/

BigCommerce

/

Show BigCommerce orders and Wave balance for a customer
Report
Cross-Connector

See a customer's shop orders and Wave balance together

For sales teams who want a customer's BigCommerce orders and Wave balance in one answer from their AI assistant.

Try PopdockAI free
Get a live demo
Show BigCommerce orders and Wave balance for a customer
Show me what dana@northwindtraders.example has ordered in BigCommerce this year and what she owes in Wave.
Northwind Traders has bought steadily and has one unpaid invoice in Wave. - BigCommerce: 14 orders, 8,420.00 USD including tax, refunded 120.00 - Last orders: #5012, #4987, #4950 - Wave: outstanding 640.00, overdue 0.00 - Unpaid: INV-1042, due 2026-11-20, 640.00 Want the full list of the 14 orders?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
bigcommerce-get-order
wave-get-customer
wave-get-invoice

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

Spend and debt live in different systems

To answer how much a customer buys and owes you search the shop, then the accounting system, then add it up. Mixed currencies and mismatched records make the numbers easy to get wrong.

Without PopdockAI

  • Search BigCommerce for the customer and their orders
  • Look the customer up again in Wave
  • Read invoices and balances in a second screen
  • Add the totals by hand across currencies

With PopdockAI

  • The customer is matched by email in both systems
  • Orders are totalled per currency, never mixed
  • Outstanding, overdue and unpaid invoices come back together
  • Phone and address are left out and nothing is written

The prompt

Use this prompt

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

Prompt
**Objective:** For the customer with email `{email}`, show what they have ordered in BigCommerce in the last `{lookback-days}` days (default 365) and what they owe in Wave (company `{company}`, optional).

**Step 1: Find the BigCommerce customer and orders**

Call `bigcommerce-get-customer` (BigCommerce server) with `email` set to `{email}`. If none or more than one matches, report that and stop. Then call `bigcommerce-get-order` with `customer-id` set to that customer's id, `date-created.from` set to the start of the lookback window and `max-records` 200.

**Step 2: Find the Wave customer and invoices**

Call `wave-get-customer` (Wave server) with `email` set to `{email}` (and `company` if not empty). Note outstanding-amount, overdue-amount and currency-code. Then call `wave-get-invoice` with `customer-name` set to the Wave customer's name, `invoice-date.from` set to the same start date and `company` if not empty.

**Step 3: Report**

Report BigCommerce: order count, total-including-tax by currency, refunded-amount, and the last three orders. Report Wave: outstanding and overdue amounts, invoice count and the unpaid invoices (invoice-number, due-date, amount-due). If a customer exists on one side only, say so plainly.

**Rules & Guidelines:**

* `bigcommerce-get-customer` and `bigcommerce-get-order` are on the BigCommerce server; `wave-get-customer` and `wave-get-invoice` are on the Wave server.
* Do not call any write tool on either server: no `wave-add-*`, `wave-update-*`, `wave-delete-*`, `wave-send-*`, `wave-mark-*`, `wave-approve-*`, `wave-archive-*` or `wave-clone-*` tools, and no `bigcommerce-*-add`, `bigcommerce-*-update` or `bigcommerce-*-delete` tools.
* Report only what the question needs; do not print phone numbers or addresses.

**Validation:**

* Never add amounts in different currencies.
* If the Wave customer name matches more than one customer, ask which one and stop.

Who it's for

One answer, three teams that use it

Sales reps

Know a customer's value and debt before you call

See how much a customer has ordered and whether they have unpaid invoices before you pitch or negotiate.

What has priya@contoso.example ordered from our BigCommerce store in the last 12 months, and does she owe us anything in Wave?

Account managers

Review a key account in one reply

Pull the last three orders and the open invoices for an account without switching between the shop and the books.

Show Fabrikam's recent BigCommerce orders and their Wave overdue amount, company Fabrikam Holdings.

Store owners

Check a repeat buyer before extending terms

Confirm that a frequent buyer is up to date in Wave before you offer credit or a discount.

Has tom@adventure-works.example ordered much in the last 6 months, and are any of his Wave invoices unpaid?

How it works

What PopdockAI does when you ask

You give a customer email and your AI assistant reads BigCommerce, then Wave. It stops if the customer is unclear and never changes any record.

Ask

You give a customer email and how far back to look.

Your AI tool

Find

It finds the customer in BigCommerce and reads their orders, stopping on none or several matches.

bigcommerce-get-customer
bigcommerce-get-order
wave-get-customer
wave-get-invoice

Match

It finds the same email in Wave and reads the balance and invoices.

No items found.

Report

It reports order totals by currency, recent orders and unpaid invoices.

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

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
get-data

wave-get-invoice

Returns invoices from Wave. Wave connector tool; filter by the parameters it 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

Orders and balance in a single view

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation