SleekView Charts for VikBooking: hotel dashboards
VikBooking spreads reservations across vikbooking_orders, ordernags, rooms, and ratesetup tables. SleekView Charts joins them once and renders dashboards a hotel reception, a revenue manager, or finance can use without writing any SQL.
♾️ Lifetime License available
Hotel reservations on chart cards
VikBooking stores each reservation as a row in wp_vikbooking_orders, with check-in, check-out, total, and status. Per-reservation room nights link through wp_vikbooking_ordernags to wp_vikbooking_rooms, and per-room rate plans live in wp_vikbooking_ratesetup. The native admin shows a clean orders list with calendar drilldowns, which suits day-to-day triage and limits any cross-room review of occupancy, ADR, or revenue trends.
SleekView Charts joins those tables into one chart dataset. A revenue dashboard pins this month's reservations as a Number, charts the status mix as a Donut, ranks rooms by room nights sold as a horizontal Bar, and plots daily revenue as an Area chart across the selected date range. Each card reads from the same join, so a date filter at the dashboard level cascades to every card without per-card duplication.
Aggregations run through indexes VikBooking already maintains on order, room, and rate tables. A multi-room hotel install with years of reservation history renders the whole dashboard in well under a second on a typical host.
Workflow
Join VikBooking tables into one dataset
Source from vikbooking_orders
wp_vikbooking_orders as the dataset base. Each row is one reservation with check-in, check-out, total, and status ready as columns alongside the linked room-night and rate-plan tables.
Join rooms and rate plans
wp_vikbooking_ordernags, wp_vikbooking_rooms, and wp_vikbooking_ratesetup onto the order dataset. Room name, room nights, and rate plan land alongside each order row for richer charts.
Configure four chart cards
Save per-role chart boards
Sample dashboard
Charts you can build from VikBooking data
Reservations confirmed this month
wp_vikbooking_orders with confirmed status whose check-in date falls in the current month, with the previous month's number underneath for week-on-week context for revenue.
Count
Reservation status mix this week
wp_vikbooking_orders. Surfaces the share of reservations needing attention this week across the hotel.
Count
group by status
Top rooms by room nights sold
wp_vikbooking_rooms through wp_vikbooking_ordernags. Surfaces top sellers and underused rooms for revenue manager planning weekly.
Sum(room_nights)
group by room_id
Daily revenue trend chart
wp_vikbooking_orders. Useful for spotting seasonal patterns and revenue impact of rate-plan promotions across the year.
Sum(total)
group by checkin_date
Comparison
Default VikBooking admin vs SleekView Charts
VikBooking admin views
- VikBooking ships an orders list and per-room calendar, not charts
- Per-room room-nights rankings require counting across paginated views
- Status-mix donuts and rate-plan revenue charts are not surfaced natively
- Daily revenue trend across a selectable date range is not built into admin
- No saved per-role chart boards for reception, revenue, or finance teams
SleekView Charts
-
Cards built on
wp_vikbooking_ordersjoined to rooms and rate plans - Number, Donut, Bar, and Area cards mapped to real VikBooking columns
- Dashboard-level filters cascade across every chart card on the board
- Room-nights rankings and revenue trends rendered without manual exports
- Per-role boards gated by WordPress capabilities for clean separation
Features
What SleekView Charts gives you for VikBooking Hotel Booking Engine
Cards, not paginated admin lists
Pick the dimension, the metric, and the chart type per card. Build a room-nights ranking bar one week and switch to a rate-plan revenue donut the next, without leaving the WordPress admin or touching theme code at all today.
Orders and rooms joined
Orders, room-night rows, rooms, and rate plans join into one SleekView dataset, so every chart card on the dashboard reads from the same join and groupings stay consistent across the whole hotel saved board.
Per-role saved chart boards
Reception, revenue managers, and finance each save the board they care about. WordPress capability gating decides who opens which dashboard so each role lands on the right chart view by default.
Audience
Who builds VikBooking charts dashboards with SleekView
Front desk and reception
Today's arrivals, this week's reservation count, and pending confirmations visible in one dashboard before each shift. Replaces eyeballing the order list with a single chart view.
Revenue and hotel managers
Room-nights rankings, rate-plan revenue mix, and weekly trend on one board. Pricing decisions and inventory plans run off the same chart view across the whole hotel inventory.
Finance and bookkeeping
Paid versus unpaid totals, refund counts, and revenue by room or rate plan filtered by date range. Month-end reconciliation runs from a saved chart board, not a CSV export pivot exercise.
The bigger picture
Why hotels need a real chart layer on bookings
VikBooking handles the booking engine cleanly: the form, the inventory lock, the rate plan, the OTA channel manager. What it doesn't do is summarise across rooms, rate plans, or revenue trends in any flexible way. Hotel managers ask the same handful of questions every week: which room sells the most nights, which rate plan drives most of the revenue, what occupancy looks like next weekend, what share of arrivals still owe payment.
Each question is one chart against the VikBooking tables that already live inside WordPress. SleekView Charts gives that dataset a rendering layer with cards that map cleanly to operational questions: Number for the headline KPI, Donut for the status share, Bar for the room ranking, Area for the revenue trend. The booking engine keeps owning per-reservation triage, the chart board gives the team the revenue-management view that pure plugin admin has never delivered to hotel operators directly.
Questions
Common questions about SleekView Charts for VikBooking Hotel Booking Engine
No. The VikBooking orders list and per-room calendar stay where they are. SleekView Charts sits alongside as a configurable layer so reception, revenue managers, and finance each get the chart dashboards the plugin doesn't ship today, without changing how the booking engine works on the frontend or with channels.
Yes. Per-reservation custom guest fields collected on the booking form can be pivoted into typed columns. SleekView uses each typed column as a chart's groupBy or valueColumn, so custom intake fields become charts without writing any custom SQL or PHP for the data path.
wp_vikbooking_ordernags joins onto orders for room-night rows, then wp_vikbooking_rooms and wp_vikbooking_ratesetup resolve the room and rate plan. A single saved configuration drives the join, so every chart card uses the same mapping consistently across reloads.
Yes. A Sum aggregation on the room_nights column from wp_vikbooking_ordernags, grouped by check-in date, gives the daily occupancy. Adjust the dashboard date range and the chart scopes automatically, useful for next-month planning and historical comparisons across the hotel.
Yes. A date range, room filter, or rate-plan filter at the dashboard level cascades to each card on the board. A weekly revenue review and a quarterly trend can share the same saved configuration without duplicating filter selections card by card every time a user opens it again.
Cards query the live VikBooking tables on render. A new reservation booked from the frontend engine or an OTA channel manager push appears in every card on the next reload, with no separate sync, scheduled refresh, or cache flush step between the event and the chart update.
Yes. Aggregations run server-side using the indexes VikBooking already maintains on its order, room, and rate tables. A multi-room hotel install with years of reservation history renders the whole chart board in well under a second on a typical Kinsta host today consistently.
Yes. Each saved board is gated by a WordPress capability so reception, revenue managers, and finance each open the dashboard that matches their job. The room-nights ranking board and the finance revenue board stay separate by default for each user logging in to the admin every shift.
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 Tab Manager
- Metorik Helper
- Woocommerce Anti Fraud
- Easy Digital Downloads
- Edd Frontend Submissions
- Woocommerce Advanced Product Labels
- Woo Razorpay
- Woocommerce Pre Orders
- Woocommerce Product Bundles
- Woocommerce Store Credit
- Woo Checkout Field Editor Pro
- Putler Woocommerce Integration
- Mercado Pago Payments For Woocommerce
- Woocommerce Services
- Variation Swatches