Connectors

/

WooCommerce

/

Review a WooCommerce customer in Dynamics GP
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Review a WooCommerce customer in Dynamics GP
Before I approve this large order, how does dana@northwindtraders.com look in Dynamics GP?
Northwind Traders is not on hold in Dynamics GP but has an overdue document. - Credit: balance 14,200.00 against a 20,000.00 limit - Overdue: INV-1042, 3,400.00, 28 days late - Store: 9 orders worth 6,120.00 in the last year - Difference: phone number differs between the two systems Action: clear the overdue invoice before shipping.
WooCommerce
Sample figures. Your results come from your own account.
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

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

WooCommerce

WooCommerce
Run it on your own WooCommerce data.

Connect WooCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It reads their store record or recent orders, including guest checkouts.

woocommerce-get-customer
woocommerce-get-order

03

Find

It accepts only a GP candidate whose email matches, asking when unsure.

microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-customer-address

04

Report

You get GP standing beside store activity, read-only.

Your AI tool

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.

get-data

woocommerce-get-customer

Returns WooCommerce customer accounts with name, billing address, role and whether they have paid for an order. Filter by email, id, last name, billing country or state, role and created date range.
get-data

woocommerce-get-order

Returns WooCommerce orders with status, totals, discounts, shipping, payment method and paid date. Filter by status, customer email or id, order number, created date range, total range or billing last name.
get-data

microsoft-dynamics-gp-get-rm-customer

Returns customer records from Dynamics GP Receivables Management, including contact details, class, terms and balances. Filter by salesperson ID, hold, customer name, state, zip, customer balance, customer class and city, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-customer-address

Returns customer address records from Dynamics GP Receivables Management, including contact, address, phone and the salesperson and territory for each address. Filter by salesperson ID, state, customer ID, country, zip, city, address code and customer name, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-trx

Returns receivables transactions such as invoices, payments and credit memos from Dynamics GP Receivables Management, including customer, dates, amounts and outstanding balances. Filter by customer ID, document type, customer name, document date, document amount, document number, batch number and void status, and pick the company and the maximum number of records.
Read only.Nothing in WooCommerce 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

Know a customer's GP standing before you ship

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