Connectors

/

Shopify

/

Review Shopify refunds against Wave
Report
Cross-Connector

Find Shopify refunds the Wave books still miss

For finance teams who ask their AI assistant whether Shopify refunds have been reflected in Wave.

Try PopdockAI free
Get a live demo
Review Shopify refunds against Wave
Check Shopify refunds from the last 30 days against Wave and show me which ones the books still show as fully paid.
8 of 21 Shopify refunds are not yet reflected in Wave. - Books still show full payment: 8, USD 1,640.00 - Books reflect refund: 11 - No Wave invoice: 1 - Unclear: 1, currency differs Want the full table with order names and Wave invoice numbers?
Shopify
Sample figures. Your results come from your own account.
shopify-get-refund
shopify-get-refund-line
wave-get-invoice
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

Store refunds are forgotten in the books

When a refund is issued in the store it is easy to forget in the accounting system. Revenue stays overstated until someone spots the invoice still showing as paid.

Without PopdockAI

  • Export refunds from Shopify
  • Find each order's invoice in Wave
  • Compare payments with the refunded amount
  • Spot what was never adjusted

With PopdockAI

  • Refunds are read with their amounts worked out
  • Each order is matched to its Wave invoice
  • Totals and payments are compared net of refund
  • Gaps are totalled, nothing is edited or credited

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 Shopify refunds created from `{from-date}` to `{to-date}` (default: the last 30 days), check whether Wave still shows the invoice as fully paid. Company: `{company}`.

**Step 1: Read the refunds**

Call `shopify-get-refund` with `created-at.from` and `created-at.to` set to the range and `max-records` 200. Keep `refund-id`, `order-id`, `order-name`, `customer-email`, `total-adjustments` and `created-at`. Where a refund has no total, call `shopify-get-refund-line` with `order-refund-id` and sum `subtotal` and `total-tax`.

**Step 2: 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. For each refund call `wave-get-invoice` with `po-number` set to `order-name`. If nothing matches, record "no Wave invoice".

**Step 3: Check the payments**

For each matched invoice call `wave-get-invoice-payment` with `invoice-invoice-number`. Compare the invoice `total` and `amount-paid` with the order amount net of the refund.

**Step 4: Report**

A table: order name, refund date, refund amount, Wave invoice number, Wave total, Wave amount paid, and a status: books reflect refund, books still show full payment, no Wave invoice, or unclear. Sort "still show full payment" first and total that group.

**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 delete or edit Wave payments, create credits or change anything in Shopify. Only report what needs correcting.

**Validation:**

* If there are no refunds in the range, say so and stop.
* If currencies differ between the refund and the invoice, report both and flag the row as unclear.

Who it's for

One answer, three teams that use it

Accounts receivable

Find invoices that need a credit

List the invoices still showing full payment after a store refund.

Which Shopify refunds from this month are not yet reflected in Wave?

Controllers

Check revenue before close

See the total of refunds the books have missed so revenue is not overstated.

Total the Shopify refunds from October that Wave still shows as fully paid.

Ecommerce managers

Confirm refunds reached finance

Check that refunds issued by the support team are visible in the accounts.

Did the Shopify refunds we issued last week show up in Wave?

How it works

What PopdockAI does when you ask

You give the period and your AI assistant reads Shopify and Wave. It reports what needs correcting and never edits a payment, issues a credit or changes the store.

Ask

You give the date range and the Wave business.

Your AI tool

Read

It reads the Shopify refunds, adding up refund lines where needed.

shopify-get-refund
shopify-get-refund-line
wave-get-invoice
wave-get-invoice-payment

Check

It finds each order's Wave invoice and compares total and amount paid with the net amount.

No items found.

Report

It gives a status per refund and totals the ones still showing full payment.

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-refund

Returns Shopify refunds with their order and total adjustments. Filter by order, customer, customer email, refund and created date.
get-data

shopify-get-refund-line

Returns the line items on Shopify refunds, with the subtotal and how each was restocked. Filter by refund, order, SKU, name and restock type.
get-data

wave-get-invoice

Returns invoices 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

Refunds reflected in the books, not overlooked

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