/
/
Know a web customer's Dynamics GP standing before you ship
For order and credit teams who want a WooCommerce customer's holds, balance and overdue documents in Dynamics GP by asking their AI assistant.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
The problem
Large orders waiting while you hunt for the GP account
Before approving a large web order you need the customer's Dynamics GP standing, but GP cannot search by email. You guess at the company name, check the email on each candidate, then look at holds, credit and overdue invoices while the order waits.
Without PopdockAI
- Guess the company name in GP
- Check the email on each candidate
- Look up holds, credit limit and overdue documents
- Keep the order waiting
With PopdockAI
- The store record or recent orders are read, including guest checkouts
- Only a GP candidate whose email matches is accepted
- Holds, credit, overdue documents and spend are shown
- One line names anything needing action, 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:** Find the Dynamics GP customer for the WooCommerce customer with email {customer-email}, using GP customer {gp-customer-id} when it is given, and report their GP standing next to their store activity.
**Step 1: Read the store customer (woocommerce)**
Call `woocommerce-get-customer` with email set to {customer-email}. If nothing comes back, call `woocommerce-get-order` with customer-email set to {customer-email} and take the names from the most recent order, since guest checkouts have no customer record. Then call `woocommerce-get-order` with customer-email set to {customer-email} and max-records 10 for recent orders.
**Step 2: Find the GP customer (dynamics-gp)**
If {gp-customer-id} is given, call `dynamics-gp-get-rm-customer` with customer-id set to it. Otherwise GP cannot filter on email, so call `dynamics-gp-get-rm-customer` with customer-name.contains set to the store billing-company, and if that finds nothing, the store last-name. Keep only candidates whose main-email-address equals {customer-email}, ignoring case.
**Step 3: Read the GP account (dynamics-gp)**
Call `dynamics-gp-get-rm-customer-address` with customer-id. Call `dynamics-gp-get-rm-trx` with customer-id and keep the documents with a current-transaction-amount above zero; any with a due-date before today are overdue.
**Step 4: Report**
1. Match: GP customer id and name, and how it was matched (given id, or name plus email).
2. GP standing: hold, inactive, customer-balance against credit-limit-amount, overdue documents with amounts and due dates.
3. Address differences: store billing city, state, postal code, country and phone against each GP address. Compare phone numbers by digits only.
4. Store activity: number of recent orders, their total, and the last order date.
5. One sentence calling out anything that needs action, such as on hold in GP but still ordering in the store.
**Rules & Guidelines:**
* Tools whose names start with woocommerce- are on the woocommerce MCP server; tools whose names start with dynamics-gp- are on the dynamics-gp MCP server. If a tool from either server is not available, stop and say which server is not connected.
* If the user names a Dynamics GP company, pass it as company on every dynamics-gp call.
* Match a store SKU to a GP item number exactly, after trimming spaces. If that fails, try the SKU in upper case once. Never match on descriptions or partial codes.
* This prompt is read-only. Do not call `woocommerce-update-customer`, `dynamics-gp-rm-customer-update`, `dynamics-gp-rm-customer-address-update`, `dynamics-gp-rm-customer-add` or `dynamics-gp-rm-customer-note`.
**Validation:**
* If the store has neither a customer nor an order for {customer-email}, say so and stop.
* If GP candidates were found but none has a matching email, list them with their email addresses, ask the user for the GP customer id, and stop.
* If more than one GP customer has a matching email, list them and ask which to use.
* If no GP candidate was found, report the customer as present in WooCommerce and absent from GP.Who it's for
One answer, three teams that use it
Credit controllers
Approve large orders with facts
See hold flags, balance against credit limit and overdue documents before you release an order.
How does sam@fabrikam.com look in Dynamics GP before I approve their order?
Order desk staff
Find the right GP account by email
Only a candidate with a matching email is accepted, so you never check the wrong account.
Find the Dynamics GP customer for WooCommerce buyer accounts@contoso.com.
Customer service agents
Spot address and phone differences
Differences between store and GP contact details are listed for correction.
Compare orders@northwindtraders.com in WooCommerce with their GP record and flag differences.
How it works
What PopdockAI does when you ask
You give the customer's email or GP ID, and your AI assistant finds the right GP account and its standing. It asks when unsure and changes nothing.
01
Ask
You give the customer's email, or their GP customer ID.
02
Read
It reads their store record or recent orders, including guest checkouts.
03
Find
It accepts only a GP candidate whose email matches, asking when unsure.
04
Report
You get GP standing beside store activity, read-only.
What PopdockAI provides
The tools behind the answer
Ready made tools for WooCommerce and one secure connection to your AI tool. No code, no exports.
woocommerce-get-customer
woocommerce-get-order
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-customer-address
microsoft-dynamics-gp-get-rm-trx
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
Know a customer's GP standing before you ship
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)
