SleekView for WooCommerce Loyalty Program: tiers and members as tables
Loyalty Program stores members and their current tier in a custom table and writes redemption events alongside WooCommerce orders. SleekView reads both and shows tier, points_balance, and next_tier_in on a single row per member.
♾️ Lifetime License available
Members, tiers, and redemptions on one grid
WooCommerce Loyalty Program persists members in wp_wc_loyalty_members with columns for tier_id, points_balance, joined_at, and last_redeem_at. Tiers live in wp_wc_loyalty_tiers with thresholds and reward rules, and redemptions write rows in wp_wc_loyalty_redemptions referencing the originating shop_order. The default admin scatters this across three screens with no joined view.
SleekView joins members, tiers, and the last redemption per member into one grid. Filter by tier_id to see Gold customers separate from Silver, sort by points to find the top earners, or filter next_tier_in ascending to find members on the verge of an upgrade. Each row exposes the columns the loyalty team actually thinks in: member, current tier, balance, points-to-next-tier, lifetime redemptions, and last activity.
Inline edits adjust tier overrides or balance corrections through the plugin's wc_loyalty_set_member_tier hook so the program's downstream actions, like the welcome-to-Gold email, still fire. Bulk operations let you re-issue a tier for a cohort whose threshold rule was misconfigured, with the audit log capturing the operator and reason for each change.
Workflow
Tier rules with operational reality
Connect members and tiers
wp_wc_loyalty_members joined to wp_wc_loyalty_tiers on tier_id. The grid renders one row per member with the active tier name and threshold visible.
Add behavior columns
last_redeem_at, lifetime_redemptions, and a computed next_tier_in column derived from the tier threshold and the current balance.
Save segment views
Edit inline and audit
wc_loyalty_set_member_tier in bulk when a threshold rule needs correction. Each change writes to the audit log with the operator and reason.
Sample columns
A typical Loyalty Program member view
tier, points balance, and last redemption against the shop_order.
wp_wc_loyalty_members + wp_wc_loyalty_tiers + wp_wc_loyalty_redemptions
| Member | Tier | Status | Points | Next Tier In | Last Redeem |
|---|---|---|---|---|---|
| alex@studio.co | Gold | active | 8,420 | 0 | Apr 23 |
| ria@design.io | Silver | at risk | 1,210 | 790 | Mar 14 |
| tom@hello.dev | Bronze | active | 320 | 180 | Apr 18 |
| mia@brew.coop | Silver | churned | 950 | 1,050 | Jan 02 |
Comparison
Default WooCommerce Loyalty Program admin vs SleekView
Default WooCommerce Loyalty Program admin
- Members, tiers, and redemptions live on three separate screens
-
No filter for
tier_idcombined withpoints_balance - No view of points-to-next-tier as a sortable column
- Bulk tier overrides require editing each member by hand
- No CSV export of the at-risk-of-downgrade cohort
SleekView
-
Members joined to
wp_wc_loyalty_tiersand the latest redemption row - Computed next_tier_in column sorts and filters
-
Inline tier override routes through
wc_loyalty_set_member_tier - Saved views for Gold churn risk, Bronze upgrades, and inactive members
- Bulk tier re-issue with operator and reason recorded in the audit log
Features
What SleekView gives you for WooCommerce Loyalty Program
Tier pivot
Group members by tier_id and see the distribution: how many Gold, how many Silver, who is one purchase away from upgrading. The pivot reads straight off wp_wc_loyalty_members with no manual export.
Next-tier filter
Filter on a computed next_tier_in column to find members within 200 points of an upgrade. The marketing team gets a clean weekly nudge list without the developer writing a query.
Tier overrides
Bulk-apply tier overrides for a cohort affected by a threshold-rule misconfig. Each edit routes through wc_loyalty_set_member_tier, fires the welcome email, and records the operator in the audit log.
Audience
Who uses SleekView for WooCommerce Loyalty Program
Loyalty managers
Maintain the tier rules and watch the cohort move. Sort Gold members by last_redeem_at ascending to see who is going cold and trigger a tier-protection campaign before they churn.
Marketing leads
Segment by next_tier_in for upgrade nudges, by tier_id = Gold for VIP perks. Export each segment to CSV for the email tool, with column order and filters preserved.
Support team
Look up a member to see tier, balance, and the most recent redemption against an order. The row answers most loyalty tickets without opening a separate redemption history view.
The bigger picture
Tier programs are won in the segment
Tier programs only pay off if the operator can see the cohort move. Who upgraded this month, who is one purchase away from Gold, who has not redeemed in 90 days and is sliding back. WooCommerce Loyalty Program tracks all of this in clean relational tables, but the default admin separates members, tiers, and redemptions into three screens that do not join, which forces the loyalty team into spreadsheets or ad-hoc SQL just to ask basic questions.
SleekView joins the source tables and exposes them with the columns the team thinks in, including computed ones like points-to-next-tier that depend on the live tier table. Saved views become a daily shortcut, and inline edits keep the plugin's hooks in charge of welcome flows and tier perks. The result is a loyalty surface that scales with the program's complexity, without forcing the development team to ship a new dashboard every quarter.
Questions
Common questions about SleekView for WooCommerce Loyalty Program
SleekView reads tier_id straight from wp_wc_loyalty_members, so any upgrade triggered by the plugin appears on the next grid load. The change history lives in the plugin's audit log and is exposed as a column when configured.
Yes. Inline edits route through wc_loyalty_set_member_tier so the plugin's downstream actions (welcome emails, tier-perk activation) still fire. The override is logged with the operator and an optional reason field.
Yes. wp_wc_loyalty_redemptions joins on member_id and is rolled up to the latest redemption per member by default. A drill-down view exposes the full redemption ledger per member when needed.
On multisite, the loyalty tables exist per site. SleekView scopes the grid to the current site's tables, with an aggregated view available where the plugin uses a shared global table for membership.
If expiry rules are configured in Loyalty Program, points with an upcoming expiry surface as a separate sortable column. Build a saved view of members losing 100+ points in the next 30 days for a clean reminder push.
Yes. Redemption rows reference order_id, and SleekView reads from wp_wc_orders on HPOS or wp_posts on classic storage. The join transparently picks the correct source per environment.
Yes. The sum of points_balance across all members, multiplied by the conversion ratio in plugin options, gives the program liability. SleekView exposes both the per-member and the rollup, ready for accounting export.
Saved views have per-role visibility. Support gets a read-only member grid, loyalty managers can override tiers, finance sees the liability rollup. Capability checks reuse 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 Deposits
- Surecart Cart
- Advanced Coupons
- Woocommerce Product Comparison
- Woocommerce Show Single Variations
- Automatewoo
- Woocommerce Multi Currency Switcher
- Wp Simple Pay
- Instamojo
- Edd Mailchimp
- Woocommerce Name Your Price
- Iconic Woothumbs
- Woocommerce Bitpay
- Woocommerce Firstdata
- Affiliate Aliexpress