/
/
See a customer's orders and billing in one view
For support teams who want a customer's BigCommerce orders and FreshBooks balance together, just by giving their email to their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Quoting a balance means lining up the store and the books
When a customer asks what they ordered, were billed and still owe, an agent looks in BigCommerce, then FreshBooks, and lines them up by hand. Names and ids differ, so it is easy to quote the wrong balance or miss a paid order with an unpaid invoice.
Without PopdockAI
- Find the customer and orders in BigCommerce
- Search FreshBooks for the matching client
- Read invoices and payments on another screen
- Quote a balance that may belong to the wrong client
With PopdockAI
- The customer is found in both systems by email
- It stops and lists matches when the email is unclear
- Orders sit beside invoices, payments and the outstanding balance
- Name differences are shown, 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:** Build one view of the customer with email `{email}` across BigCommerce and FreshBooks: what they ordered, what was invoiced, what was paid and what is still owed.
**Step 1: Find the BigCommerce customer**
Call `bigcommerce-get-customer` (bigcommerce server) with `email` set to `{email}`. If nothing matches, try `email.contains`. If more than one customer matches, list them and stop.
**Step 2: Read their orders**
Call `bigcommerce-get-order` (bigcommerce server) with `customer-id` set to the customer `id`, `max-records` 50. Keep `id`, `date-created`, `status`, `payment-status`, `total-including-tax`, `refunded-amount`. If the customer has no orders, also try `billing-email` set to `{email}`.
**Step 3: Find the FreshBooks client**
Call `freshbooks-get-client` (freshbooks server) with `email` set to `{email}`. If there is no client, report the BigCommerce side only and say the customer is not in FreshBooks.
**Step 4: Read invoices and payments**
Call `freshbooks-get-invoice` with `customer-id` set to the client `id`, then `freshbooks-get-payment` with `client-id` set to the client `id`. Total the invoice `amount`, the `outstanding` and the payment `amount`.
**Step 5: Report**
Three sections: customer identity on both systems (ids, names, company), orders with dates and totals, invoices and payments with the outstanding balance. Finish with one sentence on anything that does not line up, such as paid orders with unpaid invoices.
**Rules & Guidelines:**
* `bigcommerce-get-customer` and `bigcommerce-get-order` are on the bigcommerce server. `freshbooks-get-client`, `freshbooks-get-invoice` and `freshbooks-get-payment` are on the freshbooks server.
* Read-only. Never call any add, update, delete, send or mark tool on either server.
**Validation:**
* If the email matches on neither system, say so and stop.
* If the two systems hold different names for the same email, show both and do not choose.Who it's for
One answer, three teams that use it
Support agents
Answer what do I owe in one reply
Orders, invoices and the outstanding balance are together, so the answer is right the first time.
What has jo@contoso.com ordered on BigCommerce and what is still unpaid in FreshBooks?
Bookkeepers
Spot paid orders with open invoices
Anything that does not line up between the store and the books is called out for a fix.
Do lee@fabrikam.com BigCommerce orders and FreshBooks invoices line up? Show anything that does not.
Small business owners
See a customer's full account fast
One question gives you what they bought, what you billed and what they paid.
Show me everything for dana@northwindtraders.com across BigCommerce and FreshBooks.
How it works
What PopdockAI does when you ask
You give a customer email and your AI assistant builds one view from BigCommerce and FreshBooks. It never guesses a match and changes nothing.
01
Ask
You give the customer email.
02
Find
It looks the customer up in BigCommerce and FreshBooks and stops if the match is unclear.
03
Read
It pulls their orders, invoices and payments.
04
Report
You get identity, orders and billing with the outstanding balance, plus anything that does not line up.
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-customer
bigcommerce-get-order
freshbooks-get-client
freshbooks-get-invoice
freshbooks-get-payment
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
Order and billing questions answered from one view
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)
