Affiliate Royale (now bundled into MemberPress as the affiliate add-on) stores its data in custom tables: mepraff_affiliates holds one row per affiliate with status, balance, payout method, and signup metadata, while mepraff_transactions records every commission with linked mepr_transaction_id referring back to the parent MemberPress sale. Payouts are recorded as rows on mepraff_transactions with a payout-specific status.

The default Affiliate Royale admin gives Affiliates, Commissions, and Payouts separate screens. Asking which active affiliates have unpaid commission above the payout threshold, sorted by lifetime referred revenue, means jumping screens or running custom SQL. Approval queues for new affiliates live in a different screen from the commission ledger, and tying each commission back to the originating MemberPress transaction requires opening each commission individually.

SleekView reads both Affiliate Royale tables and joins them to mepr_transactions via mepr_transaction_id so a single affiliate-centric view shows lifetime referred revenue, pending commission, last commission date, and last payout. Status edits route through Affiliate Royale's PHP class where supported, with direct table writes available for bulk migrations.

Affiliate programmes inside MemberPress only work when payouts run on schedule and the operational queue is one screen, not three. Which active affiliates have pending commission above the payout threshold this cycle. Which pending affiliates have already referred a paying sale and should be approved.

Which disabled affiliates still have unpaid commission to resolve. Affiliate Royale stores all the data to answer those questions, but its default admin keeps affiliates, commissions, and payouts on separate screens, which means the operational question always involves cross-screen reconciliation. SleekView's joined view collapses the three tables into one workspace with parent MemberPress transactions joined inline so each row is an affiliate with referred revenue, pending commission, last activity, and last payout visible at once.

Finance teams get a payout batch ready for export, affiliate managers get an approval queue with first-referral context, and growth teams get the lifetime-referred leaderboard. The data was always there. The joined workspace just makes it the default view.