✨ 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 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

SleekView table view for SureCart Recurring

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

1

Pick the base resource

Start from wp_surecart_subscriptions for renewal ops, or wp_surecart_customers for an LTV-rooted view. SleekView detects the SureCart plugin version automatically.
2

Add invoice and customer joins

Join the latest 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.
3

Save the operational views

Renewal queue (sorted by 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.
4

Edit through the SureCart API

Inline edits to writeable fields call SureCart REST endpoints so webhooks and automations fire as if the change came from the dashboard. Refunds and proration stay in SureCart.

Sample columns

A typical SureCart Recurring view

Joins wp_surecart_subscriptions with wp_surecart_customers and the latest wp_surecart_invoices row.
Source: 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 latest wp_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.

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