Connectors

/

Shopify

/

Find Shopify orders missing from Dynamics 365 Business Central
Report
Cross-Connector

Find Shopify orders that never reached Business Central

For finance and operations teams who want Shopify orders missing from Dynamics 365 Business Central found, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Shopify orders missing from Dynamics 365 Business Central
Which Shopify orders from last week are missing from Business Central?
412 orders checked, and 5 are missing from Business Central. - Oldest: #1042, 6 October, 240.00, paid - Total missing: 1,385.00 - Matched: 403 orders, by reference with the hash - Set aside: 4 canceled orders Want the list of missing orders?
Shopify
Sample figures. Your results come from your own account.
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

Orders the integration missed surface only when customers ask

Shopify orders should flow into Dynamics 365 Business Central, but integrations miss some and nobody notices until a customer asks why nothing shipped. Checking means searching each reference in open documents and posted invoices, often in two formats.

Without PopdockAI

  • Export Shopify orders for the period
  • Search open sales documents for each reference
  • Search posted invoices, with and without the hash
  • Find the misses when customers start calling

With PopdockAI

  • Shopify orders are read and canceled ones set aside
  • Each is looked up as an open document or posted invoice
  • The matching reference format is learned and used first
  • Missing orders are listed oldest first, and nothing is entered

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 every Shopify order created between `{from-date}` (default 7 days ago) and `{to-date}` (default today) that has not reached Business Central, either as an open sales document or as a posted sales invoice.

**Step 1: Read the Shopify orders**

Call `shopify-get-order` with `created-at.from` set to `{from-date}` and `created-at.to` set to `{to-date}`, and `max-records` 250. Keep `order-id`, `name`, `order-number`, `created-at`, `email`, `total-price`, `currency`, `financial-status`, `fulfillment-status` and `cancelled-at`. Set cancelled orders aside; list them at the end but do not look them up.

**Step 2: Look each order up in Business Central**

Business Central stores the Shopify order reference in `external-document-number`. For each order:

1. Call `business-central-get-sales-transaction` with `external-document-number` set to the Shopify `name` (for example #1001).
2. If nothing comes back, call `business-central-get-posted-sales-invoice` with `external-document-number` set to the same value.
3. If still nothing, repeat both calls with the `order-number` alone (for example 1001, without the #).

The first hit ends the search for that order. Record which form matched, and use that form first for the remaining orders.

**Step 3: Report**

A table of orders with no match on either tool: Shopify order name, created at, customer email, total price and currency, financial status, fulfillment status. Sort oldest first; the oldest are the most overdue.

Then a short summary: orders checked, found as open sales documents, found as posted invoices, missing, cancelled and skipped. State which reference format matched.

**Rules & Guidelines:**

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

**Validation:**

* If Shopify returns no orders in the range, say so and stop.
* If none of the orders match in either format, do not report every order as missing without comment. Say that Business Central may store the Shopify reference in a different field, and show one example order with the values you tried.
* If Shopify returns exactly 250 orders, say the result may be truncated and suggest a shorter date range.

Who it's for

One answer, three teams that use it

Order processing

Catch orders before they go unshipped

Missing orders come oldest first, so the ones closest to a complaint are entered first.

Which Shopify orders from the last 5 days are not in Business Central?

Integration admins

Prove the integration is keeping up

A quick check after an outage shows exactly which orders did not come through.

The connector was down yesterday. List Shopify orders from yesterday missing from Business Central.

Operations managers

Know the orders are all in the system

A regular check confirms every web order reached the ERP, with totals and status for any that did not.

Check last month's Shopify orders against Business Central and give me the missing ones with totals.

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant looks up every Shopify order in Business Central. It only reads and warns you if the reference may be stored somewhere else.

01

Ask

You give a date range.

Your AI tool

02

Read

It reads Shopify orders and sets canceled ones aside.

shopify-get-order

03

Check

It looks each one up in Business Central by reference, with and without the hash.

No items found.

04

Report

You get missing orders oldest first, with totals and status.

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

Missing orders caught before customers ask

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