Connectors

/

WooCommerce

/

Complete WooCommerce orders invoiced in Dynamics GP
Write
Cross-Connector

Complete WooCommerce orders as soon as Dynamics GP invoices them

For operations teams who want processing WooCommerce orders completed once Dynamics GP has posted the invoice, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Complete WooCommerce orders invoiced in Dynamics GP
Complete any WooCommerce orders in processing that Dynamics GP has invoiced in the last 30 days.
16 processing WooCommerce orders have a posted Dynamics GP invoice; 14 are ready to complete. - Ready: 14 orders, each noted with its GP invoice - Total differs: order 1042 is 0.50 off its invoice, set aside - Possible duplicate: order 1047 has two posted invoices Customers usually get a completed email. Shall I complete the 14 orders?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-order
microsoft-dynamics-gp-get-rm-sales-trx
woocommerce-update-order
woocommerce-add-order-note

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 stuck in processing after they were invoiced

Orders sit in processing in WooCommerce long after Dynamics GP has invoiced them, because someone has to check each one in GP and update the store. Customers wait for a completed notice, and completing too early causes its own confusion.

Without PopdockAI

  • List processing orders in WooCommerce
  • Search GP for a posted invoice for each
  • Check totals match
  • Update each order by hand

With PopdockAI

  • A posted GP invoice is found for each order by customer PO
  • Totals that differ and possible duplicates are set aside
  • You confirm the list, warned about completed emails
  • Each order is completed with a private note, and GP is never changed

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 WooCommerce orders in processing status created since {since-date} (default: 30 days before today), up to {max-orders} orders (default 50), that Dynamics GP has invoiced and posted, and mark them completed after the user confirms.

**Step 1: Read processing orders (woocommerce)**

Call `woocommerce-get-order` with status processing, created-date.from set to {since-date} (default 30 days before today) and max-records set to {max-orders} (default 50). Keep order-id, order-number, created-date, billing name and total.

**Step 2: Look for a posted GP invoice (dynamics-gp)**

For each order call `dynamics-gp-get-rm-sales-trx` with customer-po-number set to the order-number. An order is ready only if GP has a document with sop-type Invoice whose posting-status shows it is posted. An order with only a GP order or quote, or an unposted invoice, is not ready.

**Step 3: Preview and confirm**

Show the ready orders: order number, GP invoice SOP number, store total, GP document-amount. Move any order whose totals differ by 0.01 or more to a separate list, and do not include it unless the user says so. Say that marking an order completed usually sends the customer the store's order completed email. List the orders that are not ready, with the reason. Ask the user to confirm before writing anything.

**Step 4: Write (woocommerce)**

Only after the user confirms, for each ready order call `woocommerce-update-order` with order-id and status completed. If that succeeds, call `woocommerce-add-order-note` with order-id, note set to Invoiced in Dynamics GP as the invoice SOP number, and customer-note false. If the update fails, skip the note, report the error and carry on with the next order.

**Step 5: Report**

Orders completed, orders skipped with the reason, and any errors.

**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.
* The only tools that may write are `woocommerce-update-order` (status only) and `woocommerce-add-order-note` (private notes only), and only after the confirmation in step 3.
* Never pass set-paid, never set customer-note true, and never call `woocommerce-send-order-details`.
* Never write to GP. Do not call `dynamics-gp-rm-sales-trx-update` or `dynamics-gp-rm-sales-trx-note`.

**Validation:**

* If step 1 returns no orders, say so and stop.
* If step 1 returns exactly {max-orders} orders (default 50), say more may be waiting and suggest running again.
* If GP has two posted invoices for the same PO number, do not complete that order; list it as a possible duplicate.

Who it's for

One answer, three teams that use it

Fulfilment managers

Clear the processing queue

Complete orders GP has already invoiced in one confirmed step, each with a note naming the invoice.

Complete WooCommerce orders that Dynamics GP has invoiced since 1 November, up to 50.

Customer service teams

Get customers their completed notice

Customers hear their order is done as soon as it is invoiced, not days later.

Which processing WooCommerce orders already have a posted invoice in Dynamics GP?

Finance teams

Catch total mismatches and duplicates

Orders whose GP total differs or that have two invoices are set aside for you to check.

Match processing WooCommerce orders from last week to GP invoices and show any total differences.

How it works

What PopdockAI does when you ask

You give a start date and how many orders to check, and your AI assistant matches processing orders to posted GP invoices. Orders are completed only after you confirm.

01

Ask

You give a start date and a maximum number of orders.

Your AI tool

02

Match

It looks for a posted GP invoice carrying each order number as the PO.

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

03

Confirm

You approve the list, warned that customers usually get an email.

No items found.

04

Complete

It completes each order and adds a private note naming the invoice.

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

woocommerce-update-order

Updates an existing WooCommerce order by id, most often to change its status. Can also mark it paid and set the transaction id, billing email and phone, or the customer note.
run-action

woocommerce-add-order-note

Adds a note to a WooCommerce order by id, either private to store staff or emailed to the customer.
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

Orders completed as soon as GP invoices them

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