✨ 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 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

SleekView table view for YITH WooCommerce Affiliates

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

1

Point at the affiliate tables

Pick the YITH affiliate users table joined with the commissions table and wc_orders, exposing affiliate display_name, commission status, commission amount and order_total.
2

Compose the columns

Drag in Affiliate, Order, Order total, Commission rate, Commission amount, Status and date_paid. Reorder, hide or rename any column without writing a custom report.
3

Filter and sort like a database

Filter to pending commissions, to a specific affiliate or to commissions above a payout threshold. Sort by commission_amount for a payout-priority queue.
4

Save and gate the view

Name the view ("Pending payouts over 50", "Top affiliates this quarter", "Refund-driven adjustments") and gate by capability so program managers, finance and the affiliate ops team each land on the right slice.

Sample columns

A typical YITH Affiliates audit view

Commission rows joined with affiliate display_name and the originating wc_order. The same data scattered across affiliates, commissions and orders tabs, surfaced as a queryable cross-program audit grid.
Source: 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.

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