✨ 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 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

SleekView table view for WooCommerce Rewards Points

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

1

Connect the source

Point SleekView at 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.
2

Compose columns

Layer lifetime spend, last order date, customer role, and the event_type of the most recent ledger entry. The grid reads like a CRM tuned for loyalty: balance plus behavior on one line.
3

Save segment views

Persist views like Near redemption threshold, Top earners last 90 days, Expired balances, and Points-only customers. Each becomes a one-click shortcut scoped to the marketing or support role.
4

Edit inline and export

Bulk-adjust balances for a make-good campaign so the plugin's logging fires per row, or export the visible segment to CSV for ads, email, or accounting reconciliation.

Sample columns

A typical Rewards Points customer view

Customers with current balance, lifetime_earned, last event, and recent activity.
Source: 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_earned next to current balance
  • Ledger and balance views live on separate screens
  • No filter on event_type for 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_points hooks
  • Sort by lifetime_earned to 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.

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