SleekView for SureCart Recurring: subscriptions, renewals & customers as tables
SureCart Recurring stores subscriptions, periods, and invoices in the local SureCart cache that mirrors the hosted backend. SleekView pivots those cache tables into a single workspace for renewal triage, dunning, and lifetime-value ranking.
♾️ Lifetime License available
Subscription ops on a hosted commerce stack
SureCart Recurring keeps subscription state on its hosted infrastructure and syncs the operational view into wp_surecart_subscriptions, wp_surecart_periods, wp_surecart_invoices, and wp_surecart_customers. Each subscription cache row carries status, current period start and end, next billing date, gateway, currency, and the related price id.
The default SureCart admin lists subscriptions in a slim React panel scoped to one resource, which works for a single status check but stretches thin when a renewal cohort, dunning queue, or LTV ranking needs to land on one screen. SleekView reads the cache tables together so subscription, customer, and the most recent invoice can render in one row, with renewal-date filters and gateway columns visible without an extra click.
Inline edits to status, cancellation reason, and trial extensions route through SureCart's REST API where supported so the hosted backend stays canonical. Refunds and proration calculations stay in SureCart for the same reason, with SleekView linking out per row when those flows are needed.
Workflow
Subscription cache as one workspace
Pick the base resource
wp_surecart_subscriptions for renewal ops, or wp_surecart_customers for an LTV-rooted view. SleekView detects the SureCart plugin version automatically.
Add invoice and customer joins
wp_surecart_invoices row per subscription, and bring in wp_surecart_customers for email and LTV. Aggregate MRR per subscription from the period and invoice history.
Save the operational views
current_period_end), dunning (latest invoice failed), trial-conversion (trials ending in seven days), churn cohort (cancelled in last 30 days). Each view gated by capability.
Edit through the SureCart API
Sample columns
A typical SureCart Recurring view
wp_surecart_subscriptions with wp_surecart_customers and the latest wp_surecart_invoices row.
wp_surecart_subscriptions + wp_surecart_periods + wp_surecart_invoices + wp_surecart_customers
| Sub | Status | Customer | Plan | Next renewal | MRR | Gateway |
|---|---|---|---|---|---|---|
| #SR-1284 | Active | alex@studio.co | Pro Monthly | Jun 04 | $39 | Stripe |
| #SR-1283 | Past due | ria@design.io | Studio Monthly | May 18 | $19 | Stripe |
| #SR-1282 | Trialing | tom@hello.dev | Pro Monthly | May 25 | $0 | PayPal |
| #SR-1281 | Cancelled | mia@brew.coop | Studio Yearly | $0 | Stripe |
Comparison
Default SureCart Recurring admin vs SleekView
Default SureCart Recurring admin
- Subscription list lives in a single React panel with limited column control
- Renewal-date filtering needs querystring tweaks, not a saved filter
- Invoice history is one click into each subscription, not a joined column
- No dunning queue view filtered to past-due across the whole base
- LTV ranking by customer requires an export from the hosted SureCart dashboard
SleekView
-
Join
wp_surecart_subscriptions,wp_surecart_customers, and the latestwp_surecart_invoices -
Filter by
current_period_end, gateway, currency, or plan price id - Inline-edit cancellation reason, trial end, and notes via the SureCart REST API
- Saved views: renewal queue, dunning, trial-conversion watchlist, churn cohort
- Per-customer MRR and LTV columns computed across the cache
Features
What SleekView gives you for SureCart Recurring
Renewal-date triage
Sort by current_period_end, filter to upcoming plus past-due, and update notes inline before the gateway retries. Catches the at-risk renewals before SureCart's own retry schedule.
Subscription plus invoice plus customer
One row carries subscription status, plan, latest invoice outcome, and customer email by joining the cache tables on subscription_id and customer_id.
MRR and LTV columns
Aggregate columns compute monthly recurring revenue per subscription and lifetime totals per customer from the cached invoice history. Sortable without exporting to the SureCart dashboard.
Audience
Who uses SleekView for SureCart Recurring
Subscription ops
Renewal triage and dunning in one workspace. Sort by next-renewal date, filter to past-due, and update the cancellation reason inline before the next gateway retry.
Growth and finance
MRR by plan and LTV by customer sortable inline. Trial-conversion watchlist filtered to current trials ending in the next seven days.
Support
Customer view with active subscriptions, recent invoices, and refund history. Resolves billing questions without opening the SureCart dashboard for each ticket.
The bigger picture
Why hosted subscriptions still need a joined admin
Subscription businesses run on cohorts and renewal cycles, not on individual purchases. The operational signals (upcoming renewals, dunning, trial conversion, churn-at-risk) are all date-sensitive aggregations that need to land on one screen for the ops team to act before the gateway processes the next retry. SureCart's hosted model handles compliance, gateway logic, and tax calculation cleanly, and the WordPress cache is fast enough to query directly without round-tripping to the hosted API on every admin page load.
The trade is the same as every headless setup: data is in separate cache tables and shows up in separate React panels, so subscription ops spend more time clicking between screens than reading numbers. SleekView treats the cache as a joinable schema. A renewal manager scans the next two weeks of current_period_end, a finance lead aggregates MRR per plan price id, and a support agent pulls a customer with active subscriptions and recent invoices in one row.
Writes route through SureCart's own REST API so the hosted backend stays canonical. The dashboard remains for refunds and plan changes that need SureCart's tax and proration logic. SleekView covers the daily joined view that the dashboard does not.
Questions
Common questions about SleekView for SureCart Recurring
It reads the local cache (wp_surecart_subscriptions and related) the SureCart plugin already maintains. Writes go back through SureCart's REST endpoints so subscription state on the hosted side stays canonical and any automation hooks fire the same way they would from the dashboard.
Status changes that the SureCart API supports (cancel at period end, pause, resume, set cancellation reason) are bulkable inline. Hard refunds and proration calculations stay in SureCart's own flow so its gateway and tax handling apply, and SleekView links out per row for those cases.
 
wp_surecart_invoices joins to subscriptions by subscription_id. The latest invoice can be a column on the subscription row (status plus amount plus paid date), or invoices can be a separate base table for finance audit views.
Yes. current_period_start, current_period_end, and trial_end are exposed as filterable columns. A typical trial-conversion view filters trials ending in the next seven days with payment method status visible to spot conversions that need a card update.
SureCart records the previous and current price id on the subscription when plans change. SleekView surfaces both columns so an upgrade or downgrade is visible without opening the subscription detail panel.
 Yes. Filter subscriptions by price id, product id, or any custom field synced from SureCart. Useful for stores running multiple SaaS-style products on one install.
 
Yes. Filter wp_surecart_invoices to status failed or uncollectible and group back by subscription. That is the dunning queue, with customer email and last-failure date as columns for one-click outreach.
Currency is stored on every subscription and every invoice. MRR and LTV can be grouped or filtered per currency so totals never mix USD and EUR into one misleading number.
 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 Wholesale Lead Capture
- Woocommerce Bulk Discounts
- Edd Stripe Pro
- Wpc Product Quantity
- Yith Woocommerce Color And Label Variations
- Wpc Smart Wishlist
- Wcfm Bookings
- Wp Crowdfunding
- Yith Woocommerce Points And Rewards
- Checkoutwc
- Woocommerce Bring Shipping
- Yith Woocommerce Sales Countdown
- Woocommerce Amazon Pay Pro
- Automatewoo
- Woocommerce Taxify