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
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
Connect the tables
wp_wc_referrals_referrers, joined to wp_wc_referrals_codes on referrer_id and to a rollup query on wp_wc_referrals_conversions.
Add behavior columns
days_since_last_conversion column for the going-cold filter.
Save segment views
Edit inline and approve
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
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_statuspluslast_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_codesand 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.
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 checkoutBrowse more
- Woocommerce Bing Shopping
- Woocommerce Advanced Product Labels
- Woocommerce Pdf Product Vouchers
- Woocommerce Chronopost
- Surecart Checkout
- Aelia Prices By Country
- Woocommerce Ebay Integration
- Wp Lister Lite
- Edd Frontend Submissions
- Wcfm Delivery
- Woocommerce Donation Form
- Paykickstart Bridge
- Woocommerce Bulk Stock Management
- Checkoutwc
- Authorize Net