/
/
Find Shopify orders that never made it into Wave
For operations teams who want to catch store orders missing from the books, just by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Missed store orders hide in two long lists
Store sales have to be keyed or synced into the books, and the only way to spot the misses is to compare Shopify orders with Wave invoices line by line. Cancelled and unpaid orders make real gaps hard to see.
Without PopdockAI
- Export the Shopify orders for the period
- Export the Wave invoices for the same dates
- Compare order numbers line by line
- Sort cancelled and unpaid orders out by hand
With PopdockAI
- Orders and invoices are read for your date range
- Matches use the purchase order number first
- Fuzzy matches are marked possible, never certain
- Cancelled and unpaid orders are listed apart
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For orders created in Shopify from `{from-date}` to `{to-date}` (default: the last 30 days), find the ones with no invoice in Wave. Company: `{company}`.
**Step 1: Read the orders**
Call `shopify-get-order` with `created-at.from` and `created-at.to` set to the range and `max-records` 500. Drop rows with a `cancelled-at` value into a separate list. Keep `name`, `order-number`, `email`, `total-price` and `financial-status`.
**Step 2: Read the invoices**
If you have access to more than one Wave company and `{company}` is empty, ask which company to use before reading anything. Call `wave-get-invoice` with `invoice-date.from` set to the range start and `invoice-date.to` set to the range end plus 14 days, and `max-records` 500. Keep `invoice-number`, `po-number`, `customer-name`, `total` and `status`.
**Step 3: Match**
An order matches an invoice when the invoice `po-number` equals the order `name` or order number. For orders with no match, try a second pass: same customer (look up the Wave customer with `wave-get-customer` by `email`) and equal total, and mark these "possible match".
**Step 4: Report**
Counts of matched, possible and unmatched orders. Then a table of unmatched orders (order name, date, email, total, financial status) sorted by total descending, a short list of possible matches, and invoices whose `po-number` looks like a Shopify order name but matched nothing. Give the unmatched total.
**Rules & Guidelines:**
* Tools named `wave-*` are on the wave-ai server; tools named `shopify-*` are on the shopify server. Both servers must be connected.
* Do not call any write tool on either server: on Wave every `wave-add-*`, `wave-update-*`, `wave-delete-*`, `wave-archive-*`, `wave-send-*`, `wave-approve-*`, `wave-mark-*`, `wave-clone-*`, `wave-convert-*`, `wave-reset-*` and `wave-generate-*` tool, and on Shopify every `shopify-add-*` and `shopify-update-*` tool. This prompt only reads.
* Do not create invoices. Only report the gaps.
**Validation:**
* If `{from-date}` is later than `{to-date}`, say so and stop.
* If either read returns 500 rows, warn that the range should be narrowed.
* Orders not yet paid (financial status pending) may legitimately have no invoice; list them under their own heading.Who it's for
One answer, three teams that use it
Operations managers
Confirm every order reached the books
See which store orders have no invoice, so none sit unbilled while the team assumes the sync worked.
Which Shopify orders from the last 30 days have no Wave invoice?
Bookkeepers
Close the month with fewer surprises
Get the unmatched orders and their total before month end, instead of comparing two exports.
Compare Shopify orders from 2026-10-01 to 2026-10-31 with Wave invoices for Fabrikam Goods.
E-commerce managers
Spot sync gaps early
Find orders that never synced, plus invoices whose PO number looks like a Shopify order but matched nothing.
List unmatched Shopify orders for Northwind Outdoors this week and show which are still unpaid.
How it works
What PopdockAI does when you ask
You give a date range, and your AI assistant reads both systems and matches orders to invoices. It only reports gaps, and warns when a read may be truncated.
Ask
You give a date range and the Wave company.
Match
It reads Shopify orders and Wave invoices, then matches by purchase order number with a careful second pass.
Report
You get counts, the unmatched orders by value, possible matches and the unmatched total.
What PopdockAI provides
The tools behind the answer
Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.
shopify-get-order
wave-get-invoice
wave-get-customer
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
Every missed order found before it goes unbilled
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)
