Connectors

/

WooCommerce

/

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

Catch web orders that never reached Business Central

For operations and finance teams who want WooCommerce orders checked against Dynamics 365 Business Central by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find WooCommerce orders missing from Dynamics 365 Business Central
Are any WooCommerce orders from the last week missing in Business Central?
Of 214 WooCommerce orders from the last 7 days, 6 need attention in Business Central. - Missing: 3 orders, including 1042 for Contoso - Duplicated: order 1047 appears on two sales documents - Amount differs: order 1051, 129.00 against 119.00 - Currency: order 1055 is in EUR on one side only Want the missing orders listed with totals?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

WooCommerce

WooCommerce
Run it on your own WooCommerce data.

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

Try PopdockAI free

The problem

Web orders that never reached the ERP

Processing and completed WooCommerce orders should all be in Dynamics 365 Business Central. Some never arrive, some arrive twice and some land with a different total, and problems surface only when a customer calls.

Without PopdockAI

  • Export orders from WooCommerce
  • Search Business Central for each order number
  • Compare totals by hand
  • Hear about the missing order from the customer

With PopdockAI

  • Processing and completed orders are read for the range
  • Each is looked for as an open sales document or posted invoice
  • Orders are classed matched, amount differs, missing or duplicated
  • Only exceptions are shown, and nothing is created or altered

The prompt

Use this prompt

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

Prompt
**Objective:** Reconcile WooCommerce orders created from {from-date} (default: 7 days before today) to {to-date} (default: today) against Business Central, and list every order that is missing or differs. Use Business Central company {company} (if blank, leave `company` off).

**Step 1: Collect the web orders**

Call `woocommerce-get-order` with `created-date.from` and `created-date.to` set to the range, and `status` set to processing. Call it again with `status` completed. Use `max-records` 100 on each call. Ignore pending, on-hold, cancelled, failed and refunded orders: they are not expected in Business Central yet. If either call returns 100 orders, say the range was truncated and suggest a shorter one.

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

Web orders are entered with the WooCommerce order number as the external document number. For each order, call `business-central-get-sales-transaction` with `external-document-number` set to its order-number. If that returns nothing, call `business-central-get-posted-sales-invoice` with the same `external-document-number`, since the order may already have been invoiced and posted.

**Step 3: Classify**

* **Matched:** a Business Central document exists and its total-amount-including-tax is within 0.01 of the WooCommerce total.
* **Amount differs:** a document exists but the totals differ by more than 0.01.
* **Missing from Business Central:** no document found by either call.
* **Duplicated:** more than one Business Central document of the same type carries the order number.

**Step 4: Report**

Start with counts per class. Then one table of the exceptions only (not the matched orders), with columns: order number, created date, customer email, WooCommerce total, Business Central document type and number, Business Central total, difference, class. Sort Missing first, then Amount differs, then Duplicated, oldest first within each.

**Rules & Guidelines:**

* Tools whose names start with woocommerce- are on the woocommerce server; tools whose names start with business-central- are on the business-central server.
* This prompt is read-only. Do not call `business-central-create-sales-order`, `business-central-create-sales-invoice`, `woocommerce-update-order` or `woocommerce-add-order-note`. To enter a missing order, the user can run post-web-order-to-business-central for it.

**Validation:**

* If WooCommerce returns no orders in the range, say so and stop.
* If an order's currency differs from the Business Central document's currency-code, report it as Amount differs with both currencies shown rather than comparing the raw numbers.
* Dates are ISO dates (YYYY-MM-DD). If {from-date} is after {to-date}, swap them and say so.

Who it's for

One answer, three teams that use it

Operations managers

Make sure every order is fulfilled

Missing orders are listed first, so they can be entered before customers chase them.

Which WooCommerce orders from yesterday are missing in Business Central?

Finance teams

Catch duplicates and amount differences

Orders that arrived twice or with a different total are flagged before they are billed.

Show WooCommerce orders from October that are duplicated or have a different total in Business Central.

Integration specialists

Monitor the order sync

A regular check shows whether the integration is dropping or duplicating orders.

Check the last 3 days of WooCommerce orders against Business Central and list the exceptions.

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant checks each web order against Business Central. It shows only the exceptions and changes nothing.

01

Ask

You give a date range.

Your AI tool

02

Read

It reads processing and completed WooCommerce orders.

woocommerce-get-order

03

Match

It looks for each as an open sales document or posted invoice by order number.

No items found.

04

Report

You get only the exceptions, missing orders first, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

woocommerce-get-order

Returns WooCommerce orders with status, totals, discounts, shipping, payment method and paid date. Filter by status, customer email or id, order number, created date range, total range or billing last name.
Read only.Nothing in WooCommerce 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 and duplicate orders caught before they cause errors

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