SleekView for HBook Hotel Booking: reservations & rooms as tables
HBook stores reservations, rooms, rate plans, and availability in its own custom tables. SleekView pivots check-in date, room, status, and balance due into proper columns, so the front desk can run the day from one filterable view.
♾️ Lifetime License available
Front-desk operations on one screen
HBook stores reservations in wp_hbook_reservations with columns for arrival, departure, room reference, status, customer details, and balance, plus rate and availability data in companion tables like wp_hbook_seasons and wp_hbook_bookable_units. Rooms themselves are configured through the plugin's settings, while every reservation lifecycle event lives in one row of the reservations table.
The default HBook admin offers a reservations list and a calendar view, but cross-room filtering, balance-due queues, and bulk status changes for arrivals all require row-by-row clicks. Columns like balance, status, and the linked unit ID stay hidden until you open each reservation.
SleekView reads wp_hbook_reservations directly, pivots the schedule fields into named columns, and joins to wp_hbook_bookable_units for the room name. Front-desk users get a daily arrivals view, finance gets a balance-due queue, and bulk check-ins route through the plugin's status update so confirmation emails still fire.
Workflow
From the HBook reservations table to a front-desk grid
Point at the reservations table
wp_hbook_reservations as the source and add arrival, departure, status, balance, and guest contact as columns.
Join rooms and rates
wp_hbook_bookable_units for the room name and wp_hbook_seasons for the active rate, so each reservation row shows the unit and the pricing context.
Save front-desk views
Update inline
Sample columns
A typical HBook reservations view
wp_hbook_reservations + wp_hbook_bookable_units + wp_hbook_seasons
| Res # | Arrival | Departure | Room | Guest | Balance | Status |
|---|---|---|---|---|---|---|
| #HB-3091 | May 22 | May 25 | Sea View 2 | alex@studio.co | €0 | Paid |
| #HB-3092 | May 22 | May 24 | Garden 1 | ria@design.io | €120 | Deposit |
| #HB-3093 | May 23 | May 27 | Sea View 1 | tom@hello.dev | €0 | Paid |
| #HB-3094 | May 24 | May 26 | Loft | mia@brew.coop | €340 | Unpaid |
Comparison
Default HBook Hotel Booking admin vs SleekView
Default HBook admin
- Reservations list shows fixed columns, the linked unit and balance aren't inline
- Bulk check-in or status changes go one row at a time
- Balance-due queues aren't a saved view in stock HBook
-
wp_hbook_reservationscolumns likestatusstay hidden from list filters - Per-guest reservation history requires browsing the calendar
SleekView
-
Pivot
wp_hbook_reservationsfields into proper columns - Filter by arrival date, room, and status at the same time
-
Inline-edit reservation
status(pending, deposit, confirmed) -
Join to
wp_hbook_bookable_unitsfor the room name on every row - Save arrival-day, balance-due, and per-room views per user role
Features
What SleekView gives you for HBook Hotel Booking
Daily arrivals view
Filter reservations by today's arrival date, sort by room, and check off check-ins inline. Reception runs the morning from one saved view instead of paging through the calendar.
HBook fields as columns
Arrival, departure, room, status, balance, and guest contact pivot from wp_hbook_reservations into named columns automatically. Every reservation shows full front-desk context in one row.
Inline status edits
Move pending reservations to confirmed or mark cancellations in place. Bulk actions still route through HBook's own status update so confirmation emails fire as expected.
Audience
Who uses SleekView for HBook Hotel Booking
Front desk
Arrivals view filtered to today, with room and balance columns visible. Check guests in inline and chase deposits without opening each reservation.
Finance
Balance-due queue sorted by arrival date. Filter wp_hbook_reservations.balance greater than zero to surface the reservations that still owe a payment.
Owners and managers
Per-room occupancy view for a date range, useful for spotting under-booked units and planning rate changes against wp_hbook_seasons.
The bigger picture
Why hotel reservations need a real front-desk table
A small hotel or villa rental runs on the next twenty-four hours, not on a global list of every reservation. The shape of that work is a flat table by arrival date, room, and status, with balance visible on the same row. HBook stores all the pieces (wp_hbook_reservations for the reservation itself, wp_hbook_bookable_units for rooms, wp_hbook_seasons for pricing), so the data model already supports the question.
The default admin still asks staff to open each reservation to see status, balance, and assigned room together. Multiply that by a dozen arrivals on a Friday and the workflow becomes click-heavy and error-prone. SleekView lays the same data out as a single grid: filter to today, sort by room, check guests in inline, mark deposits paid, and route every change through HBook's own status update so the rest of the plugin keeps working.
The result is fewer tabs open at the front desk and a finance team that can pull a balance-due queue without writing SQL.
Questions
Common questions about SleekView for HBook Hotel Booking
Yes. SleekView joins wp_hbook_reservations with wp_hbook_bookable_units for room names and wp_hbook_seasons for season-aware rates, so the schedule and the price context appear together in one grid.
Yes when SleekView routes through HBook's own status update path. Confirmation, cancellation, and reminder hooks fire on each transition. Direct table writes skip hooks by design, useful only for one-off migrations.
 
Yes. Filter on balance greater than zero and arrival date ahead of today, then save the view. That becomes the front-desk's deposit-chase list, refreshed automatically as new reservations arrive.
Yes. Each property's bookable units sit in wp_hbook_bookable_units with a property reference, so SleekView can scope views by property for chains running multiple hotels on the same install.
Yes. Save a view filtered by the property reference on wp_hbook_bookable_units, then gate the view by user capability. Each property manager logs in and sees only their reservations, all from the same data model.
SleekView focuses on tabular and kanban-style views grouped by date or room. The default HBook calendar tab stays available alongside, for visual month-grid work.
 
Queries are paginated server-side and use indexes that HBook already adds to wp_hbook_reservations. The grid only loads the visible rows, so even a hotel with thousands of reservations per season opens quickly.
Yes. Any saved view exports to CSV with the current filter applied, useful for monthly finance reconciliation or sending an arrivals list to a partner like a transfer service.
 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 Stock Notifier
- Woocommerce Splitit
- Gooten Print On Demand
- Woocommerce Instamojo
- Woocommerce One Page Checkout
- Edd Fes Frontend Submissions
- Yith Woocommerce Color And Label Variations
- Woocommerce Pdf Vouchers
- Woocommerce Product Addons Pro
- Woocommerce Bulk Edit Products
- Yith Woocommerce Wishlist
- Etsy Shop Importer
- Woocommerce Grouped Products Pro
- Order Status Manager
- Woocommerce Fortnox Integration