Connectors

/

WooCommerce

/

Find refunded WooCommerce customers still in Drip campaigns
Write
Cross-Connector

Stop emailing refunded WooCommerce customers as if nothing happened

For marketers who want recently refunded WooCommerce customers still on Drip email found, and optionally tagged, by their AI assistant.

Try PopdockAI free
Get a live demo
Find refunded WooCommerce customers still in Drip campaigns
Which customers refunded in WooCommerce in the last 14 days are still getting Drip campaigns? Tag them refund-review.
6 customers refunded in the last 14 days are still on active Drip campaigns. - Jordan Lee: refunded 89.00 USD, damaged item, on Welcome series - Contoso Pharma: refunded 240.00 USD, wrong size - Not in Drip: 3 customers - Guest refunds: 2 with no email, left out Shall I tag the 6 active subscribers refund-review?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-refund
drip-get-subscriber
drip-get-campaign-subscriber
drip-add-subscriber-tag

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

WooCommerce

WooCommerce
Run it on your own WooCommerce data.

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

Try PopdockAI free

The problem

Unhappy customers still getting cheerful campaign emails

A WooCommerce refund often signals an unhappy customer, yet Drip keeps sending them the same campaign email. Spotting this means listing refunds, grouping them by customer and checking each person's Drip campaigns by hand.

Without PopdockAI

  • List recent refunds in WooCommerce
  • Group them by customer
  • Check each person's Drip campaigns
  • Tag an unknown email and create a new subscriber

With PopdockAI

  • Refunds are grouped by customer with amounts and reasons
  • Each customer's Drip status, tags and campaigns are checked
  • With a tag, you see who would be tagged first
  • Only active subscribers are tagged, and nobody is removed

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 customers refunded in WooCommerce in the last `{lookback-days}` days (default 14) who are still receiving Drip campaigns, and tag them with `{tag}` in Drip if a tag is given and the user confirms.

**Step 1: List recent refunds**

Call `woocommerce-get-refund` with `created-date.from` set to today minus `{lookback-days}` days and `max-records` set to 200. Group by customer email: refund count, total refunded per currency, reasons, and the order numbers.

**Step 2: Check each refunded customer in Drip**

For each email, call `drip-get-subscriber` with `email` set to it, and `drip-get-campaign-subscriber` with the same `email`. Note their Drip status, tags and every campaign whose campaign status is active.

**Step 3: Report**

List refunded customers who are active Drip subscribers and still in at least one active campaign: email, total refunded, reasons, and the campaigns. Then give counts for refunded customers who are unsubscribed, not in Drip, or in no active campaign.

**Step 4: Tag (only if a tag was given)**

If `{tag}` is blank, stop after the report. Otherwise show who would be tagged and ask the user to confirm. On a clear yes, call `drip-add-subscriber-tag` once per confirmed active subscriber with `email` and `tag` set to `{tag}`, skipping anyone who already has it, then report tagged, failed and skipped.

**Rules & Guidelines:**

* Tools whose names start with drip- are on the drip server; tools whose names start with woocommerce- are on the woocommerce server. Both servers must be connected.
* Match people across the two systems by email, compared case-insensitively with surrounding spaces removed. Drip uses `email`; WooCommerce uses `email` on customers and `customer-email` on orders, order lines and refunds.
* Compute dates as today minus the stated number of days and pass them as YYYY-MM-DD.
* The only write allowed is `drip-add-subscriber-tag`, for active Drip subscribers only, after the user confirms in Step 4, and only when `{tag}` is given.
* Do not remove anyone from a campaign or unsubscribe them. Do not call `drip-remove-subscriber-from-campaign`, `drip-remove-subscriber-from-all-campaigns` or `drip-unsubscribe-subscriber`; recommend them in the report if they fit, and leave the decision to the user.
* Never tag emails that are not in Drip; tagging an unknown email creates a new subscriber.
* Make no changes in WooCommerce. Do not call `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-update-order`, `woocommerce-add-order-note`, `woocommerce-add-coupon` or `woocommerce-add-refund`.

**Validation:**

* If there were no refunds in the period, say so and stop.
* A refund with a blank customer email is a guest order; count it and leave it out.
* Never add amounts in different currencies together; total each currency separately.

Who it's for

One answer, three teams that use it

Customer support leads

Protect unhappy customers from more email

See refunded customers still in active campaigns with the refund reason, so you can step in.

Which customers refunded in WooCommerce this month are still in active Drip campaigns?

Email marketers

Tag refunds for your workflows

Tag refunded active subscribers so your Drip rules can treat them differently.

Tag customers refunded in WooCommerce in the last 30 days as refunded in Drip.

Retention managers

Plan a recovery message

Refund amounts and reasons per customer help you decide who needs a personal follow-up.

List WooCommerce refunds from the last 7 days with the customer's Drip campaigns.

How it works

What PopdockAI does when you ask

You give a lookback period, and your AI assistant finds refunded customers still on active Drip email. If you ask for a tag it waits for your confirmation, and it never unsubscribes anyone.

01

Ask

You give a lookback period and, optionally, a tag.

Your AI tool

02

Read

It groups recent refunds by customer with amounts and reasons.

woocommerce-get-refund

03

Check

It looks up each customer's Drip status, tags and active campaigns.

drip-get-subscriber
drip-get-campaign-subscriber

04

Confirm

You see who would be tagged, then only active subscribers are tagged.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for WooCommerce and one secure connection to your AI tool. No code, no exports.

get-data

woocommerce-get-refund

Returns WooCommerce refunds with amount, reason, who made them and whether the gateway returned the money. Filter by order, customer, amount range and date range.
get-data

drip-get-subscriber

Returns Drip people (subscribers) with name, email, location, tags, status, GDPR consent, lead score and lifetime value. Filter by exact email, email domain, tag, status, country, minimum lead score, minimum lifetime value or date added.
get-data

drip-get-campaign-subscriber

Returns the people subscribed to each Drip email series campaign, with the campaign's status and the person's tags and lead score. Filter by campaign id or name, a person's email, subscriber status or minimum lead score.
run-action

drip-add-subscriber-tag

Applies a tag to a Drip subscriber identified by email address. Creates the tag if it does not exist.
Read only.Nothing in WooCommerce 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

Refunded customers visible before the next email goes

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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