What this system does
A full-stack point-of-sale and operations platform built for Scottish Inns & Suites IAH Airport West — a 30-room motel near Houston, TX. It replaces manual tracking with a real-time, role-based system covering every layer of daily operations: sales, inventory, staff, shifts, reports, and guest ordering.
System modules
⊙
Overview Dashboard
Live KPI cards (sales, orders, pending, low stock), sales heatmap by hour and day, restock suggestions, and a live countdown to the weekly automated report.
◷
Orders
Full order history with status filters (pending, collected, no-show, deleted), search by pickup ID/room/worker/guest, discount tracking with reasons, and gift order support.
▤
Front Desk Inventory
Two separate systems in one: sellable items for guest orders, and housekeeping supplies that never appear on receipts. Stock tracking, low-stock alerts, restock logs, and audit trails.
◈
Vending Machine
Dedicated inventory management for the vending machine with its own restock log, audit system, and real-time sync. Completely separate from front desk stock.
◉
Staff Management
Create worker accounts with roles (admin vs worker), manage 4-digit PINs, reset passwords, activate/deactivate staff. Credentials are protected and only visible to admins.
◧
Sessions & Shifts
Every worker shift tracked with a unique ID (S-0001 format). Stores start time, end time, total sales, and order count. Admin can force-close shifts. Full shift PDFs downloadable.
◫
Reports
Sales analytics with 7/30/90/custom date ranges, period-over-period comparison, top items by revenue, and audit history. PDF exports: sales, housekeeping, inventory, shift, audit, weekly email.
⌘
Activity Log
Every action in the system logged in real time — order status changes, inventory restocks, shift events, audits, admin actions — with who did it and when.
↓
Admin Downloads
Instant PDF lookup by ID — enter any Pickup ID to download that order's receipt, or any Shift ID to download that shift's full report. No date range hunting needed.
→
Worker POS
Separate interface for front desk workers. Shift gate enforced — no sales without an active shift. Supports walk-up sales, room orders, gift orders, and discounts with reasons.
→
Guest Ordering
Guests scan a QR code in their room to order items. Server-side rate limiting prevents abuse. Orders appear live on the admin and worker dashboards.
Weekly Report Email
Automated weekly PDF report emailed every Monday at 8 AM. Covers sales, top items, shift summaries, and inventory status. Can be triggered manually anytime from the Overview tab.
Security features
Admin lock screen — 4-digit PIN, locks after 5 minutes of inactivity, persists through page refresh, 5-attempt lockout with forced sign-out
Role-based access — admins see everything, workers only see their POS and shifts, guests only see order submission
Rate limiting — guest order submissions are rate-limited server-side (max 2 per room per 3 minutes) to prevent abuse
Audit suppression — auto-lock is disabled while an inventory audit is in progress so work isn't lost mid-count
Technology stack
React 18
Vite
Supabase (PostgreSQL)
Supabase Auth
Supabase Realtime
Cloudflare Pages
Cloudflare Functions
Resend (email)
jsPDF + autoTable
Row Level Security
Why the live admin isn't shown publicly
This is a demo with placeholder data. The live system at scottishinnpos.com contains real guest names, room numbers, financial records, worker credentials, and shift history for an actively operating motel. Sharing that publicly would be a direct privacy violation and operational security risk. This interactive demo is built from the exact source code and reflects the real interface — only the data is fictional.