Connectors

/

Shopify

/

Trace a Shopify order into Wave
Report
Cross-Connector

Prove a Shopify order landed in Wave as a paid invoice

For finance teams who want to check one Shopify order against its Wave invoice and payments by asking their AI assistant.

Try PopdockAI free
Get a live demo
Trace a Shopify order into Wave
Trace Shopify order 1001 into Wave for Northwind Traders and tell me if it was invoiced and paid for the same amount.
Order #1001 is invoiced in Wave but only partly paid. - Shopify: total 250.00 USD, collected 250.00, status paid - Wave invoice: INV-1042, total 250.00 - Wave payments: 150.00 - Difference: 100.00 not yet recorded in Wave Want me to check the other orders for this customer?
Shopify
Sample figures. Your results come from your own account.
shopify-get-order
shopify-get-transaction
wave-get-invoice
wave-get-customer
wave-get-invoice-payment

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

Connect Shopify, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Order mismatches hide until month end

Checking that a store order became a paid Wave invoice means reading Shopify, then searching Wave by hand. Missing invoices and short payments are only noticed when the books are closed.

Without PopdockAI

  • Open the order and its payments in Shopify
  • Work out net collected after refunds
  • Search Wave for the matching invoice and payments
  • Compare amounts and currencies yourself

With PopdockAI

  • The order is read and ambiguous numbers stop the job
  • Collected amounts are totalled after refunds
  • The Wave invoice and payments are found and fuzzy matches are labelled
  • A verdict names the difference and nothing is 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:** Trace Shopify order `{order-number}` into Wave and report whether it was invoiced and paid there for the same amount. Company: `{company}`.

**Step 1: Read the order from Shopify**

Call `shopify-get-order` with `order-number` set to `{order-number}`. If more than one row comes back, list them and stop. Keep `name`, `email`, `total-price`, `currency`, `financial-status`, `total-outstanding` and `cancelled-at`.

**Step 2: Check what Shopify collected**

Call `shopify-get-transaction` with `order-id` from step 1. Total the successful sale and capture amounts and subtract successful refunds.

**Step 3: Find the invoice in Wave**

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 `po-number` set to the Shopify order `name` (for example #1001) and again with the bare order number if nothing matches. If still nothing, call `wave-get-customer` with `email` from step 1 and then `wave-get-invoice` with that `customer-name`, and offer only invoices whose total equals the order total as candidates, labelled as unconfirmed.

**Step 4: Read the Wave payments**

Call `wave-get-invoice-payment` with `invoice-invoice-number` from the matched invoice. Total the payments.

**Step 5: Report**

Side by side: order total, amount collected in Shopify, Wave invoice total, Wave amount paid, and a verdict: matched and paid in both, invoiced but unpaid in Wave, paid in Shopify but no Wave payment, no Wave invoice, or amounts differ (with the difference).

**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.

**Validation:**

* If the currencies differ, report both amounts and do not compute a difference.
* If the order is cancelled, say so first and still report what Wave shows.

Who it's for

One answer, three teams that use it

Bookkeepers

Check that a store order was booked correctly

Confirm an order has a Wave invoice and the right payments before it becomes a month end question.

Trace Shopify order 1042 into Wave for Fabrikam Holdings and tell me if the payment matches.

Finance managers

Spot short or missing payments early

See immediately when a paid Shopify order has no Wave payment or an invoice with a different amount.

Was Shopify order 1015 paid in Shopify but not recorded in Wave?

Ecommerce operators

Answer a customer who says they paid

Check what Shopify collected and what the books show for one order, in a single comparison.

Customer priya@contoso.example says order 1023 was paid. What do Shopify and Wave show for it?

How it works

What PopdockAI does when you ask

You give an order number and your AI assistant reads Shopify, then Wave. It only reads, and it labels any uncertain invoice match as unconfirmed.

Ask

You give a Shopify order number and the Wave company if needed.

Your AI tool

Collect

It reads the order and totals successful payments less refunds in Shopify.

shopify-get-order
shopify-get-transaction
wave-get-invoice
wave-get-customer
wave-get-invoice-payment

Match

It finds the Wave invoice by order reference and reads its payments, labelling fuzzy matches unconfirmed.

No items found.

Report

It shows both sides together with a verdict on whether they agree.

Your AI tool

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.

get-data

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
get-data

shopify-get-transaction

Returns the payment transactions on Shopify orders, such as authorizations, sales, captures and refunds, with gateway and status. Filter by order, customer, kind, status, gateway, amount and processed date.
get-data

wave-get-invoice

Returns invoices from Wave. Wave connector tool; filter by the parameters it offers.
get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
get-data

wave-get-invoice-payment

Returns invoice payments from Wave. Wave connector tool; filter by the parameters it offers.
Read only.Nothing in Shopify 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

Know an order is paid in both systems

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