Connectors

/

Shopify

/

Find paid Shopify orders open in Dynamics 365 Business Central
Report
Cross-Connector

Stop chasing customers who already paid in Shopify

For finance teams who want Business Central invoices still open on paid Shopify orders found, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find paid Shopify orders open in Dynamics 365 Business Central
Which Shopify orders paid in September are still open in Business Central?
17 paid Shopify orders still have an open Business Central invoice. - Past due: 6 invoices, the oldest PSI-104233 - Exact match: 15 open amounts equal the Shopify payment - Evidence: #1042 paid 240.00 via Shopify Payments on 4 September - No invoice: 2 paid orders Want the full list for applying payments?
Shopify
Sample figures. Your results come from your own account.
shopify-get-order
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

Paid customers get chased for invoices that look overdue

Shopify marks an order paid when the gateway captures the money, but the invoice in Dynamics 365 Business Central can stay open for weeks until someone applies the payment. Those invoices look overdue and trigger collection calls to customers who already paid.

Without PopdockAI

  • Export paid Shopify orders for the period
  • Search Business Central for each posted invoice
  • Look up the gateway, amount and date for each payment
  • Call customers about invoices they already paid

With PopdockAI

  • Paid Shopify orders are matched to open Business Central invoices
  • Each invoice gets the gateway, amount and date to apply
  • Invoices are sorted by due date with past-due ones marked
  • It only reads, and applying payments stays with you

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 Shopify orders created between `{from-date}` (default 30 days ago) and `{to-date}` (default today) that Shopify reports as paid, but whose posted sales invoice in Business Central still has a remaining amount, so the payment has not been applied there.

**Step 1: Read the paid Shopify orders**

Call `shopify-get-order` with `financial-status` set to paid, `created-at.from` set to `{from-date}`, `created-at.to` set to `{to-date}`, and `max-records` 250. Keep `order-id`, `name`, `order-number`, `created-at`, `email`, `total-price` and `currency`.

**Step 2: Find the invoice in Business Central**

For each order, call `business-central-get-posted-sales-invoice` with `external-document-number` set to the Shopify `name`. If nothing comes back, retry with `order-number` alone. Keep `invoice-number`, `posting-date`, `due-date`, `total-amount-including-tax` and `remaining-amount`.

Keep only invoices with `remaining-amount` greater than 0. Orders with no invoice go in a separate list.

**Step 3: Payment evidence**

For each order kept, call `shopify-get-transaction` with `order-id` and keep successful `sale` or `capture` transactions: `gateway`, `shop-amount`, `processed-at`, `order-transaction-id`. This is what the finance team needs to apply the payment.

**Step 4: Report**

A table: Shopify order name, Business Central invoice number, invoice total, remaining amount, due date, Shopify payment gateway, amount paid, paid at. Sort by due date, oldest first, and mark invoices already past due.

Then: paid orders with no posted invoice (count and names), and the total remaining amount across the table.

**Rules & Guidelines:**

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

**Validation:**

* If Shopify returns no paid orders in the range, say so and stop.
* If the `financial-status` filter returns nothing but orders exist, retry once without it and keep only orders whose `financial-status` is paid.
* If the remaining amount equals the Shopify payment exactly, say the payment is probably unapplied. If it differs, say so and show both figures.

Who it's for

One answer, three teams that use it

Accounts receivable

Apply web payments with the details ready

Each open invoice comes with its Shopify gateway, amount and date, so cash application is a short task.

List Shopify orders paid in October whose invoices are still open in Business Central, with payment details.

Credit controllers

Check before you chase

Remove paid web orders from the overdue list before collection calls go out.

Which past-due Business Central invoices were already paid in Shopify last month?

Finance managers

See paid orders with no invoice at all

Paid orders with no invoice are listed too, so you can fix gaps in the order flow as well as open balances.

For Shopify orders paid in the last two weeks, which have no posted invoice in Business Central?

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant lists every paid Shopify order whose Business Central invoice is still open. It only reads and gives you what you need to apply each payment.

01

Ask

You give a date range.

Your AI tool

02

Read

It reads Shopify orders marked paid and finds each posted Business Central invoice.

shopify-get-order

03

Evidence

It adds the Shopify gateway, amount and date for each open invoice.

shopify-get-transaction

04

Report

You get invoices by due date, past-due marked, and paid orders with no invoice.

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

No more collection calls to customers who paid

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