SleekView for Wishlist Member Stripe: Stripe charges and level renewals as tables
Wishlist Member Stripe records gateway charges in wp_wlm_transactions with Stripe payment-intent ids and subscription ids. SleekView reads those rows joined to level assignments so finance can audit dunning and renewals from one screen.
♾️ Lifetime License available
Stripe charges joined to Wishlist Member levels
Wishlist Member Stripe is the Stripe gateway integration for Wishlist Member, writing each charge into wp_wlm_transactions with the Stripe payment-intent id, the Stripe subscription id, the amount, and a status column for paid, failed, refunded, or pending. The matching level assignment lives in wp_wlm_userlevels with the member's level id, status, and expiry date. Webhooks from Stripe update both tables when renewals charge, fail, or get refunded.
The default Wishlist Member admin shows transactions and members on separate screens. Joining a Stripe failed-charge to its parent level assignment, with the member's lifetime spend and current status visible, needs the reports module or SQL. The dunning queue (every member whose last Stripe charge failed but whose level is still active) doesn't have a one-screen answer in the default UI.
SleekView reads wp_wlm_transactions directly, joins wp_wlm_userlevels on parent subscription id, and joins wp_users for contact email. The result is a single view where Stripe charge state, level, lifetime spend, and next renewal are all columns. Inline status fixes route through Wishlist Member functions so Stripe webhooks keep the gateway side in sync.
Workflow
Stripe charges and Wishlist Member levels in one workspace
Map the Stripe and level tables
wp_wlm_transactions and wp_wlm_userlevels. Each becomes a navigable view with the columns Wishlist Member Stripe writes on webhook receipt.
Join on user_id and subscription_id
wp_wlm_transactions to wp_wlm_userlevels on parent subscription id and to wp_users on user_id. Stripe charge, status, level, and member email all render as columns.
Save the finance views
Edit through Wishlist Member
Sample columns
A typical Wishlist Member Stripe charges view
user_id.
wp_wlm_transactions + wp_wlm_userlevels + wp_users
| Member | Stripe charge | Status | Level | Date | |
|---|---|---|---|---|---|
| Alex Studio | alex@studio.co | £72.00 | Paid | Pro | Apr 24 |
| Ria Design | ria@design.io | £120.00 | Paid | Annual | Apr 30 |
| Tom Hello | tom@hello.dev | £72.00 | Failed | Pro | Apr 24 |
| Mia Brew | mia@brew.coop | £0.00 | Refunded | Trial | Mar 28 |
Comparison
Default Wishlist Member Stripe admin vs SleekView
Default Wishlist Member transactions tab
-
Transactions list does not join to
wp_wlm_userlevelsfor level context - Stripe failed-charge dunning queue requires reports navigation
-
wp_wlm_transactions.stripe_subscription_idisn't a first-class filter - Bulk refund or status fix across many rows isn't a one-click action
- Per-level Stripe revenue cohorts need exports
SleekView
- Joined Stripe charges and level data in one view
-
Filter
wp_wlm_transactionsby status, gateway, and date together - Surface the Stripe payment-intent and subscription ids as columns
- Inline status fixes through Wishlist Member functions
- Save dunning and revenue views per role
Features
What SleekView gives you for Wishlist Member Stripe
Stripe dunning queue
Filter wp_wlm_transactions to failed Stripe status with member email, level, and lifetime spend visible inline. Prioritise outreach by account value rather than charge date alone.
Joined charges and levels
Combine wp_wlm_transactions with wp_wlm_userlevels on parent subscription id and user_id. One row per charge with the matching level context (level name, current status, expiry) visible alongside.
Per-level Stripe revenue
Group wp_wlm_transactions by joined level for per-level Stripe revenue cohorts. Filter by date range for monthly close, by status for refunds, or by Stripe subscription id for individual customer histories.
Audience
Who uses SleekView for Wishlist Member Stripe
Finance ops
Stripe dunning queue and per-level revenue audit in one workspace. Filter by date range for monthly close; export failed-charge cohorts as CSV for outreach campaigns.
Support
Per-member Stripe history visible during chat without leaving the table. Last paid charge, last failure, current level, all on one row for full context on every billing question.
Subscription ops
Stripe subscription audit with renewal date, retry status, and last charge result. Spot subscriptions heading toward cancellation before Stripe escalates to involuntary churn.
The bigger picture
Why Stripe membership finance needs joined tables
Stripe-driven memberships live or die on retention, and retention questions span the Stripe charge table and the level-assignment table at the same time. Did this member's last Stripe charge fail? Is their level still active despite the failure? Which subscriptions are heading toward Stripe's automatic cancellation after retries? Wishlist Member Stripe writes everything needed to answer those into wp_wlm_transactions and wp_wlm_userlevels, but the default admin treats them as two separate screens. SleekView's joined view turns the cross-table question into one screen: charges with member level, lifetime spend, and status all visible.
Finance teams running monthly close, support teams handling billing questions, and subscription ops watching renewal health all benefit from the same consolidation. For sites with high Stripe transaction volume the visibility shift turns reports-module clicks into one filtered table; for smaller sites it still saves the daily reconciliation pass that the default admin makes harder than it needs to be.
Questions
Common questions about SleekView for Wishlist Member Stripe
SleekView's inline edits call Wishlist Member's own functions so the standard Stripe webhook flow stays in place. Status fixes propagate to Stripe through the same code path the gateway uses normally.
 Yes when SleekView uses Wishlist Member's own functions for status changes, so registered hooks (renewal email, capability sync, integration callbacks) fire on inline edits. Direct DB edits skip those hooks.
 
Yes. Sort the joined view by last-transaction date and filter wp_wlm_transactions.status to failed. That's the Stripe dunning queue with member level and lifetime spend visible inline for prioritised outreach.
Yes. Refunds land in wp_wlm_transactions with refunded status and a reference to the original charge. Filter by refunded status to audit refund volume by date or by level for monthly reporting.
Yes. SleekView queries are paginated and use the indexed columns Wishlist Member maintains on wp_wlm_transactions. Histories with hundreds of thousands of charges run smoothly because joins happen on indexed user_id columns.
Yes. Save views per WordPress capability so finance sees the dunning queue and revenue audit, support sees per-member history, and subscription ops sees the renewal forecast. Each role only loads the data it needs.
 
Yes. wp_wlm_transactions.stripe_subscription_id renders as a filterable column so any Stripe subscription's full charge history is a single filter. Useful for support chats that reference a Stripe subscription directly.
Yes. Any SleekView view exports to CSV or JSON, including Stripe-joined level views. Build a saved view of last month's failed Stripe charges and export it for the monthly dunning report.
 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 Mirakl
- Woocommerce Clearpay Afterpay
- Yith Woocommerce Anti Fraud
- Woocommerce Correios Brazil
- Atum Inventory Management
- Woocommerce Measurement Price
- Restropress
- Edd Paypal Pro
- Woocommerce Services
- Woocommerce Deposits
- Woocommerce Shipping Easypost
- B2b For Woocommerce
- Edd Fes Frontend Submissions
- Woocommerce Quaderno
- Woocommerce Name Your Price