Connectors

/

Shopify

/

Review a customer across Shopify and Dynamics 365 Business Central
Report
Cross-Connector

See a customer's Shopify orders and Business Central balance together

For finance and account teams who want one customer's online buying and credit position side by side, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review a customer across Shopify and Dynamics 365 Business Central
Review jordan@contoso.com across Shopify and Business Central for the last 90 days.
Contoso is still ordering online while blocked in Business Central. - Shopify: 14,200 lifetime spend, 3 orders in 90 days - Business Central: 6,480 balance, 5,000 limit, blocked - Over limit: by 1,480 - Not invoiced: order #1042 Want the order to invoice table?
Shopify
Sample figures. Your results come from your own account.
shopify-get-customer
shopify-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

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

Try PopdockAI free

The problem

Blocked customers can keep ordering online unnoticed

A customer's online buying lives in Shopify while their balance, credit limit and blocked status live in Dynamics 365 Business Central. Seeing whether a blocked or overdue customer is still ordering means checking both and matching orders to invoices yourself.

Without PopdockAI

  • Look up the customer in Shopify
  • Find them again in Business Central
  • Check balance, limit and blocked status
  • Match recent orders to invoices by hand

With PopdockAI

  • The customer is found in both systems by exact email
  • Spend, balance, limit and blocked status come back side by side
  • Recent orders are traced to their invoices
  • Risks such as ordering while blocked are flagged, and nothing is edited

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Build one view of the customer with email `{email}` from Shopify and Business Central, covering the last `{lookback-days}` days (default 90), and flag anything that disagrees between the two.

**Step 1: Find the customer on both sides**

Call `shopify-get-customer` with `email` set to `{email}`. Keep `customer-id`, `name`, `orders-count`, `total-spent`, `last-order-name`, `state`, `tags` and `created-at`.

Call `business-central-get-customer` with `email` set to `{email}`. Keep `customer-number`, `name`, `balance`, `balance-due`, `credit-limit`, `outstanding-orders`, `outstanding-invoices`, `blocked`, `payment-terms-code` and `salesperson-code`.

If either side returns more than one customer, list them and stop. If neither side finds the email, say so and stop. If only one side finds it, report that side in full and state that the customer is missing from the other.

**Step 2: Recent activity**

* Call `shopify-get-order` with `customer-id` and `created-at.from` set to `{lookback-days}` days ago, for the recent orders (`name`, `created-at`, `total-price`, `financial-status`, `fulfillment-status`).
* Call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` and `posting-date.from` set to the same date, for invoices (`invoice-number`, `external-document-number`, `posting-date`, `total-amount-including-tax`, `remaining-amount`, `due-date`).

Match Shopify orders to invoices where the invoice's `external-document-number` equals the Shopify order `name` or `order-number`.

**Step 3: Report**

A side-by-side block: name, Shopify customer id, Business Central customer number, Shopify orders count and total spent, Business Central balance, balance due, credit limit, blocked.

Then a table of the recent Shopify orders with the matching Business Central invoice number and remaining amount, or not invoiced.

Flag, one line each:

* the names differ between the systems
* the customer is blocked in Business Central while ordering in Shopify
* balance due is above zero and an invoice is past its due date
* balance is over the credit limit
* Shopify orders in the period with no Business Central invoice

**Rules & Guidelines:**

* `shopify-get-customer` and `shopify-get-order` are on the shopify server. `business-central-get-customer` and `business-central-get-posted-sales-invoice` are on the business-central server.
* This prompt is read-only. Do NOT call `shopify-update-customer`, `business-central-update-customer`, `business-central-create-customer` or any other create, add or update tool on either server.
* If the user names a Business Central company, pass it as `company` on every Business Central call.

**Validation:**

* Match the email exactly. If no match is found, do not retry with a partial or fuzzy match; report it.
* Shopify total spent is lifetime and in the shop currency; Business Central balance is current and in local currency. Present them side by side; do not subtract one from the other.

Who it's for

One answer, three teams that use it

Customer service reps

Answer account questions with both sides

See orders and balance together when a customer calls, without switching systems.

Review sam@fabrikam.com across Shopify and Business Central for the last 60 days.

Credit controllers

Catch blocked customers still ordering

Orders placed while blocked or over the limit are flagged, so you can act before shipping.

Is priya@contoso.com ordering in Shopify while blocked or over her limit in Business Central?

Accounts receivable

Find orders that were never invoiced

Recent orders with no Business Central invoice are flagged, so billing gaps are closed.

Which of jordan@northwindtraders.com's Shopify orders this quarter have no Business Central invoice?

How it works

What PopdockAI does when you ask

You give an email and a lookback, and your AI assistant brings the customer's Shopify and Business Central records together. It only reads and stops if either side has several matches.

01

Ask

You give an email address and a lookback period.

Your AI tool

02

Find

It finds the customer in both systems by exact email.

shopify-get-customer

03

Trace

It matches recent Shopify orders to Business Central invoices.

shopify-get-order

04

Report

You get a side by side view and flags such as ordering while blocked.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.

get-data

shopify-get-customer

Returns Shopify customers with their account state, total spent and default address. Filter by name, email, tags, customer id, city, province, created date and total spent.
get-data

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
Read only.Nothing in Shopify 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 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