✨ 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 WooCommerce Referrals: referrers and conversions as tables

Referrals stores referrers, codes, and conversions in custom tables and links each conversion to a shop_order. SleekView joins them so a single row shows referrer, code, conversions, revenue, and the last referred order.

♾️ Lifetime License available

SleekView table view for WooCommerce Referrals

Referrers, codes, and conversions on one grid

WooCommerce Referrals persists referrers in wp_wc_referrals_referrers, codes in wp_wc_referrals_codes, and individual conversion rows in wp_wc_referrals_conversions with the originating order_id. The default admin separates referrer profiles from conversion logs and gives no straightforward way to ask "which referrer drove the most revenue last 30 days".

SleekView reads the three tables and joins them on referrer_id with conversion aggregates rolled up per referrer: total conversions, total referred revenue, and the date of the most recent referred order. Filter the grid by code_status to see active versus disabled codes, sort by referred revenue to find the top affiliates, or filter conversions per the last 30 days for a recent-performance snapshot.

Bulk operations let you disable a code that is being abused, approve pending conversions in a batch when a fraud review concludes, or adjust commission rates per referrer. Each edit routes through the plugin's wc_referrals_update_* filters where present, so payout calculations and notification emails still fire correctly downstream.

Workflow

Referrer performance, joined and editable

1

Connect the tables

Point SleekView at wp_wc_referrals_referrers, joined to wp_wc_referrals_codes on referrer_id and to a rollup query on wp_wc_referrals_conversions.
2

Add behavior columns

Layer total conversions, referred revenue last 30 days, last conversion timestamp, and a computed days_since_last_conversion column for the going-cold filter.
3

Save segment views

Persist views for Top referrers (30 days), Paused codes, Pending conversions, and Disabled cleanup. Each is scoped per role for affiliate managers, finance, and fraud.
4

Edit inline and approve

Edit commission rates inline through wc_referrals_update_referrer, and bulk-approve pending conversions when fraud review concludes. Every action is logged with the operator.

Sample columns

A typical referrer view

Referrers with code, status, total conversions, referred revenue, and last referred order.
Source: wp_wc_referrals_referrers + wp_wc_referrals_codes + wp_wc_referrals_conversions
Referrer Code Status Conversions Revenue Last Order
alex@studio.co ALEX10 active 42 €3,820 Apr 24
ria@design.io RIA15 paused 11 €940 Mar 02
tom@hello.dev TOMVIP active 127 €12,410 Apr 25
mia@brew.coop MIA20 disabled 3 €210 Jan 17

Comparison

Default WooCommerce Referrals admin vs SleekView

Default WooCommerce Referrals admin

  • Referrers and conversions live on separate screens
  • No combined filter on code_status plus last_conversion_at
  • Bulk approval of pending conversions not exposed in the UI
  • No CSV export of top referrers by revenue with active filters
  • No view of commission rate per referrer next to performance

SleekView

  • Referrer joined to wp_wc_referrals_codes and conversion rollups
  • Sort by referred revenue last 30 days for top-affiliate views
  • Inline commission edits routed through wc_referrals_update_referrer
  • Bulk approve pending conversions when fraud review concludes
  • Saved views for paused-code recovery and disabled-code cleanup

Features

What SleekView gives you for WooCommerce Referrals

Referrer rollups

Each row shows the referrer, the active code, total conversions, total referred revenue, and the date of the most recent referred order. The aggregate is computed off wp_wc_referrals_conversions with the join already done.

Status filters

Filter on code_status for active, paused, disabled, and expired. Combine with revenue and last-conversion-date filters to build the cohort the affiliate manager actually needs.

Bulk approvals

Conversions awaiting fraud review surface in a Pending saved view. Select rows and approve them in one action; payouts route through the plugin's commission calculation and email the referrer correctly.

Audience

Who uses SleekView for WooCommerce Referrals

Affiliate managers

Sort referrers by last-30-day revenue to find the top performers and reach out for a featured campaign. Use the paused-code view to revive referrers who recently went quiet.

Finance

Pull the monthly commission rollup with referrer email, total conversions, referred revenue, and the calculated commission. Export to CSV for accounting reconciliation without writing SQL.

Fraud reviewers

Inspect pending conversions with the originating order_id, customer email, and IP if exposed. Bulk-approve or reject after review, with each decision logged for compliance.

The bigger picture

Affiliate programs are won at the top of the funnel

A referral program is only worth running if the small group of top referrers stays engaged. The 80-20 rule applies aggressively: the top ten percent of referrers drive almost all the revenue, and once they go quiet the program flatlines. WooCommerce Referrals tracks the necessary data in clean relational tables, with referrer profiles, codes, and conversions joined by foreign keys.

But the default admin separates the three concepts into different screens with no rollup, which forces the affiliate manager to alternate between tabs or wait on an analyst for a weekly spreadsheet. SleekView joins the source tables and exposes the rollups that the manager actually thinks in, with saved views for the top performers, the paused codes, and the pending conversions awaiting fraud review. The result is a referral surface that scales with the program's success: as the referrer count grows, the operator's daily workflow gets shorter, not longer.

Questions

Common questions about SleekView for WooCommerce Referrals

Yes. wp_wc_referrals_conversions is aggregated per referrer_id and exposed as a sortable column. A drill-down view lists every individual conversion row with the originating order_id and customer.

 

Yes. Inline edits route through wc_referrals_update_referrer, which fires the plugin's downstream payout actions and notifies the referrer if that hook is configured. The change is logged with the operator.

 

A Pending saved view filters conversion_status = pending. Select rows and bulk-approve through the plugin's review API, with the operator recorded on each row for audit.

 

Yes. Conversion rows reference order_id, and SleekView reads from wp_wc_orders on HPOS or wp_posts on classic storage. The join transparently picks the right source per environment.

 

Yes. The grid groups by referrer_id with the active code summarized, and a per-code view lists every code separately with its conversion count. Disabled and expired codes appear with clear status badges.

 

SleekView itself does not move money. It exposes the rollups that the finance team needs to run payouts: commission per referrer, period totals, paid-versus-pending status, ready for export to the payment provider.

 

Yes. Apply the active-code and last-30-day filters, sort by revenue descending, and export visible rows to CSV. The export keeps active filters, columns, and sort, ready for an outreach campaign.

 

Yes. Affiliate managers see the full grid with edit rights, finance sees commission rollups read-only, fraud reviewers get the pending-conversion queue. Saved views check role capability per view.

 

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