/
/
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.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the WooCommerce orders and Wave invoices since that date.
Match
It matches by order number, or by name, total and date within 3 days, labelled weak.
Report
You get each pair with the difference, plus unmatched orders and invoices.
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.
woocommerce-get-order
wave-get-invoice
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.
The outcome
Orders without invoices found, with no guesses
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.

.webp)
