Connectors

/

Wave

/

Review overdue Wave customers with Shopify activity
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Review overdue Wave customers with Shopify activity
Show me Wave customers who are overdue by at least 500 and what they have been buying in Shopify, so I know how to chase them.
14 Wave customers are overdue, USD 21,300.00 in total. - Active buyer, chase gently: 6, USD 8,900.00 - No recent store activity, chase firmly: 5, USD 9,700.00 - Not in Shopify: 3, USD 2,700.00 - Risk note: Contoso has an unpaid order with a high risk level Want the table of the 6 active buyers with their latest orders?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
shopify-get-customer
shopify-get-order
shopify-get-order-risk

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Wave

Wave
Run it on your own Wave data.

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

Try PopdockAI free

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.

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

Your AI tool

Read

It reads the overdue Wave customers and finds each one in Shopify by email.

wave-get-customer
shopify-get-customer
shopify-get-order
shopify-get-order-risk

Enrich

It pulls recent orders for the largest balances and checks order risk on unpaid ones.

No items found.

Report

It groups customers by approach, with overdue totals for each group.

Your AI tool

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.

get-data

wave-get-customer

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

shopify-get-customer

Returns Shopify customers with their account state, total spent and default address. Filter by name, email, tags, customer id, city, province, created date and total spent.
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-order-risk

Returns the fraud risk assessments on Shopify orders, with the risk level, recommendation and provider. Filter by order, risk level, recommendation and provider.
Read only.Nothing in Wave 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

Collection calls that fit the customer

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