SleekView for WooCommerce Lottery: lottery entries & draws as tables
Read lottery post types (commonly lottery) and ticket meta from wp_postmeta, joined to orders via shop_order or wc_orders. Audit entries per draw, manage closed-status flips, and surface winner data in one view.
♾️ Lifetime License available
Lottery operations, finally a real audit table
Lottery plugins for WooCommerce model lotteries and prize draws as a custom post type (often lottery) with associated ticket records linked back to orders. Ticket data lives in wp_postmeta against the lottery or in a dedicated ticket table, depending on the plugin. The default admin shows a list of lotteries with their status (open, closed, drawn) and limited filters; auditing entries per lottery means opening each lottery page and scrolling through purchases.
SleekView reads the lottery post type and ticket data directly, joining to the order tables (wc_orders on HPOS or shop_order on legacy) so each row carries draw, ticket number, customer email, order total, and entry timestamp. Saved views: "open lotteries closing within 7 days", "unprocessed winners awaiting payout", "customers with most entries across draws". Inline-flip a lottery from open to closed when its window expires; the plugin's draw-trigger hook then fires through standard wp_update_post writes.
This is especially important for fundraising stores and prize-draw promotions where audit trails matter: every ticket should be traceable to an order and a customer, every status transition should be hooked into the plugin's notification logic, and bulk operations should never bypass that logic. SleekView preserves both.
Workflow
How SleekView reads your lottery data
Pick the lottery source
lottery post type and its ticket meta (or dedicated ticket table where present). SleekView detects whichever the plugin writes to and surfaces matching columns.
Compose audit columns
wc_orders or shop_order), entry status, refund status, and any winner / payout meta.
Save lifecycle views
Close, draw, payout inline
wp_update_post, update payout status as wires clear, mark entries voided when their order refunds. All writes go through standard WP APIs.
Sample columns
A typical lottery entries view
lottery post type with ticket meta and the order tables for per-ticket audit rows.
wp_posts (post_type=lottery) + wp_postmeta (ticket meta) + wp_wc_orders (or wp_posts post_type=shop_order)
| Lottery | Ticket | Customer | Order | Order total | Entry status |
|---|---|---|---|---|---|
| Summer Charity Draw | T-1042 | alex@studio.co | #10428 | £25.00 | Entered |
| Summer Charity Draw | T-1041 | ria@design.io | #10427 | £25.00 | Entered |
| Vintage Camera Raffle | T-2017 | tom@hello.dev | #10426 | £5.00 | Pending payment |
| Summer Charity Draw | T-1040 | mia@brew.coop | #10425 | £25.00 | Refunded |
Comparison
Default WooCommerce Lottery admin vs SleekView
Default WooCommerce Lottery admin
- Per-lottery ticket lists with no cross-lottery audit view
-
Ticket meta in
wp_postmetaisn't exposed as filterable columns - Winners and payout status aren't always joined into a single workspace
- Bulk status flips (close lottery, mark drawn) are awkward across many lotteries
- Customer cross-lottery history ("how many draws have they entered") is hard to inspect
SleekView
- Cross-lottery audit view with ticket, customer, and order joined inline
- Winner / payout status as a column, filterable across draws
- Inline-close lotteries with the plugin's draw-trigger hook firing
- Per-customer entry history view ("top 50 entrants this quarter")
- Save scoped views per role (operations, finance, support)
Features
What SleekView gives you for WooCommerce Lottery
Per-ticket audit table
Every ticket as a row joined to its lottery, order, and customer. Surfaces ticket number, entry timestamp, order total, and refund status in one view, no per-lottery click-through.
Closing-soon dashboard
Saved view: lotteries with close date in the next 7 days, sorted by ticket count. Lets the operations lead know which draws need final pushes and which are ready to close.
Winners and payout queue
Filter to drawn lotteries with a winner_user_id set and payout status pending. Inline-edit payout status as wires clear, keeping the winners list and accounting log in sync.
Audience
Who uses SleekView for WooCommerce Lottery
Operations
Closing-soon dashboard, post-close audit, and winners-payout queue. One workspace for the whole draw lifecycle, with cross-lottery views replacing per-lottery clicks.
Finance
Order joined with lottery audit, filtered by date range and currency. Useful for charity reconciliation and for matching prize payouts to original ticket purchases by order ID.
Support
Per-customer entry history: every lottery a customer has entered, every ticket number, every refund. Resolves "did my entry go through" questions in one screen.
The bigger picture
Why lottery operations need cross-draw visibility
WooCommerce lottery plugins solve a specific commerce problem well: selling tickets, picking winners, notifying customers, sometimes generating compliance receipts for charity draws. The plugin's storefront and per-lottery admin do the heavy lifting. The gap is operational visibility across the lifecycle.
Once a store runs more than two or three concurrent lotteries, the operations lead needs a single place to see closing-soon draws, post-close ticket counts, winners awaiting payout, and refunded entries that should not enter the prize pool. Without that, draws get closed late, payouts slip, and refunded buyers occasionally appear in the winners pool, all small problems that compound into trust issues with the customer base. SleekView turns the lottery post type, ticket meta, and order joins into one auditable workspace.
Operations sees the lifecycle, finance sees the reconciliation, support sees per-customer entry history, and every status transition still routes through the plugin's existing hooks. Same plugin, same draw logic, dramatically less risk of an entry slipping through the cracks.
Questions
Common questions about SleekView for WooCommerce Lottery
WooCommerce Lottery from WC Lovers (and similar plugins). The pattern is the same across most: a lottery post type, ticket meta in wp_postmeta or a dedicated ticket table, and entries linked back to shop_order or wc_orders. SleekView detects the schema and exposes matching columns.
Yes. The ticket table or postmeta surfaces as the primary source, joined to the parent lottery and the originating order. Each row shows ticket number, entry timestamp, customer, and the order context. Useful for both audit and customer support.
 
