✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

SleekView for AffiliateWP: affiliates, referrals & payouts as tables

Read directly from affiliate_wp_affiliates, affiliate_wp_referrals, and affiliate_wp_visits. Filter pending referrals, bulk-update status after payouts, rank affiliates by unpaid earnings — all in one screen.

♾️ Lifetime License available

SleekView table view for AffiliateWP

Affiliate ops without per-record clicks

AffiliateWP stores affiliates, referrals, visits, and payouts in dedicated tables: affiliate_wp_affiliates, affiliate_wp_referrals, affiliate_wp_visits, and affiliate_wp_payouts. The default admin gives separate screens for each, with per-row status changes and limited cross-table joins. SleekView reads all four together so payout admins, affiliate managers, and fraud auditors each get the workspace their job actually needs.

The biggest time-saver is bulk-updating referral status. Filter every unpaid referral before a payout cycle, run the actual payouts in PayPal or Stripe, then bulk-set status = paid in SleekView in one action — no per-row clicks across hundreds of referrals. Affiliate ranking by unpaid_earnings, earnings, or referrals count becomes a sort, not a script. Cross-referencing visits with referrals to spot suspicious traffic ratios is one filtered view away.

Custom integrations that create referrals through AffiliateWP's API land in affiliate_wp_referrals like any other source, so the type field (Sale, Lead, Opt-In introduced in v2.2) and any custom data are visible automatically. Inline status edits route through the AffiliateWP CRUD layer where supported, so paid, rejected, and unpaid hooks fire normally for downstream integrations.

Workflow

From per-screen affiliate admin to unified workspace

1

Read the four tables

Affiliates, referrals, visits, payouts — all visible. SleekView joins users for affiliate emails so you don't see raw user IDs in referral rows.
2

Filter and rank

Filter referrals by type + status + date, sort affiliates by unpaid_earnings, find high visits/referrals ratios in one go.
3

Bulk-update post-payout

After PayPal or Stripe payouts run, filter to all unpaid referrals you just paid and bulk-flip status = paid — one action, hundreds of rows, hooks fire normally.
4

Save views per role

Payout admins see the unpaid queue, affiliate managers see leaderboards, fraud auditors see ratio outliers — same database, three workspaces, gated by capability.

Sample columns

A typical AffiliateWP referrals view

Joins affiliate_wp_referrals with affiliate emails. Status, type, and amount are inline-editable.
Source: wp_affiliate_wp_affiliates + wp_affiliate_wp_referrals + wp_affiliate_wp_visits + wp_affiliate_wp_payouts
Ref # Affiliate Type Amount Status Date
#820 alex@studio.co Sale $24.00 Unpaid Apr 24
#819 ria@design.io Sale $48.00 Paid Apr 24
#818 tom@hello.dev Lead $5.00 Unpaid Apr 23
#817 mia@brew.coop Opt-In $2.00 Pending Apr 23

Comparison

Default AffiliateWP admin vs SleekView

Default AffiliateWP admin

  • Referral status changes go one row at a time in the default admin
  • Cross-table joins (referrals + affiliate email) aren't visible in the list view
  • Filtering by type, status, and date together isn't a saved view
  • Affiliate ranking by unpaid_earnings requires sorting and re-sorting manually
  • Visits and payouts live in separate screens

SleekView

  • Read from all four tables: affiliates, referrals, visits, payouts
  • Bulk-update referral status from unpaid to paid after a payout
  • Rank affiliates by unpaid_earnings in one sortable column
  • Filter referrals by type + status + date together
  • Save named views per workflow (payout queue, fraud audit, top performers)

Features

What SleekView gives you for AffiliateWP

Bulk-update payout status

Filter to all unpaid referrals before a payout cycle, then bulk-set status = paid in one action — no per-row clicks across hundreds of referrals after the actual payouts run.

Affiliate leaderboards

Sort affiliate_wp_affiliates by earnings, unpaid_earnings, or referrals count to find top performers and stalled accounts. Filter to recent activity for monthly performance reviews.

Fraud audit views

Cross-reference referrals with visits — filter for high visits/referrals ratios that suggest invalid traffic, or zero-visit-but-many-referrals patterns that suggest API abuse.

Audience

Who uses SleekView for AffiliateWP

Payout admins

