/
/
Chase overdue Wave customers with store activity in view
For finance teams who want their AI assistant to show Shopify activity next to each overdue Wave customer.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Chasing a late payer without knowing if they still buy
Before chasing a late payer you check the store by hand to see whether they still order. That step is often skipped, so every reminder reads the same.
Without PopdockAI
- List overdue customers in Wave
- Look each one up in the store
- Open recent orders and check risk
- Decide how firmly to chase
With PopdockAI
- Overdue customers are read from Wave
- Each is found in Shopify by email only
- Recent orders and order risk are added
- Groups suggest an approach, nobody is contacted
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find Wave customers whose overdue amount is at least `{min-overdue}` (default 1) and show what they have been doing in Shopify, so the collection approach fits the relationship. Company: `{company}`.
**Step 1: Read overdue customers from 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-customer` with `overdue-amount.min` set to `{min-overdue}`, `is-archived` false and `max-records` 100. Keep `name`, `email`, `overdue-amount`, `outstanding-amount`. Skip and list customers with no email.
**Step 2: Find them in Shopify**
For each customer with an email call `shopify-get-customer` with `email` set to it. Keep `customer-id`, `orders-count`, `total-spent` and `last-order-name`. If there is no match, mark "not a Shopify customer".
**Step 3: Pull recent orders and risk**
For the ten customers with the largest overdue amounts that matched in Shopify, call `shopify-get-order` with `customer-id` and `max-records` 5. Then call `shopify-get-order-risk` with `order-id` for any order that is not fully paid, and note a high risk level or a cancel recommendation.
**Step 4: Report**
A table: customer, overdue amount, Shopify orders count, total spent, latest order and its status, risk note. Group into "active buyer, chase gently", "no recent store activity, chase firmly" and "not in Shopify". End with the total overdue for each 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 contact anyone. Only recommend an approach.
**Validation:**
* If no Wave customer is overdue by that amount, say so and stop.
* Never match on name alone; email is the only join key.Who it's for
One answer, three teams that use it
Accounts receivable
Chase with context
See whether a late payer is still ordering before you pick up the phone.
Which overdue Wave customers are still buying in Shopify? I want to chase those gently.
Credit controllers
Prioritise by risk and balance
Combine overdue totals with Shopify order risk to decide who needs a firm approach.
For Wave customers overdue by 1,000 or more, show me Shopify order risk on their latest unpaid orders.
Finance managers
See overdue by group
Get overdue totals split into active, inactive and not in Shopify.
Give me overdue Wave totals grouped by whether the customer is active in Shopify.
How it works
What PopdockAI does when you ask
You set a minimum overdue amount and your AI assistant reads Wave and Shopify. It recommends an approach and never contacts a customer or changes a record.
Ask
You give a minimum overdue amount, or accept the default.
Read
It reads the overdue Wave customers and finds each one in Shopify by email.
Enrich
It pulls recent orders for the largest balances and checks order risk on unpaid ones.
Report
It groups customers by approach, with overdue totals for each group.
What PopdockAI provides
The tools behind the answer
Ready made tools for Wave and one secure connection to your AI tool. No code, no exports.
wave-get-customer
shopify-get-customer
shopify-get-order
shopify-get-order-risk
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
Collection calls that fit the customer
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)
