SleekView for YITH WooCommerce Points and Rewards
SleekView reads wp_usermeta where YITH stores per-customer balances and unions the points log, rendering every earn, redeem and expiry event as a queryable audit grid inside WP Admin.
♾️ Lifetime License available
Move points history out of per-customer screens and into an audit table
YITH WooCommerce Points and Rewards keeps a current balance per customer in wp_usermeta and writes every earn, redeem and expiry event into its own log structure. The default admin gives a per-customer balance screen and a flat event list, which is fine for resolving a single ticket and wrong for program-level questions about engagement, top earners or refund-driven adjustments.
SleekView reads wp_users joined with wp_usermeta on the points balance key and unions the YITH points log, exposing event type, amount, related order ID and event date as columns alongside the customer's display_name and email. Filter to redeem events in the last 30 days for engagement triage. Sort by amount to surface large adjustments for audit. Group by event_type to scope to expirations only.
The plugin keeps owning earn rules, redemption flow and tier configuration. The table view owns the audit surface, so the log YITH already writes becomes a queryable cohort instead of a per-customer drill-down.
Workflow
How SleekView surfaces YITH Points and Rewards data
Point at wp_users and the points log
Compose the columns
Filter and sort like a database
Save and gate the view
Sample columns
A typical YITH Points and Rewards audit view
wp_yith_points_log
| Customer | Event type | Amount | Related order | Balance after | Recorded |
|---|---|---|---|---|---|
| Maya Collins | Earn | +120 | #18420 | 1,840 | 2026-05-04 09:12 |
| Pieter Nakamura | Redeem | -500 | #18415 | 2,100 | 2026-05-03 16:08 |
| Studio Felix | Earn | +80 | #18411 | 640 | 2026-05-02 11:45 |
| Devi Iturbe | Expire | -200 | — | 3,400 | 2026-04-30 00:00 |
| Team Osei | Earn | +45 | #18402 | 215 | 2026-04-28 14:23 |
Comparison
Default YITH Points and Rewards admin vs SleekView
Default YITH Points and Rewards admin
- Per-customer balances live on the user profile, not in any cross-customer screen
- Event history is a flat list without cross-event filtering
- Top earners or top redeemers require a CSV export and a pivot
- Expiry audits need a custom query against the log table
- Related orders for each event aren't joined onto the row
SleekView
- Points balance and event history rendered as one queryable dataset
- Event type, amount and related order as real columns on every row
- Filter to redeem only, earn only, expiry only or any date window
- Saved views per role: loyalty manager, finance audit, support triage
- Same dataset the chart view aggregates, so table and dashboard stay in sync
Features
What SleekView gives you for YITH WooCommerce Points and Rewards
Balance and history together
Current balance from wp_usermeta sits next to every event in the log so support and loyalty managers see state and history in one row without two-tab juggling.
Composable points filters
Stack filters on event_type, amount, date and related order to assemble top-earner lists, redemption audits or expiry sweeps in one query.
Event type per row
Earn, redeem and expire surface as a real column with badge styling so the audit table reads like a ledger instead of a flat log.
Audience
Who uses SleekView for YITH Points and Rewards
Loyalty managers
Weekly redemption review filtered to the last 30 days, sorted by amount, so the program owner sees real engagement instead of a flat log.
Finance
Year-end audit filtered to expiry events to true up the liability KPI, exported as CSV with customer, amount and event_date for reconciliation.
Customer support
Search by email to land on every event for a single customer with related order joined inline, so adjustment tickets resolve in one screen.
The bigger picture
Why points events deserve a real table
Loyalty programs accumulate state and history at the same time: every customer carries a balance, and every transaction writes an event that adjusts it. The default YITH admin renders balances on user profiles and events as a flat log, which keeps single-customer tickets quick and leaves program-level questions inside spreadsheets. SleekView reads wp_usermeta and the points log as one dataset, rendering customer, balance, event_type, amount and related order as real columns on every row.
Filters stack so redemption audits, expiry sweeps and top-earner lists become one-click views. The plugin keeps owning earn rules and redemption logic, while loyalty managers, finance and support all get the per-row audit surface the log always implied.
Questions
Common questions about SleekView for YITH WooCommerce Points and Rewards
wp_users joined with wp_usermeta on the YITH points balance key, unioned with the YITH points log (or its equivalent log post type depending on version). No new tables are introduced and no extra meta is written.
 Yes. Tier names appear as a column where YITH records them, so a saved view can group by tier or scope to a single tier without rebuilding the dataset.
 Yes. Event_type is a first-class column. Saved views typically include "redemptions last 30 days", "expirations this quarter" and "earn from refunded orders" as standing slices.
 Expiry events appear in the log with their own type, so the audit table includes or excludes expirations depending on the saved view's filter rather than hiding them.
 Edits go through the YITH adjustment API rather than direct SQL, so plugin hooks observe the writes exactly as they would from the customer profile screen, including audit logging.
 Yes. The chart view and the table view share the dataset, so an event_type filter or a date-window slice narrows both surfaces. Loyalty managers pivot between row audit and rollup without rebuilding filters.
 Yes. Any filtered cohort exports as CSV with customer email, event_type, amount, related order and event_date. Useful for year-end liability reconciliation and program reviews.
 Yes. SleekView queries the log with indexed joins and paginates results, so programs with hundreds of thousands of events 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