Give Your Top Affiliates a Higher Commission Rate with AffiliateWP and AI
Rank affiliates by what they sold, then raise the rate for the ones you pick, with group rates checked first.
Prerequisites
A site connected to WPVibe running AffiliateWP 2.37 or newer (tested on 2.37.1) on WordPress 6.9 or newer, with an administrator account. Changes need AffiliateWP's write access on: Affiliates > Tools > AI MCP > Enable MCP Write Access.
My WordPress site runs AffiliateWP. Find my best affiliates over the last [number, for example 90] days, and give the ones I pick a commission rate of [rate, for example 25]%.
1. Run get_ability_info for each AffiliateWP ability this uses: affiliatewp/get-program-settings, affiliatewp/list-top-affiliates, affiliatewp/get-affiliate, affiliatewp/list-affiliate-groups and affiliatewp/update-affiliate. If one is not found, stop and tell me this needs AffiliateWP 2.37 or newer on WordPress 6.9 or newer. If affiliatewp/update-affiliate shows meta.mcp.public false, AffiliateWP is not letting AI make changes: tell me to switch on Enable MCP Write Access under Affiliates > Tools > AI MCP (I can switch it off again afterwards), and stop.
2. Run affiliatewp/get-program-settings for the default referral_rate and referral_rate_type. Run affiliatewp/list-affiliate-groups for the groups and their rates.
3. Run affiliatewp/list-top-affiliates with status active, number 10 and date {"start": "YYYY-MM-DD", "end": "YYYY-MM-DD"} covering my period up to today.
4. For each, run affiliatewp/get-affiliate for rate, rate_type, has_custom_rate, group_id and group_name. The rate it returns is the one that applies now. Where it comes from: the group, when they are in a group that has its own rate (a group rate replaces the affiliate's own rate); their own rate, when has_custom_rate is true and no group rate applies; otherwise the program default.
5. Show me a table: name, referrals, earnings and conversion rate for the period, the current rate and where it comes from, and your suggestion. Warn me that a personal rate also replaces any product or category commission rates set in WooCommerce for that affiliate. Change nothing yet.
6. Wait for my pick. For each affiliate I pick: if they are in a group with its own rate, their own rate would not apply; tell me and ask whether to take them out of the group (affiliatewp/update-affiliate with group_id 0) or leave them. Then run affiliatewp/update-affiliate with affiliate_id, rate "[rate]" and rate_type percentage. If I ask to move someone into a group instead, use group_id, and first tell me if that group's rate is lower than their current rate.
7. Report each affiliate's old rate and the new rate from the response. New rates apply to referrals from now on; recorded referrals keep their amounts. Note any group you took them out of. To undo: if has_custom_rate was true, run affiliatewp/update-affiliate with the old rate and rate_type; if it was false, with rate "" and rate_type "" so the program default applies again; and put back any group with group_id.
Skip pasting the full prompt. Drop this into your AI on a site that already has WPVibe:
Run the “Give Your Top Affiliates a Higher Commission Rate with AffiliateWP and AI” recipe from the WPVibe cookbook on my connected site.
Your best affiliates earn the same rate as someone who signed up yesterday and never posted. A higher rate for the people who actually sell is the cheapest way to keep them, but finding them means a report, and changing a rate means opening each profile.
The AI ranks your affiliates by what they earned over the period you choose, shows each one’s current rate and where it comes from, and changes the rate only for the people you pick. It warns you when an affiliate group would override the new rate, because in AffiliateWP a group’s rate wins over the affiliate’s own, and that a personal rate in turn replaces any per-product rates for that affiliate.
The new rate applies to referrals from now on; commissions already recorded keep their amounts. The AI reports each old and new rate, so going back is one more message.
Outcome
The affiliates you chose earn the new rate on their next referrals, and you have each old and new rate on record.