Project Overview
DineWiz Hub is a comprehensive cloud-native restaurant management platform built for Ebru Coffee Co. to manage multi-location operations efficiently. The system replaces spreadsheets and disconnected tools with a unified SaaS platform that integrates inventory, scheduling, recipe costing, analytics, and AI-powered features. The platform provides real-time visibility across locations, enabling data-driven decisions, reducing food waste, and improving operational consistency. With a modular architecture, businesses can enable or disable features based on their needs, making the system highly scalable and adaptable for both small cafés and enterprise-level restaurant chains.
Overview
Key Challenges
Ebru Coffee Co. struggled with fragmented systems, spreadsheets, and manual workflows across multiple locations, leading to inefficiencies in inventory management, employee scheduling, and operational consistency. Managing FIFO inventory, real-time scheduling, recipe costing, and multi-location coordination created significant complexity.
Our Solution
We built DineWiz Hub, a cloud-native SaaS platform with 18+ modular features including inventory management, employee scheduling, recipe costing, AI-powered invoice processing, and real-time analytics. The system uses a modular architecture with Supabase backend, React frontend, and Edge Functions for secure processing, enabling real-time synchronization, FIFO inventory tracking, public schedule APIs, and multi-location operational control.
Project Performance Metrics
Technical Details
Technical Architecture
Technical Features
Security Measures
- Row-Level Security (RLS) for multi-tenant data isolation
- Secure Edge Functions for sensitive operations
- Role-based access control with permission layers
- API key protection via server-side proxies
Scalability Features
- Modular feature toggle system
- Serverless backend with auto-scaling
- Optimistic UI updates with rollback handling
- Real-time subscriptions for instant updates
Testing Coverage
Detailed Solution
A modular, cloud-native restaurant operating system designed to unify inventory, workforce, analytics, and AI-powered automation across multi-location businesses.
Modular SaaS Platform Architecture
- •Feature-based modular system with enable/disable capability per restaurant
- •Multi-tenant architecture with strict row-level security (RLS)
- •Real-time synchronization across all operational modules
- •Scalable serverless backend using Supabase and Edge Functions
- •Designed as a unified operating system replacing spreadsheets and tools
Multi-Location SaaS Infrastructure
- •Multi-tenant system with strict data isolation
- •Location-based configuration and workflows
- •Google Maps & Places integration for location management
- •Serverless architecture with automatic scaling
Performance & Data Integrity
- •Optimistic UI with rollback handling for reliability
- •Real-time subscriptions for instant updates
- •Snapshot architecture for critical data consistency
- •Secure Edge Functions for sensitive operations
Inventory & FIFO Management System
- •FIFO-based inventory tracking with lot-level precision
- •Automated inventory depletion linked to menu sales
- •PAR-level stock management with daily stock sheets
- •Real-time cost-of-goods-sold (COGS) tracking
- •Vendor-linked inventory and procurement workflows
Workforce & Scheduling Engine
- •Weekly employee scheduling with templates and automation
- •Public schedule API with real-time publishing
- •Role-based team management with permissions
- •Snapshot-based schedule versioning system
Recipe & Menu Intelligence
- •Recipe-to-menu linking with automatic ingredient mapping
- •Dynamic cost calculation based on inventory lots
- •Menu management with category hierarchy
AI Automation Layer
- •AI-powered invoice OCR for automated data extraction
- •Smart menu import and analysis using GPT models
- •Reduced manual data entry and operational overhead
Real-Time Analytics System
- •Central dashboard with live KPIs and alerts
- •Sales, labor, and inventory insights
- •Data-driven decision-making across locations
Implementation & Infrastructure
A) Platform Architecture (SPA + Serverless)
The platform is built as a Single Page Application (SPA) using React, with a clear separation between frontend and backend. Supabase powers the backend with PostgreSQL, authentication, and Edge Functions, enabling a fully serverless, scalable architecture.
B) Core Technical Decisions
- Module toggle system to enable/disable features per restaurant
- Optimistic UI updates using React Query with rollback handling
- Real-time subscriptions for scheduling and inventory updates
- Snapshot architecture for immutable schedule publishing
- Secure Edge Functions for sensitive backend operations
- Timezone-aware system for accurate multi-location operations
C) Three-Tier System Architecture
The system follows a scalable three-tier architecture optimized for performance, maintainability, and global deployment.
Client Tier (React SPA)
- Vite-powered build with code splitting
- shadcn/ui components with custom branding
- Zustand for global state management
- React Query for server state handling
- Mobile-optimized responsive UI
API Tier (Edge Functions)
- Deno-based globally deployed functions
- Public schedule API with snapshot serving
- OCR pipeline for invoice processing
- AI menu analysis via GPT integration
- Secure team/user management APIs
Data Tier (PostgreSQL)
- 35+ relational tables with foreign keys
- Row-Level Security (RLS) for isolation
- Security-definer functions for roles
- JSONB for flexible schema storage
- Indexed queries for performance
Real-Time & Performance
- Real-time updates via Supabase subscriptions
- Optimistic UI for faster user experience
- Indexed queries and optimized API responses
Security & Data Integrity
- Row-Level Security for strict tenant isolation
- Secure Edge Functions with protected keys
- Role-based access control system
Gallery
Visual transformation showcasing the dramatic improvements across all interfaces
"DineWiz Hub has completely transformed how we manage our multi-location operations. From inventory to scheduling, everything is now streamlined and data-driven."
Ebru Coffee Co.
Management Team
Project Details
Duration
Ongoing (Initial Launch Phase Completed)
Industry
Food & Beverage / Hospitality
Team
Product Owner / Domain Expert, Full-Stack Developer, AI Development Assistant, QA & Operations
Technologies Used
Project Goals
- Eliminate Spreadsheet Dependency: Replace all paper and spreadsheet-based workflows with digital, auditable processes
- Centralize Operations: Provide a single dashboard for all restaurant management activities across locations
- Enable Data-Driven Decisions: Surface real-time analytics on sales, inventory, and labor costs
- Reduce Food Waste: Implement FIFO inventory tracking and PAR-level management to minimize spoilage
- Streamline Scheduling: Reduce schedule creation time from hours to minutes with template-based shifts and one-click publishing
- Ensure Data Security: Implement row-level security to isolate tenant data and enforce role-based access
- Support Specialty Coffee Operations: Provide domain-specific tools for green coffee contracts, roast logging, and retail sales
- Maintain Operational Consistency: Standardize processes across locations through recipe books, checklists, and automated workflows
