✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView table view for WooCommerce Lottery

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

1

Pick the lottery source

The lottery post type and its ticket meta (or dedicated ticket table where present). SleekView detects whichever the plugin writes to and surfaces matching columns.
2

Compose audit columns

Add lottery title, ticket number, customer email, order ID and total (joined from wc_orders or shop_order), entry status, refund status, and any winner / payout meta.
3

Save lifecycle views

Name views like "Closing in 7 days", "Drawn awaiting payout", "Refunded entries to void" and gate by capability so operations, finance, and support each get the right scope.
4

Close, draw, payout inline

Bulk-close lotteries with draw hooks firing through 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

Joins the lottery post type with ticket meta and the order tables for per-ticket audit rows.
Source: 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_postmeta isn'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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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