Connectors

/

WooCommerce

/

Reconcile WooCommerce orders with Dynamics GP
Report
Cross-Connector

Catch WooCommerce orders that never reached Dynamics GP

For operations and finance teams who want WooCommerce orders matched to Dynamics GP sales documents by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile WooCommerce orders with Dynamics GP
Reconcile this week's WooCommerce orders with Dynamics GP.
Of 182 WooCommerce orders this week, 175 match a Dynamics GP document. - Missing: 4 orders, including 1042 - Total differs: order 1047, 104.00 against 96.00 on the invoice - Customer looks wrong: order 1051 is under Fabrikam, buyer is Jordan Lee - Currency: 1 order in EUR, not compared Want the missing orders listed?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-order
microsoft-dynamics-gp-get-rm-sales-trx

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

Orders that fail to import without a sound

Every WooCommerce order should reach Dynamics GP as a sales document, but imports fail quietly and totals change after edits. Checking a week of orders means searching GP by PO number and deciding which quote, order or invoice to compare.

Without PopdockAI

  • Export a week of WooCommerce orders
  • Search GP by customer PO for each
  • Pick which document to compare
  • Compare totals by hand

With PopdockAI

  • Orders are read for the date range
  • Each is found in GP by customer PO, then order ID
  • The most advanced document is compared
  • Missing orders, total differences and odd customers are listed, and nothing is written

The prompt

Use this prompt

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

Prompt
**Objective:** For WooCommerce orders created from {start-date} to {end-date} (default: today) with status {order-status} (default: every status except cancelled, failed and pending), find the matching Dynamics GP sales document by customer PO number and report orders missing from GP or with a different total.

**Step 1: Read the store orders (woocommerce)**

Call `woocommerce-get-order` with created-date.from set to {start-date}, created-date.to set to {end-date} (default today), status set to {order-status} when it is given, and max-records 200. Without {order-status}, drop cancelled, failed and pending orders from the result. Keep order-number, order-id, created-date, status, billing name, total and currency.

**Step 2: Find each order in Dynamics GP (dynamics-gp)**

For each order call `dynamics-gp-get-rm-sales-trx` with customer-po-number set to the order-number. If nothing comes back and the order-id differs from the order-number, try once more with the order-id. If there is still nothing, record the order as in the store but not in GP.

**Step 3: Compare**

One store order can have several GP documents (a quote, an order, then an invoice). Compare the store total with the document-amount of the most advanced document: an invoice before an order, and an order before a quote. A difference under 0.01 is a match.

**Step 4: Report**

1. In the store, not in GP: order number, date, status, billing name, total.
2. Total differences: order number, GP SOP number and type, store total, GP document amount, difference.
3. Possible mismatches: GP documents whose customer-name bears no resemblance to the store billing name.
4. Summary: orders checked, matched, missing, total differences.

**Rules & Guidelines:**

* Tools whose names start with woocommerce- are on the woocommerce MCP server; tools whose names start with dynamics-gp- are on the dynamics-gp MCP server. If a tool from either server is not available, stop and say which server is not connected.
* If the user names a Dynamics GP company, pass it as company on every dynamics-gp call.
* Match a store SKU to a GP item number exactly, after trimming spaces. If that fails, try the SKU in upper case once. Never match on descriptions or partial codes.
* This prompt is read-only. Do not call `dynamics-gp-rm-sales-trx-add`, `dynamics-gp-rm-sales-line-item-add`, `dynamics-gp-rm-sales-trx-update` or `woocommerce-update-order`. To bring a missing order across, point the user to the import-web-order-to-gp prompt.

**Validation:**

* If step 1 returns no orders, say so and stop.
* If step 1 returns exactly 200 orders, say the range may hold more and suggest a shorter one.
* If the store currency and the GP document are clearly in different currencies, report the pair without calling it a difference.

Who it's for

One answer, three teams that use it

Operations managers

Make sure every order reached GP

Orders missing from GP are listed so they can be entered before fulfilment is late.

Which WooCommerce orders from the last 7 days are missing from Dynamics GP?

Finance teams

Catch totals that changed

Differences between the store total and the GP document are listed for review.

Show WooCommerce orders in October whose total differs from the Dynamics GP invoice.

ERP administrators

Spot documents under the wrong customer

GP documents whose customer looks nothing like the buyer are flagged.

Reconcile completed WooCommerce orders this month with GP and flag unexpected customers.

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant finds each order's GP document and compares totals. It reads from both systems and writes nothing back.

01

Ask

You give a date range, and optionally an order status.

Your AI tool

02

Read

It reads the WooCommerce orders.

woocommerce-get-order

03

Match

It finds each GP document by customer PO and compares the most advanced one.

microsoft-dynamics-gp-get-rm-sales-trx

04

Report

You get missing orders, total differences and odd customers, read-only.

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

microsoft-dynamics-gp-get-rm-sales-trx

Returns Sales Order Processing documents such as quotes, orders and invoices from Dynamics GP Sales, with the customer, dates, salesperson and document totals. Filter by batch number, customer ID, SOP type, SOP number, salesperson ID, document amount, customer name and document date, and pick the company and the maximum number of records.
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 mistotalled orders caught in one pass

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