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

SleekView table view for WooCommerce Points and Rewards

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

1

Connect the table

Point SleekView at wp_wc_points_rewards_user_points and the WooCommerce customer table. The join produces one row per customer with balance, lifetime earned, and the most recent event reference visible.
2

Add behavior columns

Layer on lifetime spend, last order date, customer status, and the last event reference. The result is a CRM-style view tuned for loyalty: balance plus the behavior that produced it, on one line.
3

Build segment views

Save views for Near redemption threshold, Top earners last 90 days, Expired balances, and Points-only customers. Each becomes a one-click filter for the marketing and support teams.
4

Adjust and export

Bulk-adjust balances inline when running a make-good campaign, with the plugin's logging still firing per row. Export the visible segment to CSV for ads, email, or accounting reconciliation.

Sample columns

A typical Points and Rewards customer view

Customers with current balance, lifetime earned, last event, and recent activity.
Source: 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.

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