SUMO Subscriptions tables for WordPress
Active, paused, cancelled and trial subscriptions live in one filterable table with renewal dates as a real column. SleekView turns SUMO's CPT data into a retention working surface.
♾️ Lifetime License available
SUMO stores subscriptions as posts. SleekView makes them queryable.
SUMO Subscriptions models each subscription as a custom post type with renewal data — next payment date, billing cycle, status, trial expiry — stored as postmeta on the record. The default WordPress edit screen for that CPT walks subscriptions one row at a time, which is how the data was originally surfaced. For a retention manager looking at a few hundred subscriptions, that single-record approach is the bottleneck before any actual retention work begins.
SleekView promotes those postmeta fields to typed columns. Status (active, paused, cancelled, expired) becomes a filterable enum. Next payment becomes a sortable datetime column so retention outreach staffs against the actual upcoming renewal queue. Billing cycle becomes a group-by axis for revenue forecasting. Trial expiry surfaces in its own column so trials ending in 48 hours are a saved view, not a manual lookup.
Saved views like "Trials ending this week", "Failed last renewal" or "Active yearly cycle" pin the slices each retention role owns. Inline editing on internal notes per subscription lets success teams annotate without leaving the grid.
Workflow
From SUMO posts to a retention queue
Read the SUMO CPT
Promote to columns
Pin retention views
Annotate per record
Sample columns
How SUMO stores subscriptions
wp_postmeta
| Field | Description | Type | Filterable | Status |
|---|---|---|---|---|
| sumo_status | active, paused, cancelled, expired | string | Yes | Active |
| sumo_next_payment | Next billing date | datetime | Yes | Active |
| sumo_billing_cycle | Daily, weekly, monthly, yearly | string | Yes | Active |
| sumo_trial_end | Trial expiry timestamp | datetime | Yes | Optional |
Comparison
SUMO default screen vs. SleekView
SUMO default
- Subscriptions list lacks real filtering by status
- Trial expiries invisible until manual lookup
- No grouping by billing cycle
- Pause and resume actions hidden in submenus
- No saved views per retention manager
SleekView
- Filter by active, paused, cancelled, or trial
- Sort by next renewal to staff retention outreach
- Group by billing cycle for revenue forecasting
- Inline edit internal notes per subscription
- Export the visible slice for finance
Features
What SleekView gives you for SUMO Subscriptions
Renewal queue
Sort upcoming renewals by date so retention can reach out before failed cards turn into churn. The 7-day-window view becomes the retention team's daily landing page.
Status pivot
Filter active, paused, cancelled and expired subscriptions in one click instead of stacked queries. Each status becomes its own pinned saved view ready to open.
Cycle revenue
Group by billing cycle to see how monthly versus yearly customers split your recurring base. The view becomes a recurring-revenue forecast input.
Audience
Where SUMO stores use SleekView
Retention outreach
Build a saved view of trials ending in seven days so success can email before they expire. The view doubles as the conversion-team queue for the week.
Failed renewal recovery
Filter to subscriptions with failed last renewals and assign them to recovery automations. The dunning queue runs against a real list, not a manual export.
Cohort analysis
Group by start month to track survival of each cohort across the past year. Cohort churn surfaces as a saved view rather than a custom quarterly report.
The bigger picture
Subscription churn is invisible in a CPT list
Subscription businesses live or die by retention, and retention happens in the week before a renewal, not after. Trials ending in 48 hours are conversion opportunities — but only if the team knows about them. Failed renewal payments are recoverable for a window — but only if the team triages them within that window.
Cohort survival across the past year is a real business question — but unanswerable if the only way to look at subscriptions is one CPT post at a time. SUMO's strength is that it models the subscription correctly with status, billing cycle and renewal data attached. The gap is that the default WordPress edit screen for any custom post type was built for blog posts, not retention queues.
Treating SUMO data as a queryable grid with renewal dates, status and billing cycle as filterable columns turns retention from "run a custom report quarterly" into "open the saved view daily". For subscription stores this is what scaling past the founder-runs-everything stage actually looks like.
Questions
Common questions about SleekView for SUMO Subscriptions
SUMO uses a custom post type for subscriptions with renewal and billing data attached as postmeta on each record. SleekView reads the CPT and its postmeta together, promoting meta keys to typed columns. The CPT name and meta key prefixes are detected automatically so configuration stays minimal even on sites that have customized SUMO's storage.
 Cancellations route through SUMO's normal cancellation actions because they need to update related WooCommerce orders, fire SUMO hooks for downstream automations and update billing cycle state correctly. SleekView surfaces the cancellation queue and lets you mark internal notes per subscription, but the cancellation action itself runs through SUMO so cancellation emails, refund handling and post-cancellation hooks all fire as configured.
 Yes. Related meta keys from SUMO Reward Points (point balance, last accrual, redemption history) can be promoted as their own columns alongside subscription state. A common pattern is showing point balance in the subscription grid so retention can spot high-engagement customers at a glance and prioritize save-play outreach for the ones with significant unspent points.
 Yes. Filter to upcoming renewals — say next 30 days, status active — and export the slice as CSV with the columns retention needs (customer email, next payment date, billing cycle, last note). The export honors per-role column masking so PII stays hidden where it should. Common pattern: weekly CSV export for the retention team's outreach queue, monthly summary export for finance.
 Yes, with per-site or network-wide views. Single-store networks usually want per-site grids so each site's retention team sees only their own subscriptions. Multi-store retention functions can configure a network-wide aggregated view, useful when the same customer might have subscriptions across multiple sites in the network.
 No. SleekView only loads on its own admin screens. The storefront, customer subscription dashboards, checkout and renewal cron jobs never trigger SleekView queries. Admin grid queries use indexed columns and pagination, so even subscription bases in the tens of thousands stay responsive.
 Variable subscription products with different price tiers store the chosen price in postmeta on the subscription, and SleekView promotes that as a sortable currency column. Group by product plus tier to see how customers distribute across pricing variants. Useful when running A/B price tests or evaluating whether to retire a tier with low subscriber count.
 SleekView itself does not send emails — it surfaces the queue. The standard pattern is to use the saved view's CSV export as input to your email tool (or to a recovery automation that pulls the same query), or to wire SUMO's existing renewal-warning hooks against the same data. Keeping the email layer in your existing tooling means SleekView does not become a deliverability surface, which is the right separation of concerns.
 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 checkout