SleekView for WooCommerce Rewards Points: balances and ledger as tables
Rewards Points stores customer balances in a custom user-points table and writes an event row for every earn, redeem, signup bonus, and expiry sweep. SleekView joins the table with WooCommerce customers so loyalty teams see balance, lifetime_earned, and last event on a single row.
♾️ Lifetime License available
See points history and balances in one grid
WooCommerce Rewards Points keeps customer balances in wp_wc_rewards_user_points and writes ledger rows into wp_wc_rewards_points_log for earns, redemptions, signup bonuses, and expiry clears. The default admin shows the customer balance list and the event log on separate screens, which makes a simple question like "who is 50 points away from a redemption tier" or "how many points did the recent signup push issue" surprisingly hard to answer.
SleekView reads wp_wc_rewards_user_points, joins it to wp_users and the latest log row from wp_wc_rewards_points_log, and exposes balance, lifetime earned, last event reference, and last activity timestamp as first-class columns. Filter by event_type to audit a single campaign, sort by lifetime_earned to find the top spenders, or save a view called "Near redemption threshold" that the marketing team reuses every week.
Inline edits route through the plugin's points API so balance adjustments still trigger the plugin's hooks and write a ledger row with the right reference. When the plugin does not expose an editor for a column, SleekView falls back to a direct write on the user-points table with optimistic-lock checks against the row's updated_at so two admins can not silently overwrite each other.
Workflow
Loyalty data without the screen hopping
Connect the source
wp_wc_rewards_user_points, the latest row from wp_wc_rewards_points_log, and wp_users. The join produces one row per customer with balance, lifetime earned, and last event reference visible.
Compose columns
event_type of the most recent ledger entry. The grid reads like a CRM tuned for loyalty: balance plus behavior on one line.
Save segment views
Edit inline and export
Sample columns
A typical Rewards Points customer view
balance, lifetime_earned, last event, and recent activity.
wp_wc_rewards_user_points + wp_wc_rewards_points_log
| Customer | Status | Balance | Lifetime Earned | Last Event | Last Activity |
|---|---|---|---|---|---|
| alex@studio.co | active | 2,140 | 6,420 | order_complete | Apr 24 |
| ria@design.io | low | 55 | 1,320 | order_redeem | Apr 22 |
| tom@hello.dev | expired | 0 | 4,180 | expiry_clear | Apr 15 |
| mia@brew.coop | active | 740 | 740 | signup_bonus | Apr 18 |
Comparison
Default WooCommerce Rewards Points admin vs SleekView
Default WooCommerce Rewards Points admin
-
Customer balance list omits
lifetime_earnednext to current balance - Ledger and balance views live on separate screens
-
No filter on
event_typefor signup, redeem, or expiry - Bulk balance adjustments require manual entry per user
- No CSV export of points activity with current filters applied
SleekView
- Balance and ledger joined on one row per customer
-
Filter by
event_type,status, or customer role -
Inline balance edits route through the plugin's
add_pointshooks -
Sort by
lifetime_earnedto surface top spenders - CSV export respects active filters, columns, and sort
Features
What SleekView gives you for WooCommerce Rewards Points
Balance plus history
Each row shows current balance alongside the most recent ledger event reference and timestamp. Support and marketing answer questions without clicking into a customer profile to chase the last activity.
Event filters
Filter on event_type for signup_bonus, order_redeem, expiry_clear, or any custom reference. Audit a specific campaign or expiry sweep in seconds with the result count visible.
Bulk adjustments
Select rows and apply a credit or debit to many customers at once. Each adjustment routes through the plugin's points API so hooks fire and the ledger captures the change with the right reference.
Audience
Who uses SleekView for WooCommerce Rewards Points
Loyalty managers
Sort by lifetime_earned to find VIPs and filter customers within 100 points of the next reward tier for a nudge campaign. The saved view becomes a one-click weekly shortcut.
Marketing leads
Segment dormant high-earners by combining balance > 1000 with last_activity older than 90 days, then export to CSV for a VIP win-back email or ads-platform upload.
Support team
Pull up a customer to see balance, last event reference, and the order that produced it. Most points tickets get answered on first read instead of bouncing between two admin screens.
The bigger picture
Loyalty programs run on segmentation
A loyalty program only works if the team running it can answer questions about it without filing a developer ticket. Which customers are 50 points away from claiming a reward, so an email nudge converts them. Which long-time spenders have not engaged in 90 days, so retention can intervene.
How many points did the recent signup bonus push actually issue, and to whom. WooCommerce Rewards Points collects the raw data correctly in its own custom tables, but its default admin presents balances and event logs on separate screens, which forces the loyalty team into copy-paste workflows or ad-hoc SQL. SleekView joins the points table with the ledger and the customer record into one grid, where a single sort or filter answers each of those questions.
The plugin keeps doing what it does well, and the operators get a surface that matches how they actually think: per-customer, with current state and recent behavior on one row, segmentable on the spot.
Questions
Common questions about SleekView for WooCommerce Rewards Points
Yes. It queries wp_wc_rewards_points_log and joins on wp_wc_rewards_user_points and wp_users, so each row shows the latest event reference alongside the current balance. There is no custom export step.
Yes. Bulk edits in SleekView route through the plugin's points API where available, which fires the same hooks the storefront uses and writes a clean ledger row per adjustment. The audit trail stays intact.
 Yes. Signup bonuses and referral credits write a balance before any order exists. SleekView's row is anchored to the points record, not a WooCommerce order, so those customers still appear in the grid.
 
Yes. The latest event_type and reference_id appear as columns next to balance and timestamp. Switching to the ledger view lists every credit and debit per customer with the originating order or signup.
Expiry rows in wp_wc_rewards_points_log are surfaced with a clear status badge. Build a saved view of customers whose points expired in the last 30 days for a retention email, or sort by next-expiry date for a reminder sequence.
Yes. Apply filters on status, balance, lifetime earned, or event reference, then export the visible rows to CSV. The export respects active sorts and column order so the file is ready for the next tool.
 
The conversion ratio lives in plugin options. SleekView can render a converted-currency column alongside balance so finance gets the cash-equivalent liability in a single export without manual math.
Yes. Each saved view has its own visibility per role. Support sees the read-only customer grid, loyalty managers get bulk-edit, finance sees the converted-currency liability view. Capabilities check the standard WordPress roles.
 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 Dokan Pro
- Aelia Currencyswitcher
- Yith Multi Vendor
- Woocommerce Canpar Shipping
- Woocommerce Zip Pay
- Woocommerce Purolator
- Woocommerce Stamps
- Cart66 Cloud
- Woocommerce Customizer
- Woocommerce Gift Registry
- Woocommerce Payments Stripe
- Woocommerce Allegro Pl
- Woocommerce Octobat
- Woocommerce Product Variations Swatches
- Woocommerce Direct Bank Transfer Pro