/
/
Rank overdue Wave customers by their live 2Checkout subscriptions
For finance teams who want to chase overdue customers in a sensible order by asking their AI assistant to check 2Checkout subscriptions.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
You cannot tell who to chase first
Overdue customers look alike in Wave, and nothing shows who still holds a live subscription in 2Checkout. The chase order ends up as guesswork or takes hours of cross-checking.
Without PopdockAI
- List overdue customers in Wave
- Search 2Checkout for each email
- Check each subscription status and expiry
- Rank the customers by hand
With PopdockAI
- Overdue customers are listed and sorted by amount
- Subscriptions are found by email only, never by guessing names
- Customers are grouped by subscription status
- Actions are recommended in words 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.
**Objective:** List Wave customers (server wave-ai) whose overdue amount is at least `{min-overdue}` (default 0.01) and show what each holds in 2checkout (server 2checkout). Read-only.
**Step 1: Overdue customers in Wave**
Call `wave-get-customer` with `overdue-amount.min` set to `{min-overdue}` (or 0.01 if empty); add `company` when `{wave-company}` is given. Keep `name`, `email`, `currency-code`, `overdue-amount`, `outstanding-amount`.
**Step 2: Subscriptions in 2checkout**
For each customer with an email, call `2checkout-get-subscription` with `end-user-email` set to that email. Keep `subscription-reference`, `product-name`, `status`, `expiration-date`, `subscription-enabled`. If it returns nothing, call `2checkout-get-customer` with the same `email` to tell "not a 2checkout customer" from "customer with no subscriptions". For a customer with subscriptions you may call `2checkout-get-subscriptionrenewalprice` with `subscription-reference` to show the next renewal price. Customers with no email: list them as "cannot be matched".
**Step 3: Report**
Table sorted by overdue amount, largest first: customer, currency, overdue amount, number of active subscriptions, nearest `expiration-date`, next renewal price. Group customers into "overdue with active subscription", "overdue, subscriptions ended" and "overdue, not in 2checkout". Do not total across currencies.
**Rules & Guidelines:**
* `wave-get-customer` is on wave-ai; `2checkout-get-subscription`, `2checkout-get-customer` and `2checkout-get-subscriptionrenewalprice` are on 2checkout.
* Read-only. Do not call `2checkout-subscription-disable`, `2checkout-subscription-disablerecurring`, `2checkout-subscription-canceldeal`, `2checkout-subscription-extend` or any other 2checkout action, and no Wave send, update or delete tool. Recommend actions in words only.
**Validation:**
* Match on email only; do not guess by name.
* If no customer is overdue, say so and stop.
* Warn when a result may be truncated by `max-records`.Who it's for
One answer, three teams that use it
Collections teams
Start with customers who still hold a live subscription
Prioritise calls using overdue amount and subscription status instead of guessing.
Rank overdue Wave customers over 500 by whether they have active 2Checkout subscriptions.
Finance managers
See subscription revenue at risk
Review overdue customers alongside their next renewal price to judge how much is at stake.
Show overdue customers in Wave with their active 2Checkout subscriptions and next renewal price, company Northwind Traders.
Account managers
Know which customers to raise with before renewal
See customers who owe money and have subscriptions expiring soon so you can raise it first.
Which overdue Wave customers have a 2Checkout subscription expiring in the next 60 days?
How it works
What PopdockAI does when you ask
You set the overdue threshold and your AI assistant reads Wave, then 2Checkout. It only reads, and it never cancels or extends a subscription.
Ask
You set a minimum overdue amount and the Wave company if needed.
Collect
It lists overdue Wave customers with their email and amounts.
Check
It finds each customer's 2Checkout subscriptions by email and can show the next renewal price.
Report
It sorts by overdue amount and groups customers by subscription status.
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
2checkout-get-subscription
2checkout-get-customer
2checkout-get-subscriptionrenewalprice
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
A chase order based on real subscription risk
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)
