Connectors

/

Shopify

/

Trace a Shopify order into Dynamics 365 Business Central
Read
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Trace a Shopify order into Dynamics 365 Business Central
Where is Shopify order #1042 in Business Central? Has it shipped and been invoiced?
Order #1042 shipped and was invoiced, but the invoice is still open. - Shopify: paid 240.00, shipped 3 October, tracking 1Z999AA10123456784 - Business Central: invoice PSI-104233 posted, 240.00 remaining - Lines: 3 ordered, 3 shipped, 3 invoiced Disagreement: paid online but open in Business Central. Want the line table?
Shopify
Sample figures. Your results come from your own account.
shopify-get-order
shopify-get-order-line
shopify-get-fulfillment
shopify-get-transaction

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

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.

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

Your AI tool

02

Read

It reads the Shopify order, lines, shipments with tracking and payments.

shopify-get-order
shopify-get-order-line
shopify-get-fulfillment
shopify-get-transaction

03

Find

It finds the matching Business Central sales document and posted invoice.

No items found.

04

Report

You get a status block for each side and a line comparison.

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-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.
get-data

shopify-get-order-line

Returns the line items on Shopify orders with their price, quantity and fulfillment status. Filter by order, product, SKU, title, vendor, price and quantity.
get-data

shopify-get-fulfillment

Returns Shopify fulfillments with their status, shipment status and tracking number. Filter by order, customer, tracking number, status and created date.
get-data

shopify-get-transaction

Returns the payment transactions on Shopify orders, such as authorizations, sales, captures and refunds, with gateway and status. Filter by order, customer, kind, status, gateway, amount and processed date.
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

Any order question answered in a single read

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