Connectors

/

BigCommerce

/

Profile a customer across BigCommerce and PowerGP Online
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Profile a customer across BigCommerce and PowerGP Online
Profile Northwind Traders for me: their BigCommerce orders over the last 90 days and where they stand in GP company TWO.
Northwind Traders has 6 orders in 90 days and 4,820.00 overdue in GP. - Store: 6 orders, 7,310.00 total, 1 refund of 240.00 - GP: balance due 5,960.00, 2 invoices past due - Oldest open item: INV-1042, 38 days past due - Identity: matched by name only, not a confirmed identity Want the list of open items?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
bigcommerce-get-order
powergp-online-get-customers
powergp-online-get-receivablestransactions

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

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.

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

Your AI tool

02

Find

It finds the BigCommerce customer and stops if several match.

bigcommerce-get-customer
bigcommerce-get-order

03

Match

It finds the PowerGP Online customer by name and stops if the match is ambiguous.

powergp-online-get-customers
powergp-online-get-receivablestransactions

04

Report

You get identity, orders, refunds, balance and overdue items in one profile.

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

powergp-online-get-customers

Returns customers from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

powergp-online-get-receivablestransactions

Returns receivables transactions from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields 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 account standing answered in one pass

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