Connectors

/

WooCommerce

/

Match WooCommerce orders to Wave invoices
Report
Cross-Connector

Check every WooCommerce order has a matching Wave invoice

For finance teams who want store orders lined up with invoices without comparing exports, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match WooCommerce orders to Wave invoices
Match completed WooCommerce orders since 2026-10-01 to Wave invoices for Northwind Traders and show anything that does not line up.
78 orders were checked: 70 matched, 3 are weak matches, 3 have no invoice and 2 have a different total. - No invoice: order 5120, Dana Whitfield, 189.00 USD - Different total: order 5133, Contoso Ltd, order 320.00 USD, invoice 300.00 USD, difference 20.00 USD - Weak match: order 5141 to invoice INV-2008, by name, total and date - Invoices with no order: 4 Want the full table of all 78 orders?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-order
wave-get-invoice

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

Store orders and invoices lined up by eye

Checking every WooCommerce order has a Wave invoice means comparing two exports. Orders with no invoice or a wrong total slip through, and guessed matches pair the wrong records.

Without PopdockAI

  • Export the orders from WooCommerce
  • Export the invoices from Wave
  • Look for each order number in PO numbers and memos
  • Guess at matches by name and total

With PopdockAI

  • Orders and invoices are read for your date range
  • Matches use the order number first
  • Weak matches need name, total and date to agree and are labelled
  • Totals are compared only in the same currency

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 since `{since-date}` (YYYY-MM-DD), find the matching Wave invoice and report orders with no invoice or a different total. Optional: `{order-status}` (default: completed). Company: `{company}`.

**Step 1: Read orders**

Call `woocommerce-get-order` (WooCommerce server) with `created-date.from` = `{since-date}`, `status` = `{order-status}` (use completed when empty) and `max-records` 500. Keep `order-id`, `order-number`, `created-date`, `total`, `currency`, `customer-email`, `billing-first-name`, `billing-last-name`.

**Step 2: Read invoices**

Call `wave-get-invoice` (Wave server) with `invoice-date.from` = `{since-date}` and `max-records` 500. Keep `invoice-number`, `po-number`, `memo`, `customer-name`, `total`, `amount-due`, `status`, `invoice-date`.

**Step 3: Match**

Match an order to an invoice when the order number appears in the invoice `po-number`, `invoice-number` or `memo`. If there is none, accept a match only when customer name, total and a date within 3 days all agree, and label it a weak match. Do not guess beyond that.

**Step 4: Report**

Table: order number, date, total, matched invoice, invoice total, difference, match quality. Then lists of orders with no invoice and invoices with no order. Totals compared only when currencies are the same.

**Rules & Guidelines:**

* Wave tools (server wave-ai) take an optional `company` argument; pass it on every Wave call when `{company}` is given.
* Read-only. Do NOT call any write tool on either server: on Wave (wave-ai) never call `wave-add-customer`, `wave-update-customer`, `wave-add-invoice`, `wave-add-product` or any other add, update, delete, send, archive or approve tool; on WooCommerce never call `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-update-order`, `woocommerce-add-refund` or any other add or update tool.

**Validation:**

* If an order matches more than one invoice, list all of them and do not pick one.
* If the currencies differ, report the pair without a difference figure.

Who it's for

One answer, three teams that use it

Accountants

Reconcile the store to the books

Get the orders with no invoice and the total differences in one report instead of a manual comparison.

Match WooCommerce orders since 2026-10-01 to Wave invoices and list the exceptions.

Accounts receivable

Make sure every order is invoiced

Find store orders that never got an invoice, so nothing is left unbilled.

Which processing WooCommerce orders from this month have no invoice in Wave for Fabrikam Goods?

Store owners

Trust the numbers in your books

Check that store sales and invoiced sales agree, with differences shown order by order.

Compare my WooCommerce completed orders from September 2026 with Wave and show where the totals differ.

How it works

What PopdockAI does when you ask

You give a start date, and your AI assistant reads both systems and matches orders to invoices. It only reports, and lists every candidate when more than one invoice fits an order.

Ask

You give a start date and optionally an order status and Wave company.

Your AI tool

Read

It reads the WooCommerce orders and Wave invoices since that date.

woocommerce-get-order
wave-get-invoice

Match

It matches by order number, or by name, total and date within 3 days, labelled weak.

No items found.

Report

You get each pair with the difference, plus unmatched orders and invoices.

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

wave-get-invoice

Returns invoices from Wave. Wave connector tool; filter by the parameters it offers.
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 without invoices found, with no guesses

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

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