SleekView for WooCommerce Points and Rewards: balances and logs as tables
WooCommerce Points and Rewards splits balances and event logs across a custom table and user meta. SleekView joins them so loyalty managers see balance, lifetime earned, and last event in one grid.
♾️ Lifetime License available
See points history and balances in one grid
WooCommerce Points and Rewards stores customer balances in wp_wc_points_rewards_user_points and writes event entries for earns, redemptions, signup bonuses, and expiry clears. The default admin presents the customer point list and event log on separate screens, which makes simple questions like "who is closest to a redemption threshold" or "how many points did this customer actually earn from orders" surprisingly hard. SleekView joins the table with WooCommerce customer data so a single row shows current balance, lifetime earned, last event reference, and last activity timestamp.
The grid handles the practical loyalty workflows. Filter by status to find dormant customers with high balances ripe for re-engagement. Sort by lifetime earned to find your top-spending loyalists for a VIP campaign. Filter by event reference to audit a specific signup_bonus push or an expiry sweep that ran last week. Bulk balance adjustments select multiple rows and apply a credit or debit, with the plugin's logging firing for each so the event history stays accurate.
Customers who hold a balance but have not yet placed an order still appear in the grid, which matters when running referral or signup bonuses that pay points before any purchase. Saved views like Top earners last 90 days, Near redemption threshold, and Expired balances become daily shortcuts for the loyalty team. Export filtered customers to CSV when feeding ads platforms or email tools, and keep the segmentation in WordPress where the source data lives.
Workflow
Loyalty data without the screen hopping
Connect the table
Add behavior columns
Build segment views
Adjust and export
Sample columns
A typical Points and Rewards customer view
wp_wc_points_rewards_user_points and user meta
| Customer | Status | Balance | Lifetime Earned | Last Event | Last Activity |
|---|---|---|---|---|---|
| sarah@shop.com | active | 1,840 | 5,200 | order_complete | 2026-04-23 |
| kim@shop.com | low | 45 | 1,100 | order_redeem | 2026-04-22 |
| tom@shop.com | expired | 0 | 3,400 | expiry_clear | 2026-04-15 |
| eli@shop.com | active | 620 | 620 | signup_bonus | 2026-04-18 |
Comparison
Default Points and Rewards admin vs SleekView
Default Points and Rewards admin
- Customer point list lacks lifetime totals next to balance
- Log and balance views are separate screens
- No filter for event types like signup or redeem
- Bulk balance adjustments require manual entry per user
- No CSV export of points activity
SleekView
- Customer balance and event log joined in one grid
- Filter by event type, status, or customer role
- Inline balance edits that respect the plugin hooks
- Sort by lifetime earned to find top customers
- Export selected customers for marketing campaigns
Features
What SleekView gives you for WooCommerce Points and Rewards
Balance plus history
Each customer row shows the current balance and the most recent point event on one line. No clicking into a customer profile to find out whether the last activity was a redemption or a signup bonus.
Event filters
Filter rows by signup_bonus, order_redeem, expiry_clear, or any custom event reference. Audit a specific campaign in seconds and confirm exactly which customers received the bonus or had points expire.
Bulk adjustments
Select rows and apply a points credit or debit to many customers at once. The plugin's logging still fires per customer so the event history stays accurate and audit-ready.
Audience
Who uses SleekView for WooCommerce Points and Rewards
Loyalty managers
Track top earners and find customers near a redemption threshold for nudge campaigns. Sort lifetime earned descending or filter balance close to the redemption tier to build the segment in seconds.
Marketing leads
Segment customers by lifetime points for targeted re-engagement. Filter dormant high-earners, export to CSV, and feed the list to the email tool for a VIP win-back campaign.
Support team
Look up a customer's points and recent events without leaving the orders area. The row shows balance, lifetime earned, and last event reference, which usually answers the ticket on first read.
The bigger picture
Loyalty programs run on segmentation
A loyalty program only works if the team running it can answer questions about it quickly. 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 Points and Rewards collects the raw data, but the default admin presents balances and event logs on separate screens, which forces the loyalty team into copy-paste workflows or developer requests for ad-hoc reports. SleekView turns the points table plus customer data into one grid where a single sort or filter answers each of those questions.
The plugin keeps doing what it does well, and the team running the loyalty program gets 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 Points and Rewards
Yes. It queries wp_wc_points_rewards_user_points and joins WooCommerce customer data so each row shows balance, lifetime earned, and the most recent event reference. The grid loads on the WordPress admin side and stays in sync with the plugin's own internal data without any custom export step.
 Yes. Select rows in the grid and apply a credit or debit. Each adjustment routes through the plugin's API so the event log captures the change with the right reference, and any hooks attached to point modifications fire normally. This makes make-good campaigns and corrections after a billing issue straightforward.
 Yes. Customers who hold a balance but have never placed an order still appear, which matters for sites running signup or referral bonuses that issue points before any purchase. The grid does not require a WooCommerce order to render the customer row, only a points record.
 Yes. The latest event reference appears as a column alongside balance and timestamp. For deeper history, switch to the events view, which lists every credit and debit per customer with reference, amount, and the order or signup that produced it.
 If expiry rules are configured in Points and Rewards, expired entries appear with a clear status badge and become filterable. Build a saved view of customers whose points expired in the last 30 days for retention outreach, or sort by next-expiry date to plan a reminder sequence.
 Yes. Apply filters on status, balance, lifetime earned, or event reference, then export the visible rows to CSV. The export respects column order and active sorts, which keeps the file ready for direct upload to email or ad platforms without further cleanup.
 The conversion ratio from Points and Rewards is stored in plugin options. SleekView can show a converted-currency column alongside the points balance so liability values appear in the shop currency. Finance can pull a single export with both the raw points and the cash-equivalent value.
 SleekView itself does not send email, but you can export a near-threshold segment to CSV or use it as the source for an email tool's import. Combined with the saved-view shortcut, the loyalty team gets a repeatable weekly workflow without copying SQL into a query tool.
 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