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

StoreAgent
Reporting & insights recipe

One Report for Affiliates and Loyalty

Puts last month's AffiliateWP and RewardsWP numbers side by side, compares them with the month before and names one change for each program.

WHAT IT DOES read only Looks, never changes anything
TIME SAVED ~40 min vs doing it by hand
REQUIRES
StoreAgentFree plugin · MCP on every plan
+
AffiliateWP AffiliateWP 2.37.0+ · changes need Enable MCP Write Access on
+
RewardsWP RewardsWP 1.6.0+ (free) · changes need Enable MCP Write Access on
Connect your store
THE PROMPT
Give me one report for my affiliate and loyalty programs for last month, compared with the month before. From AffiliateWP: referrals, earnings, unpaid earnings, visits and my top 5 affiliates. From RewardsWP: new and active members, points earned and redeemed, orders that used a reward and their revenue, and completed referrals. Then tell me in plain words what is working, what looks off and one change to test in each program.
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
Give me one report for my affiliate and loyalty programs for last month, compared with the month before…
AffiliateWP: 212 referrals and $6,380 earned, up 18%, with $2,140 unpaid. RewardsWP: 340 new members, 28% of points redeemed and $9,120 from orders that used a reward. Calling:
affiliatewp/get-program-summarydone
affiliatewp/list-top-affiliatesdone
rewardswp/get-program-reportdone
Affiliates are growing and loyalty is flat. Pay the $2,140 owed before month end, and test a bigger friend reward in RewardsWP.
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.

Totals for affiliates and referrals by status, paid and unpaid earnings, and visits, for any date range.
affiliatewp/get-program-summary
Ranks affiliates by earnings for a date range, with their referrals and visits.
affiliatewp/list-top-affiliates
read only
Members, points, redemption rate, rewards revenue, referrals and VIP moves for a period, with the change from before.
rewardswp/get-program-report
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.

+ Write it as a 5 line summary I can paste into Slack.
+ Cover the last 90 days instead.
StoreAgent

PO BOX 4362
Gumdale QLD 4154
Australia

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