SleekView for WooCommerce PDF Vouchers: voucher codes as audit tables
Voucher codes, expiry dates, redemption status, and recipient emails all live in wp_woo_vou_* tables and the woovouchers post type. SleekView surfaces them as one searchable, inline-editable workspace.
♾️ Lifetime License available
Voucher ops without per-code clicks
WooCommerce PDF Vouchers stores voucher templates as a woovouchers custom post type and tracks issued codes, redemption events, and recipient data in dedicated tables: wp_woo_vou_purchased_codes, wp_woo_vou_redeem_data, wp_woo_vou_downloads, and a handful of supporting tables for vendor and emailing data.
The default plugin admin gives you a per-voucher screen and separate redemption logs. Finding every voucher expiring next month, or every code redeemed in the last 24 hours, or every recipient who hasn't downloaded their PDF, means switching between screens or writing SQL. SleekView reads all of those tables together so you build the workspace you actually need: an expiry queue sorted by date, a redemption audit filtered by location, a vendor view scoped per shop.
Inline edits to voucher status route through the plugin's own update path where supported, so emailing logic, expiry hooks, and PDF regeneration fire normally. Bulk-extend expiry dates on 50 vouchers in one action if a venue closes for a week, without opening each voucher's post screen.
Workflow
From PDF generation to voucher operations
Read the voucher tables
woo_vou_purchased_codes, woo_vou_redeem_data, and woo_vou_downloads, joined with the woovouchers post type and the parent WooCommerce order.
Compose audit columns
Save views per workflow
Bulk-update and re-send
Sample columns
A typical voucher audit view
wp_woo_vou_purchased_codes joined with the parent voucher post and the order it belongs to.
wp_woo_vou_purchased_codes + wp_woo_vou_redeem_data + wp_posts (post_type=woovouchers)
| Code | Voucher | Recipient | Status | Order | Expires |
|---|---|---|---|---|---|
| SPA-4821 | Spa day pass | alex@studio.co | Active | #10428 | Aug 24 |
| SPA-4820 | Spa day pass | ria@design.io | Pending | #10427 | Aug 24 |
| DIN-2210 | Dinner for two | tom@hello.dev | Redeemed | #10426 | Jul 23 |
| DIN-2209 | Dinner for two | mia@brew.coop | Expired | #10412 | May 23 |
Comparison
Default WooCommerce PDF Vouchers admin vs SleekView
Default PDF Vouchers admin
- Voucher codes, redemptions, and downloads each live on separate admin screens
- Cross-table joins (codes to order to recipient) need custom queries
- Bulk-extending expiry dates means opening each voucher individually
- No saved views for "expiring this month" or "redeemed but not downloaded"
- Vendor-scoped views (when running multi-vendor) require third-party tooling
SleekView
-
Read from
woo_vou_purchased_codes,woo_vou_redeem_data,woo_vou_downloadstogether -
Filter by
expiry_date,redeem_status, orrecipient_emailin one view - Bulk-extend expiry dates across a filtered set of codes
- Audit redemption history with location and timestamp inline
- Save vendor-scoped views when running multi-vendor stores
Features
What SleekView gives you for WooCommerce PDF Vouchers
Voucher code audit
All issued codes from woo_vou_purchased_codes in one table with status, recipient email, parent voucher, and order id columns. Filter by status to find every code that needs follow-up.
Expiry queue
Sort by expiry_date to see what expires next week, next month, or already lapsed. Bulk-extend expiry across a filtered set if a venue closes or a campaign extends.
Redemption history
woo_vou_redeem_data as its own view with timestamp, location, and redeeming-user columns. Useful for venue-side audits and refund disputes.
Audience
Who uses SleekView for WooCommerce PDF Vouchers
Customer support
Look up a voucher by recipient email, see status, expiry, and download history without leaving WP Admin. Re-send PDF inline if the original email bounced.
Operations and venues
Daily redemption queue filtered by venue or product, plus an expiring-soon view to flag stock before vouchers lapse. Bulk-extend expiry when an event date slips.
Finance and audit
Reconcile redeemed vs unredeemed voucher liability monthly. Sort by issue date and total value to see what's still on the books, exportable for the bookkeeper.
The bigger picture
Why voucher ops outgrow per-screen admins
Vouchers are an outlier in WooCommerce because they live on the books long after the order is paid. A normal order is done the moment the customer pays. A voucher might be issued in January, gifted in February, and redeemed in November (or never).
That long tail forces ops, support, and finance into ongoing workflows the default plugin admin doesn't fit. Support needs to look up codes by recipient email mid-call. Ops needs the expiry queue weekly so vouchers don't lapse silently with paid liability still on the books.
Finance needs unredeemed value summed per month for the bookkeeper. SleekView reads the same woo_vou_* tables the plugin already maintains and turns them into the audit and operations workspace each role needs. Bulk-extending expiry across a filtered set replaces the per-code click marathon.
Saved views replace the SQL scripts ops would otherwise rebuild every cycle. The PDF generation and email delivery stay where they are, untouched.
Questions
Common questions about SleekView for WooCommerce PDF Vouchers
No replacement, just an additional surface. The default plugin admin keeps doing PDF generation, email delivery, and template editing. SleekView reads the same database tables so ops and support get a row-level workspace alongside the existing admin.
 
Yes. Writes route through the plugin's update path where supported, so emailing, expiry, and PDF regeneration hooks fire normally. Bulk extending expiry_date across a filtered set runs through the same path per row, no shortcut that skips hook logic.
Yes. When the plugin's multi-vendor add-on is active, vendor id is exposed as a column and a filter, so per-vendor scoped views work directly. Without the add-on, vendor data isn't recorded and the column simply isn't available.
 
woo_vou_downloads appears as its own view with timestamp, recipient email, and PDF id columns. Joinable back to the parent voucher or order for a download audit, useful when a customer claims they never received a code.
Where the plugin records venue or location data in woo_vou_redeem_data, yes. Add the column to the redemption view and group by location to see daily redemption counts per venue. Configuration depends on which redemption flow the store uses.
Yes. Build a view of woo_vou_purchased_codes filtered to status != redeemed and status != expired, with total value summed. That's the unredeemed liability sitting on the books at a point in time, exportable monthly for the bookkeeper.
Recipient data is stored in woo_vou_purchased_codes with email and (optionally) name and message. SleekView's export covers those rows, useful for fulfilling a per-recipient data export request without a separate WP-CLI script.
Queries hit indexed columns (id, code, expiry_date, recipient_email) on woo_vou_purchased_codes. Aggregate columns (total redeemed per voucher) are opt-in per view since they require sub-queries, keep them off triage views and on dedicated reporting views for fast page loads.
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 Stripe Gateway
- Woocommerce Gift Ultimate
- Yith Woocommerce Sales Countdown
- Woocommerce Checkout Fees
- Wcfm Bookings
- Woocommerce Grouped Products Pro
- Mvx Marketplace
- Woocommerce Correios Brazil
- Woocommerce Colissimo
- Woocommerce Sendcloud
- Woocommerce Google Analytics Pro
- Woocommerce Quickbooks
- Woocommerce Shipping Dhl
- Wpc Frequently Bought Together
- Woocommerce Zoho Books
- Paid Member Subscriptions
- Lifterlms Pro Membership
- Magic Members
- Wp Members
- Wishlist Registration
- Buddypress Media
- Ultimatemember Bbpress
- Wp Private Content Plus
- Wishlist Member X
- Buddydrive
- Members Content
- Ultimatemember Private Content
- Wp Affiliate Platform
- Paid Memberships Pro Addons
- Memberpress Importer