/
/
See a customer's orders and GP balance together
For support and account teams who want a BigCommerce customer's orders and PowerGP Online balance in one answer from their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Orders in the store, the overdue balance in GP
When a customer calls, their orders are in BigCommerce and their balance and overdue invoices are in PowerGP Online. With no shared id the wrong customer is easy to pick, and a high overdue balance goes unnoticed while they keep ordering.
Without PopdockAI
- Look up orders and refunds in BigCommerce
- Search GP for the customer by name
- Guess which of several similar customers is right
- Miss the overdue balance
With PopdockAI
- The BigCommerce customer is found, stopping if several match
- Recent orders, totals and refunds are read
- The GP customer is matched by name, with balance and days past due
- The match is labelled unconfirmed, 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:** For the customer named or emailed as `{customer}`, combine store order history with GP account standing for company `{company}`, looking back `{lookback-days}` days (default 90).
**Step 1: Find the store customer (bigcommerce server)**
If `{customer}` contains `@`, call `bigcommerce-get-customer` with `email`. Otherwise call it with `name.contains`. If more than one customer matches, list them (id, name, email, company) and stop.
**Step 2: Store orders (bigcommerce server)**
Call `bigcommerce-get-order` with `customer-id` from Step 1 and `date-created.from` set to the start of the window. Keep `id`, `date-created`, `status`, `total-including-tax`, `refunded-amount`.
**Step 3: Find the GP customer (powergp-online-ai server)**
GP has no email field, so match on name. Call `powergp-online-get-customers` with `company` set to `{company}` and `customer-name.contains` set to the store customer `company` value, or the full name if there is no company. If more than one matches, list them and stop. If none matches, report the customer as store-only and skip Step 4.
**Step 4: GP standing**
Using the GP `customer-number`, call `powergp-online-get-customers` for `balance-due`, and `powergp-online-get-receivablestransactions` for open items (`document-number`, `due-date`, `days-past-due`, `unapplied-amount`).
**Step 5: Report**
Sections: identity (both systems), store orders (count, total, refunds), GP balance and overdue items, and one line noting any concern such as a high overdue balance while still ordering online.
**Rules & Guidelines:**
* `powergp-online-*` tools belong to the powergp-online-ai server (Dynamics GP). `bigcommerce-*` tools belong to the bigcommerce server (online store). Both servers and this prompt server must be connected.
* This prompt is read-only. Call only `get` tools. Never call any `bigcommerce-*-add`, `bigcommerce-*-update` or `bigcommerce-*-delete` tool.
* Query only the GP company given in `{company}`; never mix companies.
* Show at most 25 rows per table and say how many more there are.
**Validation:**
* State the name-based match as a match by name, not a confirmed identity.
* If the store has no orders in the window, say so and still report GP standing.Who it's for
One answer, three teams that use it
Support agents
Answer account questions on the call
Orders, refunds and the GP balance are in one profile while the customer is on the line.
Profile Contoso from BigCommerce and GP company TWO, with the last 60 days of orders.
Credit controllers
See overdue customers still ordering
Days past due beside recent orders shows when to hold new orders.
Is Fabrikam overdue in GP company TWO while still ordering on BigCommerce?
Account managers
Know the account before you visit
Identity, history and standing together let you plan the conversation.
Give me a profile of jo@northwindtraders.com across BigCommerce and GP company TWO.
How it works
What PopdockAI does when you ask
You give a customer name or email and the GP company, and your AI assistant builds one profile from both systems. It stops rather than guess between look-alikes.
01
Ask
You give a customer name or email and the GP company.
02
Find
It finds the BigCommerce customer and stops if several match.
03
Match
It finds the PowerGP Online customer by name and stops if the match is ambiguous.
04
Report
You get identity, orders, refunds, balance and overdue items in one profile.
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
powergp-online-get-customers
powergp-online-get-receivablestransactions
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
Orders and account standing answered in one pass
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)
