✨ 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 Simple WP Membership Pro: members, levels & payments as tables

Simple WP Membership stores members in wp_swpm_members_tbl and levels in wp_swpm_membership_tbl. SleekView joins them and the payments log so each member shows level, status, last payment, and lifetime spend on one row.

♾️ Lifetime License available

SleekView table view for Simple WP Membership Pro

SWPM members, levels and payments in one workspace

Simple WP Membership keeps its data model lean: wp_swpm_members_tbl holds member records with status, level, and registration data, wp_swpm_membership_tbl defines the level catalogue, and the payments log records each transaction with gateway and amount. The Pro tier (built on top of the core plugin with optional add-ons for recurring billing and gateway integrations) writes into the same tables plus add-on-specific keys.

The default SWPM admin handles configuration well: level builder, gateway settings, registration form designer. The operational view is the standard SWPM members screen, which lists members but does not pull last payment, lifetime spend, and next renewal alongside level and status. Cohort filtering across active, expired, and pending is partial, and bulk operations need either SWPM's API or direct SQL.

SleekView reads the SWPM tables directly, joins on member_id and user_id, and produces a member-centric roster with level, status, next renewal, last payment, and lifetime spend as columns. Inline status and level edits route through SWPM's API where supported.

Workflow

SWPM members and payments in one workspace

1

Map the SWPM tables

Point SleekView at wp_swpm_members_tbl, wp_swpm_membership_tbl, and the SWPM payments log. Each becomes a navigable view with the columns SWPM already maintains.
2

Join on member_id

Build a member-centric view joining members to levels and payments. Aggregate amounts for lifetime spend; show last payment date and outcome inline.
3

Save the workflow views

Build saved views for active-by-level, expiring-in-7-days, the dunning queue, and the high-LTV leaderboard. Gate by role for finance, support, admin.
4

Edit through the SWPM API

Status, level, and expiry writes route through SWPM's API so status-email and capability hooks fire. Direct DB writes remain available for bulk migrations.

Sample columns

A typical SWPM members view

Members joined to level, status, and last payment from wp_swpm_members_tbl and the SWPM payments log.
Source: wp_swpm_members_tbl + wp_swpm_membership_tbl + wp_swpm_payments_tbl
Member Level Status Last payment Lifetime spend Joined
alex@studio.co Pro Active May 14 £220 Jan 12
ria@design.io Annual Active Feb 03 £120 Feb 03
tom@hello.dev Pro Expired Apr 24 £144 Mar 12
mia@brew.coop Free Inactive . £0 Apr 02

Comparison

Default Simple WP Membership admin vs SleekView

Default Simple WP Membership admin

  • Members screen omits last payment and lifetime spend
  • Cohort filtering across active, expired, and inactive is partial
  • Payment history per member needs a separate view
  • Bulk level changes for campaigns need SQL or the API
  • Inline status flips for support comps go one member at a time

SleekView

  • Roster joining wp_swpm_members_tbl, wp_swpm_membership_tbl, and payments
  • Lifetime-spend and last-payment columns inline
  • Filter expired or inactive cohorts for re-engagement
  • Inline level changes via the SWPM API
  • Save views per role for support, admin, finance

Features

What SleekView gives you for Simple WP Membership Pro

Joined SWPM tables

Build a single view that joins wp_swpm_members_tbl with the level table and the payments log on member_id. One row per member with level, status, last payment, and lifetime spend.

Dunning queue

Filter the SWPM payments log to failed or refunded statuses with member email, level, and lifetime spend visible inline so outreach can be prioritised by account value.

Bulk level changes

Bulk-change level for cohorts of SWPM members ahead of campaigns or migrations. Changes route through SWPM's API where supported.

Audience

Who uses SleekView for Simple WP Membership Pro

Finance ops

Failed-payment dunning queue and LTV ranking joined from the SWPM payments log. Filter by date range for monthly close; export the dunning queue as CSV.

Membership admins

Active vs expired vs inactive members with inline status fixes. Bulk-change levels ahead of campaigns; comp level upgrades for high-value members.

Support

Per-member payment history, current level, and last login visible during chat. Inline level changes for cases where comping access is warranted.

The bigger picture

Why SWPM installs need joined tables

Simple WP Membership earns its name by keeping the data model small and the admin clean. That clarity is a strength but it leaves operational questions one screen short. The members list shows level and status but not lifetime spend, last payment, or expiry runway.

Payment history sits in its own log. Cross-cutting questions (which active members are about to expire, which expired members had high LTV) need either SQL or several screens of clicking. SleekView reads the SWPM tables together and produces a single member-centric roster where the cross-cutting questions become one saved view.

The dunning queue is a filter on the payments log joined to the members table, the expiring-soon cohort is a sort on the expiry-date column, and the LTV leaderboard is an aggregation on the payments log. SWPM keeps doing what it does well, and SleekView covers the row-level ops layer the lean default admin was never designed for.

Questions

Common questions about SleekView for Simple WP Membership Pro

Yes. The Stripe and PayPal recurring add-ons write into the SWPM payments log with the gateway identifier and recurring flag on the row. Filter by gateway and recurring flag for per-channel reconciliation.

 

Yes. Level writes route through SWPM's API where supported so registered hooks (status emails, capability sync) fire on inline edits. Direct DB writes remain available for bulk migrations and skip hooks by design.

 

SWPM stores extended fields directly on wp_swpm_members_tbl and supports add-on custom fields. SleekView surfaces each column as sortable and filterable, so registration form fields become first-class in the view.

 

Yes. The payment buttons add-on writes purchase records into the SWPM payments log with the button identifier. Filter by button identifier for per-button revenue attribution.

 

wp_swpm_members_tbl stores expiry date and status. SleekView surfaces both as columns and offers a saved view for accounts expiring in the next 7 days, useful for proactive renewal outreach.

 

Yes. Save view sets per WordPress capability so finance sees amounts and gateway data, support sees member contact and last payment, admins see everything.

 

Yes. Queries are paginated and use the indexed columns SWPM maintains on its tables. Sites with tens of thousands of members run smoothly because joins use existing indexes.

 

Yes. SWPM hooks into the standard WordPress personal-data exporter and erasers. SleekView can also export any view as CSV directly from the workspace for ad hoc compliance requests.

 

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