SleekView for Advanced Coupons: coupons and usage as tables
Advanced Coupons extends WooCommerce coupons with BOGO, scheduling, store credits, and loyalty. All of it lives in postmeta and a few custom tables. SleekView pivots that into proper sortable columns.
♾️ Lifetime License available
Coupon ops without per-coupon clicks
Advanced Coupons stores coupons as the WooCommerce shop_coupon post type with BOGO rules, schedules, usage limits, and conditions in postmeta, plus loyalty points and store-credit balances in custom tables. The default WordPress coupon list shows code, type, amount, and expiry — useful at a glance, but it doesn't surface usage versus limit, schedule windows, or BOGO rule type as sortable columns. Bulk operations on coupons go one at a time, and cross-coupon performance audits typically end up in a spreadsheet.
SleekView flattens the postmeta into proper columns. Usage count, usage limit, start date, end date, BOGO rule type, and active status all become first-class fields ready for sort, filter, and inline edit. Common saved views include 'expired but still active' (spot misconfigured coupons), 'near burnout' (sort by usage / limit ratio descending), 'launching this week' (filter by start date), and 'top performers by uses' for marketing reviews. Inline edits cover expiry, usage limit, and active status — the everyday adjustments that don't need the full coupon-edit screen.
The custom-table side covers loyalty points and store credits. Loyalty points balance per user, last-earned date, and lifetime points become columns in a customers view. Store-credit balances surface per customer or per coupon, useful for finance reconciling credit liabilities or customer success looking up an active credit during a support call. The data layer doesn't change; SleekView just makes it queryable as one screen.
Workflow
From coupon postmeta to a campaign dashboard
Map postmeta
Add custom tables
Save campaign views
Edit inline
Sample columns
A typical coupons view
wp_posts (shop_coupon) + wp_postmeta + Advanced Coupons custom tables (loyalty, store credit)
| Code | Type | Amount | Used | Expires | Status |
|---|---|---|---|---|---|
| SPRING25 | Percentage | 25% | 412/1000 | Apr 30 | Active |
| VIP20 | Fixed cart | €20 | 84/— | — | Active |
| BOGO-T-SHIRT | BOGO | B1G1 | 61/200 | May 15 | Limited |
| OLD-WINTER | Percentage | 30% | 1000/1000 | Mar 01 | Expired |
Comparison
Default Advanced Coupons admin vs SleekView
Default Advanced Coupons admin
- BOGO rules and schedules are buried in tabs
- Usage counts vs limits aren't sortable in the list
- Bulk-extend or bulk-deactivate coupons goes one at a time
- Store-credit balances live in their own screen
- Cross-coupon performance audits require exports
SleekView
- Pivot postmeta (schedules, BOGO type, usage limit) into columns
- Sort by usage % to spot near-exhausted coupons
- Inline-edit expiry, usage limit, and active status
- Filter for expired-but-active or limit-reached coupons
- Surface store-credit balances from the custom tables
Features
What SleekView gives you for Advanced Coupons
Schedule audits
Sort by start and end dates to spot expired-but-still-active coupons or upcoming launches that aren't ready, replacing the per-coupon click-through with a saved schedule view.
Usage triage
Sort by usage / limit ratio to see which coupons are near burnout, then extend or cap them inline before the campaign runs out of redemptions mid-flight.
BOGO + Loyalty + Credits
All three premium features write to predictable storage. SleekView surfaces them as columns and joins where useful, giving finance liability visibility alongside marketing.
Audience
Who uses SleekView for Advanced Coupons
Marketing
Campaign-level coupon performance, near-burnout flags, and bulk extensions during seasonal pushes, with saved views per campaign that load with one click.
Finance
Reconcile store-credit balances and loyalty point liabilities, useful for accounting accruals and end-of-period balance sheet reporting on outstanding obligations.
Customer success
Look up a customer's store credit and active coupons in one place, useful during support calls where the agent needs to see what offers are valid for the caller.
The bigger picture
Why coupon ops needs more than a coupon list
Coupons in modern ecommerce aren't a static promo code list — they're a campaign system. Each coupon has a launch date, an expiry, a usage cap, a BOGO rule structure, audience conditions, and often a connection to loyalty points or store credits. Marketing teams running multi-coupon campaigns need to see the campaign as a whole: which codes are launching, which are near burnout, which expired but stayed active by mistake, which are over-performing and need their cap raised.
The default coupon list answers none of these questions without per-coupon clicks. The result is the spreadsheet workflow — export, pivot, decide, manually update. For seasonal campaigns with twenty or thirty active codes, that's hours of reconciliation that shouldn't be needed.
SleekView treats coupons as the campaign objects they are and gives marketing the dashboard view they were always reaching for. Near-burnout coupons surface themselves. Expired-but-active coupons get caught before they confuse customers.
Loyalty and credit liabilities show up alongside the coupons that drove them, so finance can model the campaign's true cost. The data was always there; it just needed to be a screen instead of a series of post edits.
Questions
Common questions about SleekView for Advanced Coupons
Yes. Coupons stay as shop_coupon posts under HPOS — only orders moved to the new storage. SleekView handles either schema for joins (e.g., when you join coupons to orders to compute usage value or revenue impact). The HPOS toggle doesn't affect coupon-side queries; SleekView reads the same postmeta on either side. Migration is seamless when you flip HPOS on.
Simple BOGO toggles (active, type, basic quantities) edit inline. Complex BOGO rule arrays — multi-product triggers, conditional discounts, nested rules — are best edited in the coupon screen since the JSON structure is too rich for a single-cell editor. SleekView surfaces them as a summary column showing the rule type and a count of products involved, so you can spot anomalies without opening every coupon.
 Store-credit balances live in a custom table per customer. SleekView shows them per customer (in a customers view) or per coupon (where the coupon issued credit) as a column. Useful for finance reconciling credit liabilities at month-end, or for customer success looking up a specific customer's available credit during a support interaction. The data updates in real time as credits are issued or redeemed.
 Loyalty points are stored per user in a dedicated table — current balance, lifetime earned, last earned date. Surface points balance and last-earned date as columns in a customers view. Useful for segmenting high-loyalty customers for VIP campaigns, or for spotting dormant accounts where engaged customers haven't earned points recently and might be slipping away. Combine with order history for a true engagement picture.
 Yes. Inline status edits write through standard WordPress and WooCommerce APIs so usage tracking, notification hooks, and caching layers all run as they would from the coupon-edit screen. The Advanced Coupons usage tracker continues to record applications correctly, the cache invalidates on schedule changes, and any custom hooks your theme or other plugins register fire normally. No special integration needed.
 Yes. Filter for expiring within 7 days, select all, and update expiry inline in one batch. Useful for end-of-quarter campaign extensions where you need to push thirty coupons out by another two weeks without doing it one at a time. The bulk update writes through standard WP hooks, so the change propagates to all caches and any front-end displays of the coupon expiry update accordingly.
 Join coupons to orders by code — each redeemed order references the coupon used. Build a column counting orders per coupon and summing order total. Effective discount per redemption (commission ÷ orders) and revenue-per-coupon both surface at list level. Useful for marketing reviewing campaign ROI without exporting and pivoting in a spreadsheet.
 Yes. Filter by start date in the future to see the launch queue, sorted by date ascending. Useful for marketing reviewing the upcoming calendar — which campaigns are ready, which need creative assets finalised, which have the wrong start date. The view surfaces issues before the coupon goes live and a customer hits a code that doesn't work, which is a customer support call you'd rather not have.
 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