Yes. On HPOS, the join is against wc_orders and wc_orders_meta; on legacy, it's against shop_order posts and postmeta. SleekView detects which is active and uses the right path automatically, so the same lottery audit view works across both.
If your plugin attaches the draw logic to a status-change hook, yes. The status write routes through wp_update_post with all hooks attached, so any drawing automation fires exactly as it would from the per-lottery edit screen. If the plugin requires a separate "draw now" action, you can still bulk-close from SleekView and trigger the draw step from the lottery's own admin afterwards.
Yes. Filtered views export to CSV with the columns you have configured. Charity-draw operators often export per-draw ticket lists with customer email, order ID, and order total to attach to compliance reports.
 
Yes, if the plugin writes winner_user_id or similar postmeta on the lottery post when the draw runs. A winners view filters lotteries with a winner set and a payout status not yet paid, useful for tracking the post-draw payout queue.
Yes. The join to the order table surfaces refund status; a saved view filters tickets whose originating order is refunded so you can void those entries before the draw runs. Without this, refunded buyers can accidentally enter the prize pool.
 Ticket queries hit indexed columns (ticket id, lottery id, order id) directly. Aggregate views (per-customer entry count, per-lottery ticket count) are computed at query time and add some overhead; keep aggregates off the per-ticket triage views and on dedicated summary views to keep query plans fast.
 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 Prices By User Role
- Woocommerce Table Rate Shipping
- Printful Integration
- Yith Essential Kit
- Edd Aweber
- Woocommerce Tiered Pricing
- Linnworks Wp
- Thirstyaffiliates
- Yith Woocommerce Product Reviews
- Variation Swatches
- Woocommerce Currency Per Product
- Woocommerce Back In Stock
- Charitable
- Yith Woocommerce Anti Fraud
- Woocommerce Shipping Multiple Addresses
- Content Locker Pro
- Ihc Membership
- Paid Memberships Pro Addons
- Memberpress Corporate
- Simple Membership
- Subscriber Only
- Joinup Membership
- Membership 2 Pro
- Memberium For Activecampaign
- Wp Affiliate Platform
- Wishlist Quickfront
- Ultimatemember Mailchimp
- User Role Membership
- Wishlist Registration
- Ontrapages