Dashboard
WooCommerce → Webkul Addons → Auctions Dashboard — ?page=wkafw-dashboard
The dashboard answers "how is my auction site doing right now?" in one screen — KPIs, charts, and a live feed of recent activity. Built on Chart.js, fully HPOS-aware, queries your real data with prepared statements.

Date range
Top-right of the hero strip: 7 D / 30 D / 90 D buttons. The selected range filters every chart and the bids-per-day series, but not the KPI cards — those use whole-database totals where stated.
The active range is encoded in the URL (?range=30) so bookmarks remember it.
KPI row
Four metric cards across the top.
| Card | Numerator | Note |
|---|---|---|
| Total Auctions | All-time count, all statuses | Sub-line shows current active count |
| Bids Today | Bids placed since 00:00 (site TZ) | Sub-line shows last-7-day count |
| Live Bid Pool | Σ current_price for active + scheduled only | Sub-line: live lot count + average price |
| Settled Revenue | Platform revenue from completed auction-flagged orders | Sub-line: linked-order count + fees |
Settled vs Total revenue
Settled Revenue is winner-paid auctions only. Total Revenue (in the sub-line as + X fees) adds platform fees and listing fees. The two can diverge when you collect non-winner fees (listing, featured boost, late penalty).
Chart row 1 — trends
Revenue & Bid Activity (dual-axis line)
- Gold line — daily revenue (left axis, currency)
- Emerald line — daily bid count (right axis, integer)
Hover any point to see exact values for that day.
Auction Status (donut)
Counts of every auction by status — active, scheduled, ended, paid, failed, paused, cancelled. Custom legend on the right shows count per slice.
Chart row 2 — distribution
Top 5 Auctions by Bids (horizontal bar)
The five most-contested lots in the date range, by bid count. Long titles are truncated with ….
Bids by Hour of Day (bar — last 7 days)
24-hour bar chart. Bar opacity scales with traffic — heaviest hours appear darkest. Useful for picking auction end times.
Bottom row — leaderboards
Top Bidders
The 5 most-active users in the range. Click a row to drill into their bid history (planned).
Recent Activity
The latest 10 entries from wkafw_auction_logs. Each entry shows:
- Action — humanized log type (e.g. Bid Placed, Auction Started, Reserve Met)
- Details — log payload (truncated)
- Auction link — auction ID hyperlinked to All Auctions filtered to that ID
- User — bidder's display name or "System" for cron events
- Time — formatted per WordPress time settings
What it does NOT show
- Real-time bid stream — see Audit Log for that
- Per-vendor revenue split — see Reports
- Failed-payment / overdue lots — see Reports → Payment Status
Performance
Every dashboard query is bounded — counts run over indexed columns, charts use only the selected date window, top-N tables are capped at 5 rows, recent activity at 10. On a database with 100k auctions and 1M bids the page loads in under 800 ms. If you want it even faster, page-cache the dashboard — auctions don't need real-time data on the admin overview.
Troubleshooting
| Symptom | Fix |
|---|---|
| All KPIs read 0 | New install — create a test auction and place a bid |
| Charts don't load | Check the browser console for chart-library errors; ensure no ad-blocker is blocking them |
| Settled Revenue differs from WooCommerce reports | Auction revenue only counts orders that came from a winning auction bid |
| "No activity recorded yet" persists | Cron isn't running — see Troubleshooting |