All unpaid referrals in one view, ready to bulk-flip to paid after PayPal or Stripe payouts process. Eliminates the per-row click marathon at every cycle.

Affiliate managers

Affiliate leaderboards by status, earnings, and recruitment count — without exporting reports. Monthly performance review becomes a saved view, not a recurring task.

Fraud auditors

Visit-to-referral ratio audit and rejected-referral history in one filterable table. Catch invalid-traffic patterns before they get paid out and become disputes.

The bigger picture

Why affiliate ops break in per-record admins

Affiliate programs scale or die on operational efficiency. A 50-affiliate program is fine in any admin; a 5,000-affiliate program with monthly payout cycles is ruined by per-row clicks. Each payout cycle, someone has to identify all unpaid referrals for the period, calculate amounts owed per affiliate, run actual payouts through PayPal or Stripe, then mark each referral paid — the last step alone can take hours of tedious clicking in the default admin.

Fraud detection adds another layer: without easy cross-referencing of visits to referrals, invalid traffic gets paid out before anyone catches the pattern. Affiliate managers running performance reviews want a leaderboard sorted by recent earnings, not a multi-screen drilldown. SleekView turns AffiliateWP's relational schema into the workspace each role actually uses: a payout queue with bulk status updates, a leaderboard sorted by any aggregate column, a fraud-audit view with visit-to-referral ratios, and a per-affiliate detail view that shows referrals, visits, and payouts together.

Same data, same hooks, hours per cycle reclaimed.

Questions

Common questions about SleekView for AffiliateWP

No — it complements them. AffiliateWP's reports give aggregates and graphs (referrals over time, earnings by affiliate). SleekView gives you the row-level workspace for triage, payouts, and audits — the day-to-day operational use that needs filterable tables, not summary charts. Most teams keep both: reports for monthly review, SleekView for daily ops.

 

Yes. SleekView writes through AffiliateWP's CRUD layer where supported, so status-change hooks (paid, rejected, unpaid) fire normally. Bulk operations iterate per row through the same path so any integrations listening — PayPal payouts, accounting webhooks, custom email notifications — run as if a human had clicked through each one.

 

Any integration creating referrals via AffiliateWP's API lands in affiliate_wp_referrals, so SleekView sees them automatically — including the type field (Sale, Lead, Opt-In) added in v2.2. Custom integration data stored in affiliate_wp_referralmeta appears as filterable columns. Saves rebuilding admin tooling for each new integration.

 

Yes — affiliate_wp_visits is exposed as a separate view, joinable to affiliates and referrals for fraud-detection workflows. The visit row includes URL, referrer, IP, and user agent (where AffiliateWP captured them), so you can build country-level or referrer-pattern audit views to spot click farms or bot traffic before they convert.

 

Yes. Save views and gate them by WordPress capability — payout admins see one set of columns (unpaid queue, payout history), affiliate managers see another (leaderboards, recruitment), fraud auditors see a third (ratio audit, rejected-referral history). One database, role-specific workspaces, no rebuilding per environment.

 

Yes — SleekView reads from the current site's affiliate_wp_* tables, so each subsite gets its own scoped view. Useful when an agency runs separate affiliate programs per client subsite. Cross-site aggregations aren't supported (each subsite has independent data) but per-site dashboards behave as expected.

 

Add-ons that store data in their own tables can be exposed through additional SleekView views, joinable back to affiliate_wp_affiliates by affiliate id. Lifetime Commissions in particular benefits from a customer-to-affiliate mapping view; Direct Link Tracking benefits from a URL-pattern audit view. Schema specifics depend on which add-on versions you run.

 

Yes. Any SleekView view exports to CSV or JSON, including joined columns. The standard bookkeeping export is something like "all paid referrals from last month with affiliate email, amount, and reference" — that's a saved view plus an export click. Better than running custom SQL each cycle when bookkeeping needs a fresh dataset.

 

Pricing

More than 1000+
happy customers

Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

EUR

once

  • Unlimited websites
  • Lifetime updates
  • Lifetime support

...or get the Bundle Deal
and save €250 🎁

The Bundle (unlimited sites)

Pay once, own it forever

Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.

What’s included

  • SleekAI

  • SleekByte

  • SleekMotion

  • SleekPixel

  • SleekRank

  • SleekView