SleekView for SliceWP
SliceWP records affiliates, referrals, visits, and payouts in four custom tables. SleekView joins them so a single row shows the affiliate, their 30-day referrals, and earnings without screen-hopping.
♾️ Lifetime License available
SliceWP scatters program data across custom tables
SliceWP runs an affiliate program on top of WordPress with its own schema: wp_slicewp_affiliates for the partner, wp_slicewp_referrals for each conversion, wp_slicewp_visits for click tracking, and wp_slicewp_payments for payouts. The native admin gives a focused list per table, which works for browsing one slice but breaks when you want a 30-day rollup beside the affiliate name. Reconciling means matching IDs in your head.
SleekView reads all four tables and presents one row per affiliate with referrals, earnings, last-referral timestamp, and current status pulled from each source. Inline status changes call the same SliceWP hooks the default UI uses, so commission webhooks and payout reminders still fire. Filters by status surface suspended affiliates instantly instead of letting them blend in with the active list at a glance.
That layout matches how program managers actually work. Mara Choi at 18 referrals and $642 sits at the top, Sasha Khan at 1 referral and $28 in pending payout sits in the middle, and Riley West at zero referrals since December sits in suspended. One sortable view replaces three admin screens, so the weekly review takes minutes instead of an export-and-pivot.
Workflow
How SleekView joins SliceWP program data
Pull affiliates
Roll up referrals
Add payout state
Edit and approve
Sample columns
Affiliates and referrals
wp_slicewp_affiliates / wp_slicewp_referrals
| Array | Array | Array | Array | Array | Array |
|---|---|---|---|---|---|
| 128 | Mara Choi | 18 | $642 | 2026-04-23 | Array |
| 144 | Jonas Berg | 9 | $310 | 2026-04-22 | Array |
| 162 | Sasha Khan | 1 | $28 | 2026-04-04 | Array |
| 188 | Riley West | 0 | $0 | 2025-12-30 | Array |
Comparison
SliceWP default vs SleekView
SliceWP default
- Affiliates, referrals, and visits each on a separate admin screen
- No inline view of 30-day earnings beside the affiliate list
- Cannot filter affiliates by referral count without SQL
- Bulk approving referrals means clicking through each row
- Suspended affiliates blend in with the active list at a glance
SleekView
- Affiliates, referrals, and earnings on one row each
- Filter to suspended or pending payouts instantly
- Inline approve or reject referrals
- Sort by 30-day referrals to find rising affiliates
- Export the affiliate report as CSV
Features
What SleekView gives you for SliceWP
Affiliate plus referrals
Joins wp_slicewp_affiliates with wp_slicewp_referrals so each row shows the partner, their 30-day conversion count, total earnings, and the last referral timestamp.
Earnings column
Surfaces 30-day earnings beside each affiliate so payout decisions, tier promotions, and finance reviews stop requiring a separate report export.
Status filter
Toggle between active, pending, and suspended in one click. Suspended affiliates stand out instead of blending into a column you never sort by.
Audience
Where SliceWP managers use SleekView
Top affiliate review
Sort by 30-day referrals to surface rising partners. Mara at 18 conversions gets the outreach email, the affiliates with 0 referrals get the re-engagement nudge.
Payout prep
Filter to pending payouts, mark them paid inline, and the same wp_slicewp_payments writes happen as in the native UI, so accounting integrations still receive events.
Fraud cleanup
Spot affiliates with suspicious patterns (one $0 referral pattern, identical IPs across visits) and suspend them on the spot without leaving the table.
The bigger picture
Why affiliate programs need cross-table views
Affiliate programs scale through visibility. Once you have 50 partners, you cannot remember who drove 18 referrals last month and who has been silent since December. SliceWP captures all of it: visits, conversions, commission, payout state.
The admin just splits each fact across a different screen, and the bigger the program, the more taps you need to answer a basic question like which affiliates are about to hit a payout threshold. Worse, suspended or fraudulent affiliates blend visually with active ones in the affiliates list because status is one column among many. SleekView puts the affiliate, their 30-day referrals, their earnings, and their current status side by side.
Suspended rows stand out in red. Pending payouts cluster under one filter. Top performers sort to the top with one click.
For programs running flash promotions, end-of-month payout batches, or fraud reviews, that one view turns reconciliation from a multi-tab spreadsheet exercise into a focused twenty-minute pass through the table.
Questions
Common questions about SleekView for SliceWP
No. It reads from wp_slicewp_affiliates, wp_slicewp_referrals, wp_slicewp_visits, and wp_slicewp_payments and only writes when you inline edit. All writes go through the same SliceWP update functions the default UI uses, so commission webhooks, MailPoet integrations, and any custom hooks keep firing as expected.
Yes. SliceWP Pro features like recurring commissions, lifetime referrals, and tiered rates add columns to the same tables. SleekView surfaces those columns automatically, so you can filter by recurring vs one-off referrals or sort by lifetime earnings without any extra configuration.
Yes. Inline status changes (pending to approved, approved to rejected) call slicewp_update_referral_status, the same function SliceWP's per-referral edit screen uses. Commission emails, affiliate notifications, and downstream hooks fire identically. The native admin keeps working unchanged in parallel.
Yes. Payout records from wp_slicewp_payments appear as a filterable column with status (pending, paid, rejected) and total amount. Marking a payment paid inline writes back through SliceWP's payment functions so any payout method (PayPal, Stripe, manual) handles it the same way.
Yes. Any filtered view exports to CSV with the columns you've configured. Common exports: monthly payout batches, top 50 affiliates by 30-day earnings, suspended affiliates with last referral date for cleanup, or a full snapshot for finance reconciliation.
No. SleekView paginates and lazy-loads rows, so even programs with thousands of affiliates and hundreds of thousands of referrals stay responsive. Aggregations are computed via SQL on the SliceWP tables directly rather than loading all rows into PHP, which is what makes the cross-table view fast.
Yes. The per-affiliate commission rate stored on wp_slicewp_affiliates appears as an editable column. Inline edits write back through SliceWP's affiliate update path so subsequent referrals use the new rate immediately. Useful for rewarding top performers without opening each affiliate profile.
Yes. wp_slicewp_visits totals (clicks per affiliate, conversion rate computed from visits and referrals) appear as columns. Sort by conversion rate to find affiliates driving traffic but not converting, or by raw visits to spot the highest-volume partners.
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.
Lifetime ♾️
Most popular
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
€749
Continue to checkout