SleekView for YITH WooCommerce Affiliates
SleekView reads the YITH affiliate tables joined with wc_orders, rendering affiliate name, commission status, commission amount and order_total as a queryable audit grid inside WP Admin.
♾️ Lifetime License available
Move affiliate commissions out of separate admin tabs and into one table
YITH WooCommerce Affiliates writes clicks, commissions and affiliate profiles into dedicated tables with foreign keys back to wc_orders. The default admin splits them into separate tabs, which is fine for opening a single affiliate and wrong for almost every program-side question about commission status, top affiliates by referred revenue or pending payouts.
SleekView joins the affiliate users table, the commissions table and wc_orders into one dataset, exposing affiliate name, commission status, commission amount, order_total and date_paid as columns. Filter to pending commissions over a payout threshold for a finance review. Sort by referred-order revenue for a leaderboard. Group by commission status to surface every line that needs approval.
The plugin keeps owning the tracking script, cookie logic and payout queue. The table view owns the audit surface, so commissions YITH already records stop hiding inside per-affiliate tabs and become something program managers can actually query.
Workflow
How SleekView surfaces YITH Affiliates data
Point at the affiliate tables
Compose the columns
Filter and sort like a database
Save and gate the view
Sample columns
A typical YITH Affiliates audit view
wp_yith_wcaf_commissions
| Affiliate | Order | Order total | Rate | Commission | Status |
|---|---|---|---|---|---|
| Maya Collins | #18420 | 240.00 | 10% | 24.00 | Pending |
| Pieter Nakamura | #18419 | 120.00 | 10% | 12.00 | Paid |
| Studio Felix | #18415 | 560.00 | 12% | 67.20 | Paid |
| Devi Iturbe | #18411 | 180.00 | 10% | 18.00 | Pending |
| Team Osei | #18402 | 320.00 | 10% | -32.00 | Refunded |
Comparison
Default YITH Affiliates admin vs SleekView
Default YITH Affiliates admin tabs
- Affiliates, clicks and commissions live on separate flat screens
- Top-affiliate ranking by revenue requires a CSV export and a pivot
- Payout-priority queues need a custom query against the commissions table
- Refund-driven adjustments aren't easy to isolate in the default admin
- Per-row commission rate and order_total aren't shown side by side
SleekView
- Affiliate, order and commission joined into one queryable dataset
- Commission status as a real column with badge styling per row
- Filter to pending payouts, a status, an affiliate or an amount threshold
- Saved views per role: program manager leaderboard, finance payout queue, ops audit
- Same dataset the chart view aggregates, so table and dashboard stay in sync
Features
What SleekView gives you for YITH WooCommerce Affiliates
Affiliate leaderboard rows
Sort by referred-order revenue or by lifetime commission to land on the real top-performers list without a separate spreadsheet pass.
Composable commission filters
Stack filters on status, amount, affiliate and date to assemble payout queues, leaderboards or refund-driven adjustment audits from one dataset.
Click outcome inline
Where the plugin records it, the click that converted into a commission joins onto the row so program managers see click-to-sale lineage per line.
Audience
Who uses SleekView for YITH Affiliates
Program managers
Weekly leaderboard filtered to the last quarter, sorted by referred order_total, so outreach and incentive plans use real numbers rather than memory.
Finance
Pending payout queue filtered to status pending above a threshold, exported as CSV with affiliate name, amount and date for the next batch payout.
Affiliate ops
Filter to refund-driven adjustments to spot fraudulent click patterns, with affiliate and order joined on each row for one-screen review.
The bigger picture
Why affiliate commissions deserve a real table
Affiliate programs accumulate clicks, commissions and payouts across long windows, and the YITH admin splits each into its own tab. That layout is right for opening a single affiliate and wrong for the program-side questions program managers actually ask every week: who's earning, what's pending, where do refunds eat margin. SleekView reads the YITH affiliate, commission and order tables as one dataset and renders them as a queryable grid with affiliate name, commission status, amount and order total as real columns.
Filters stack into a single query so the leaderboard, the payout queue and the refund-adjustment audit become one-click views rather than tab-hopping exercises. The plugin keeps owning tracking and payouts, while program managers, finance and ops all get the row-level surface the data always implied.
Questions
Common questions about SleekView for YITH WooCommerce Affiliates
The YITH affiliate tables (affiliate users, clicks log, commissions) joined with wc_orders. SleekView reads them as one dataset. No new tables are introduced and no extra meta is written to the site.
 Yes. The order join uses wc_orders on HPOS installs and wp_posts on legacy ones. The affiliate audit table columns stay the same on either storage backend.
 Pending, paid, on-hold and refunded statuses are a column with badge styling, so saved views can scope to one status or filter across multiple in a single query.
 Yes, where YITH records it. The click that converted into a commission joins onto the row, so program managers see lineage from click to sale to payout in one grid.
 Status edits go through the YITH approval API rather than direct SQL, so plugin hooks observe the writes exactly as they would from the commission detail screen.
 Yes. The chart view and the table view share the dataset, so a status filter or affiliate slice narrows both surfaces. Program managers pivot between row audit and rollup without rebuilding filters.
 Yes. Any filtered cohort exports as CSV with affiliate name, commission amount, related order and date_paid. Useful for batch payout runs and finance handoffs.
 Yes. SleekView paginates results with indexed joins, so programs with hundreds of thousands of commission rows still load the audit grid without timing out admin requests.
 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