YITH Subscriptions data tables for WooCommerce
Trials, paused plans and active recurring orders all in one queryable table view. SleekView turns YITH subscription metadata into a retention working surface for WooCommerce stores.
♾️ Lifetime License available
YITH writes the data. SleekView makes it work for retention.
YITH WooCommerce Subscriptions models each subscription on top of WooCommerce orders with billing schedule, status and trial flags stored as order meta. That keeps the schema close to standard WooCommerce, but it also means every retention question — which trials are ending this week, which subscriptions failed their last payment, how monthly and yearly cycles split — starts with a meta_query the default admin cannot run.
SleekView promotes _ywsbs_status, _ywsbs_payment_due_date, _ywsbs_period and _ywsbs_trial_end to typed columns. Status becomes a filterable enum. Next due date becomes a sortable datetime so retention staffs against the upcoming queue. Period becomes a group-by axis for plan-mix reporting. Trial expiry becomes its own pinned view for trial-conversion outreach.
Saved views like "Trials ending in 48 hours", "Failed last payment", "Active yearly" and "Paused over 30 days" pin the slices each retention role owns. The grid works against High-Performance Order Storage and inline editing on retention notes keeps annotation in the same place as the data.
Workflow
Promote YITH subscription meta to a real grid
Read order plus meta
Type each field
Pin retention views
Annotate inline
Sample columns
YITH Subscriptions data layout
wp_wc_orders_meta
| Field | Description | Type | Filterable | Status |
|---|---|---|---|---|
| _ywsbs_status | active, paused, cancelled | string | Yes | Active |
| _ywsbs_payment_due_date | Next billing date | datetime | Yes | Active |
| _ywsbs_period | day, week, month, year | string | Yes | Active |
| _ywsbs_trial_end | Trial expiry | datetime | Yes | Optional |
Comparison
YITH admin vs. SleekView
YITH default
- Subscription list lacks compound filters
- Trial expiries require single-record clicks
- No grouping by billing period
- CSV export is single-click whole-table only
- No shared retention views
SleekView
- Filter by status, period, and renewal date
- Sort by next due date for outreach
- Group by product for plan-level reporting
- Inline edit retention notes per record
- Export filtered slices for accounting
Features
What SleekView gives you for YITH WooCommerce Subscriptions
Due-date sort
Order subscriptions by next due date to staff renewal outreach without stacking queries. The view becomes the retention team's daily landing page.
Trial pivot
Filter to trials ending this week to prepare welcome emails and conversion offers. The 48-hour-window view stays pinned for the conversion team.
Plan mix
Group by product to see how monthly and yearly mixes change as you shift pricing. Plan-mix reporting becomes a saved view, not a quarterly custom report.
Audience
Where YITH stores use SleekView
Trial conversion
Build a view of trials ending in 48 hours and trigger personalized outreach automatically. The list feeds the email tool rather than running through manual export.
Renewal forecast
Sum upcoming renewal amounts by week to plan cash flow before the cycle hits. The forecast view stays pinned for finance week-over-week comparison.
Failed payments
Filter to subscriptions with last payment failed for direct recovery touches. The dunning queue runs against a real list, not yesterday's CSV export.
The bigger picture
Subscription retention runs against queryable data
WooCommerce subscription stores running on YITH face the same retention realities as any subscription business: trials convert in the last 48 hours, failed payments are recoverable for a window, and plan mix shifts quietly when pricing changes. The data to answer those operational questions is already in YITH's order meta, but the default WooCommerce admin treats subscription orders the same way it treats one-off purchases — as a list page with no awareness of due-date sorting, status enums or billing-period grouping. Retention managers end up running custom reports, exporting to spreadsheets and pivot-tabling manually, which is fine for the founder-runs-everything stage and untenable past it.
A queryable surface against YITH's subscription meta turns trial-conversion outreach into a saved view, failed-payment recovery into a real queue, and plan-mix forecasting into a group-by instead of an ad hoc analysis. The economics of subscriptions reward teams who can act in the right window — and acting in the right window requires the data being addressable in real time, not behind an export.
Questions
Common questions about SleekView for YITH WooCommerce Subscriptions
YITH WooCommerce Subscriptions uses WooCommerce order tables plus subscription meta with the _ywsbs_ prefix. SleekView reads both — the parent order data for customer information, totals and currency, and the subscription meta for status, billing schedule, period and trial flags. The combined view treats each subscription as one row with all fields accessible.
 Cancellations route through YITH's normal cancellation actions because they need to update related WooCommerce orders, fire YITH hooks for downstream automations and stop the renewal scheduler correctly. SleekView shows the cancellation queue and lets you mark internal retention notes, but the cancellation itself runs through YITH so cancellation emails, scheduler updates and refund handling fire as configured.
 Yes. Related YITH Membership meta keys (membership level, access expiry, plan tier) can be promoted as their own columns alongside subscription state. A common pattern is showing membership level in the subscription grid so retention can spot high-tier customers at a glance and prioritize save-play outreach for them. Membership and subscription queries also share the same saved-view system.
 Yes. Modern YITH versions write to High-Performance Order Storage which SleekView reads natively. Sites still on legacy CPT order storage are also supported — SleekView checks which layer is active and reads accordingly. Migrations from CPT to HPOS happen transparently from SleekView's perspective; column promotions and saved views carry over without reconfiguration after the migration completes.
 No. SleekView only loads on its own admin screens. Storefront pages, checkout flows, cart, customer subscription dashboards and renewal cron jobs never trigger SleekView queries. Even in admin, the grid uses indexed columns and pagination — subscription bases in the tens of thousands stay responsive without any tuning.
 Yes. Saved views can be scoped private to one user or shared by capability. Common patterns include a shared "Trials ending" view for the conversion team, a shared "Failed payments" view for recovery and private analyst views for one-off questions. Sharing respects per-role row scoping so a shared view never bypasses anyone's read permissions.
 Variable subscription products with different billing tiers store the chosen tier in subscription meta, and SleekView promotes that as a filterable column. Group by product plus billing tier to see how customers distribute across pricing variants. Useful when running A/B price tests or evaluating whether to retire a tier with declining subscriber count.
 Yes. Each subscription row links back to the parent order and to its renewal order chain. A subscription's renewal history (which renewals succeeded, which failed, which were retried) reads in a side panel without leaving the grid. This matters for support conversations where the question is "what actually happened on this customer's last three renewals" — answering takes seconds rather than tab-juggling between order and subscription edit screens.
 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