/
/
Trace a Shopify order all the way into Business Central
For support and finance teams who want one order's shipping, invoicing and payment status across Shopify and Business Central, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Where an order is depends on two systems
When a customer asks about a Shopify order, the answer depends on both systems: did it ship, what is the tracking, did it reach Dynamics 365 Business Central, and was it invoiced and paid there. Answering means hopping between screens.
Without PopdockAI
- Open the order, lines and shipments in Shopify
- Find the tracking and payments
- Search Business Central for the document and invoice
- Compare quantities line by line
With PopdockAI
- The order, lines, shipments with tracking and payments are read
- The Business Central sales document and invoice are found
- Ordered, shipped, invoiced and outstanding quantities are compared
- Anything that disagrees is named in one sentence, read-only
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Give the full status of Shopify order `{order-name}` across both systems: what was ordered, whether it shipped, whether it reached Business Central, whether it has been invoiced there, and what is still owed.
**Step 1: Find the order in Shopify**
Call `shopify-get-order` with `name` set to `{order-name}`. If nothing comes back and `{order-name}` is numeric, call it again with `order-number`. If more than one order comes back, list them and stop. Keep `order-id`, `name`, `order-number`, `created-at`, `email`, `total-price`, `total-outstanding`, `currency`, `financial-status`, `fulfillment-status` and `cancelled-at`.
**Step 2: Shopify detail**
With the `order-id`:
* Call `shopify-get-order-line` with `order-id` for the lines (`sku`, `title`, `quantity`, `price`, `fulfillable-quantity`).
* Call `shopify-get-fulfillment` with `order-id` for shipments (`status`, `shipment-status`, `tracking-company`, `tracking-number`, `tracking-url`).
* Call `shopify-get-transaction` with `order-id` for payments (`kind`, `status`, `gateway`, `shop-amount`, `processed-at`).
**Step 3: Find it in Business Central**
The Shopify order name is carried in Business Central's `external-document-number`. Call `business-central-get-sales-transaction` with `external-document-number` set to the Shopify `name`, then `business-central-get-posted-sales-invoice` with the same value. If both are empty, retry both with `order-number` (without the #).
For an open sales document, call `business-central-get-sales-transaction-line` with `document-number` to see `quantity-shipped`, `quantity-invoiced` and `outstanding-quantity`. For a posted invoice, keep `invoice-number`, `posting-date`, `total-amount-including-tax`, `remaining-amount` and `due-date`.
**Step 4: Report**
A short status block:
* **Shopify:** created, financial status, fulfillment status, total, outstanding
* **Shipping:** each fulfillment with carrier and tracking link, or not shipped
* **Business Central:** document type and number, or not found
* **Invoice:** invoice number, posting date, amount, remaining amount, due date, or not invoiced
Then a lines table: SKU, title, Shopify quantity, fulfillable, Business Central shipped, invoiced, outstanding.
End with one sentence naming anything that disagrees, for example shipped in Shopify but not shipped in Business Central, paid in Shopify but an open balance in Business Central, or totals that differ.
**Rules & Guidelines:**
* `shopify-get-order`, `shopify-get-order-line`, `shopify-get-fulfillment` and `shopify-get-transaction` are on the shopify server. `business-central-get-sales-transaction`, `business-central-get-sales-transaction-line` and `business-central-get-posted-sales-invoice` are on the business-central server.
* This prompt is read-only. Do NOT call `shopify-update-order`, `business-central-update-sales-order` 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:**
* If the order is not in Shopify, say so and stop.
* If the order is in Shopify but not in Business Central, report the Shopify side in full and state plainly that it has not reached Business Central.
* Compare totals rounded to 2 decimals, and only when the currencies agree.Who it's for
One answer, three teams that use it
Support agents
Tell customers where their order is
Shipments, tracking and invoice status in one answer, without opening the ERP.
Where is Shopify order #2210? Has it shipped and been invoiced in Business Central?
Order processing
Find lines that never shipped
A line table shows ordered, shipped and outstanding quantities, so partial shipments are clear.
Which lines on Shopify order #1987 are still outstanding in Business Central?
Accounts receivable
Spot paid online but open in the ERP
Disagreements like paid in Shopify but open in Business Central are named so they can be fixed.
Is Shopify order #2054 paid online but still open in Business Central?
How it works
What PopdockAI does when you ask
You give the order, and your AI assistant traces it from Shopify into Business Central. It only reads both systems and compares totals only when currencies agree.
01
Ask
You give the order name or number.
02
Read
It reads the Shopify order, lines, shipments with tracking and payments.
03
Find
It finds the matching Business Central sales document and posted invoice.
04
Report
You get a status block for each side and a line comparison.
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.
shopify-get-order
shopify-get-order-line
shopify-get-fulfillment
shopify-get-transaction
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
Any order question answered in a single read
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)
