New: connect Claude, ChatGPT or Cursor to your WooCommerce store. See how →

StoreAgent
Affiliates & loyalty recipe

Audit Affiliate Coupon Codes

Checks which affiliate coupons bring in sales, which are never used and which look like they leaked onto coupon sites.

WHAT IT DOES read only Looks, never changes anything
TIME SAVED ~35 min vs doing it by hand
REQUIRES BOTH
StoreAgentFree plugin · MCP on every plan
+
AffiliateWP AffiliateWP 2.37.0+ · changes need Enable MCP Write Access on
Connect your store
THE PROMPT
Go through all my affiliates and list the coupon codes that credit each one, with the discount each code gives. For each affiliate with a coupon, show their referrals and visits from the last 90 days, and how many referrals came in with no visit, which usually means the coupon was used. Flag codes that belong to paused or rejected affiliates, codes with no referrals, and affiliates whose coupon referrals are far higher than their link visits. Suggest what to do with each code, but do not change anything.
PASTE INTO ClaudeChatGPTCursor+ any MCP client
WHAT HAPPENS NEXT

What Happens When You Paste It

Your assistant picks the right abilities, pulls live data from your store and does the work. Here’s roughly how the conversation goes.

1
It reads first. Read abilities run straight away, so it’s working from your real catalog, not guessing.
2
It checks with you. Anything that writes to your store stops and asks before it goes ahead.
3
It’s all logged. Every ability call shows up in wp-admin, so you can see exactly what changed.
Claude · connected to your store
yourstore.com · via StoreAgent MCP
Live
Go through all my affiliates and list the coupon codes that credit each one, with the discount each code gives…
41 affiliates have coupon codes. 12 codes had no referrals in 90 days. SAM20 brought 118 referrals with only 9 link visits. Calling:
affiliatewp/list-affiliatesdone
affiliatewp/list-affiliate-couponsdone
affiliatewp/list-referralsdone
affiliatewp/list-visitsdone
SAM20 looks like it is on a coupon site. 2 codes belong to paused affiliates. My suggestion for each of the 41 codes is in the table below.
UNDER THE HOOD

Abilities This Recipe Calls

Make sure these are switched on in your StoreAgent MCP settings. You can turn any of them off at any time.

List affiliates
read only
Lists affiliates with status, rate, group, earnings and referral counts. Filters by status, name, email or date.
From AffiliateWP
affiliatewp/list-affiliates
List an affiliate's coupons
read only
Lists the coupon codes that credit one affiliate and the discount each one gives.
From AffiliateWP
affiliatewp/list-affiliate-coupons
List referrals
read only
Lists commissions with amount, status, affiliate, customer and campaign. Filters by affiliate, status or date.
From AffiliateWP
affiliatewp/list-referrals
List visits
read only
Lists affiliate link visits with landing URL, referrer, campaign and whether they converted. No IP addresses.
From AffiliateWP
affiliatewp/list-visits
MAKE IT YOURS

Tweak It for Your Store

Add one of these to the end of the prompt. Swap anything in [brackets] for your own details.

+ Only check affiliates with more than [number] referrals.
+ Look back [number] days instead of 90.
RELATED RECIPES same job, or the same plugin Browse all recipes
Affiliates & loyalty read only

Loyalty Program Health Check

Tells you if your points program is working: how many points are redeemed, what it costs you and where points come from. Needs Advanced Loyalty Program.
Advanced Coupons ~30 min
Affiliates & loyalty asks first

Save Loyalty Points Before They Expire

Finds customers about to lose their points and gives them a small bonus that keeps their account active. Needs Advanced Loyalty Program.
Advanced Coupons ~25 min
Affiliates & loyalty asks first

Reward Your Top Loyalty Members

Ranks your most loyal customers by points earned and gives them a bonus as a thank you. Needs Advanced Loyalty Program.
Advanced Coupons ~20 min
StoreAgent

PO BOX 4362
Gumdale QLD 4154
Australia

Explore
Resources & Help
Product
Our Brands

© 2026 Rymera Web Co Pty Ltd. All Rights Reserved. ABN 51 604 474 213. Privacy Policy · Terms of Service · Data Processing Addendum · Affiliate Disclosure