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
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
Map the SWPM tables
wp_swpm_members_tbl, wp_swpm_membership_tbl, and the SWPM payments log. Each becomes a navigable view with the columns SWPM already maintains.
Join on member_id
Save the workflow views
Edit through the SWPM API
Sample columns
A typical SWPM members view
wp_swpm_members_tbl and the SWPM payments log.
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.
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
- B2bking
- Woocommerce Multistore
- Klarna Payments
- Woocommerce Product Bundles
- Customer Reviews For Woocommerce
- Yith Woocommerce Stripe
- Linnworks Wp
- Woopayments
- Yith Woocommerce Product Add Ons
- Yith Woocommerce Bookings
- Woocommerce Gift Cards
- Checkoutwc
- Funnelkit Cart
- Woocommerce Quick View
- Woocommerce Pre Order Pro
- Memberpress Importer
- Click Funnels Wp
- Memberpress Buddypress
- Members Only
- Lifterlms Pro Membership
- Ultimate Membership Pro
- Leaky Paywall
- Membership By Supsystic
- Wishlist Member X
- Members Management Pro
- Paid Memberships Pro Addons
- Memberpress Corporate Pro
- Subscriptio
- Thrive Apprentice
- Magic Members Pro