SleekView for Solid Affiliate
Solid Affiliate splits affiliates, referrals, visits, creatives, and payouts across five custom tables. SleekView joins them so commissions, conversion rate, and tier sit beside each affiliate in one row.
♾️ Lifetime License available
Solid Affiliate splits affiliates and commissions across screens
Solid Affiliate ships with its own affiliate program schema: wp_sa_affiliates for partners, wp_sa_referrals for conversions, wp_sa_visits for click data, wp_sa_creatives for assets, and wp_sa_payouts for batch payments. The plugin's admin gives a focused screen for each, which is fine for browsing one slice but means cross-table reporting like commissions per affiliate this month requires raw SQL or a third-party reporting plugin.
SleekView reads the five tables and presents one row per affiliate with tier, 30-day commissions, conversion rate computed from visits and referrals, and current status. Inline edits to commission rates or status call Solid Affiliate's update functions so any commission recalculation, tier hook, or webhook fires the same way the native edit screens fire it. The visits and referrals tables stay read-only from this view.
That layout makes the program legible. Iris Tanaka at Platinum tier earning $2,140 with 6.2% conversion sits beside Cassidy Bloom at Bronze with $0 commissions and 0% conversion. Sort by 30-day commissions to find rising partners, filter to a tier to plan promotions, or export the full snapshot for finance review without writing a single SELECT.
Workflow
How SleekView joins Solid Affiliate tables
Read affiliates
Roll up referrals
Compute conv. rate
Edit and pay out
Sample columns
Affiliates and commissions
wp_sa_affiliates / wp_sa_referrals
| Array | Array | Array | Array | Array | Array |
|---|---|---|---|---|---|
| 204 | Iris Tanaka | Platinum | $2,140 | 6.2% | Array |
| 228 | Beni Ortiz | Gold | $880 | 3.8% | Array |
| 262 | Hana Eklund | Silver | $104 | 1.1% | Array |
| 284 | Cassidy Bloom | Bronze | $0 | 0.0% | Array |
Comparison
Solid Affiliate default vs SleekView
Solid Affiliate default
- Commissions and affiliates live on different admin screens
- Cannot filter affiliates by conversion rate inline
- No bulk way to mark referrals as paid in batches
- Tier changes require opening each affiliate profile
- 30-day rollups need separate exports and a spreadsheet
SleekView
- Commissions and conversion side by side
- Filter to a tier or status in a click
- Inline edit commission rates per affiliate
- Sort by 30-day commissions to find top performers
- Export the program snapshot as CSV
Features
What SleekView gives you for Solid Affiliate
Commission rollups
Surfaces 30-day commissions next to each affiliate by aggregating wp_sa_referrals server-side, so payout decisions and tier reviews stop needing exports.
Tier filter
Toggle by tier (Bronze, Silver, Gold, Platinum) or status to focus on the affiliates that matter for this week's promotion campaign or fraud review.
Inline payouts
Mark referrals as paid in bulk straight from the table. Writes hit wp_sa_payouts through Solid Affiliate's standard payout functions, so accounting hooks still fire.
Audience
Where Solid Affiliate managers use SleekView
Tier promotions
Spot Bronze affiliates close to Silver thresholds by sorting commissions descending within tier. Promote in one click instead of an export-and-spreadsheet pass.
Payout batches
Filter to unpaid commissions, select the batch, mark paid. The same wp_sa_payouts writes the native UI does happen, so PayPal Mass Pay or manual exports still work.
Compliance review
Export tier, commissions, conversion rate, and status snapshots quarterly. Hand to finance as one CSV instead of running custom SQL against the affiliate tables.
The bigger picture
Why tiered affiliate programs need pivot views
Tiered programs work only when you can see who is close to the next tier. Solid Affiliate supports Bronze, Silver, Gold, and Platinum out of the box, but the native admin shows tier as a static field on the affiliate record with no built-in view of cumulative commissions across the cohort. So promotions become a quarterly export-and-spreadsheet ritual where you join referrals to affiliates by hand to find the partners earning $1,800 against a $2,000 Gold threshold.
Compliance review is worse: finance asks for last quarter's commission per affiliate and the answer requires SQL or a plugin add-on. SleekView puts tier, 30-day commissions, conversion rate, and status in one sortable view, so promotions become 'sort by commissions descending, filter to Bronze, manually promote.' Inactive affiliates with zero conversion across 30 days surface for re-engagement campaigns. Suspicious patterns (high commissions but Bronze tier, or zero conversion at high visit volume) stand out without writing a query, which is the difference between active program management and rubber-stamping last quarter's tiers.
Questions
Common questions about SleekView for Solid Affiliate
No. Solid Affiliate's native reports keep working. SleekView complements them with a sortable, filterable cross-table view that the native admin doesn't offer. Use the native screens for per-referral detail and SleekView for the program-wide rollup. Most teams use both, depending on the task.
Yes. Solid Affiliate's WooCommerce integration writes referral and commission data into the same wp_sa_referrals table whether the program tracks WooCommerce orders, Easy Digital Downloads, or manual conversions. SleekView reads the table directly, so WooCommerce-tied referrals surface as columns alongside the affiliate row.
Yes. The per-affiliate commission rate on wp_sa_affiliates is editable in place. Inline edits call Solid Affiliate's update_affiliate function so subsequent referrals use the new rate. Existing referral records keep the rate they were created at, matching the native UI behavior.
Yes. Recurring referrals are stored with a parent referral ID in wp_sa_referrals, and SleekView surfaces both the original conversion and recurring rows. Filter by referral type to separate one-off commissions from recurring revenue, useful for SaaS affiliate programs where lifetime value matters more than the first sale.
Yes. Any filtered view exports to CSV with the columns you've selected: tier, commissions, conversion rate, status, last referral date, payout state. Common exports: monthly finance review, quarterly tier promotion list, suspended affiliate cleanup, or a full snapshot for an external reporting tool.
No. SleekView only renders in WP Admin and never affects the front-end affiliate tracking pixel or referral creation path. Aggregations are computed via indexed SQL on the Solid Affiliate tables, so even programs with thousands of affiliates stay responsive in the table view.
Yes. wp_sa_creatives links banners and text creatives to affiliate use. SleekView can include a column showing how many creatives an affiliate has used, useful for spotting partners running stale assets or for assigning new creatives to top performers.
Solid Affiliate supports affiliate groups with shared commission settings. SleekView surfaces the group as a filter so you can roll up commissions per group, compare group performance, and adjust group-level rates without opening each affiliate's profile or running a manual aggregate query.
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