How ComandR Digitized 12-Restaurant Management with a Custom ERP

The Challenge

ComandR managed 12 restaurants with a patchwork of 3 different tools: an Excel spreadsheet for inventory, an outdated scheduling software, and paper purchase orders for suppliers. Data entry errors were costing an average of €2,000 per month in undetected stock discrepancies.

Identified Problems

• Fragmented data: no consolidated view across 12 locations
• Time-consuming manual entry: 12 hours per week spent re-entering data between tools
• Recurring stock errors: discrepancies between theoretical and actual stock undetected until inventory
• No food cost visibility: impossible to calculate profitability per dish in real time
• Scheduling conflicts: overlapping shifts detected too late

Our Approach

We designed a custom all-in-one ERP in 6 weeks, built with Next.js, Supabase, and a multi-tenant architecture allowing each restaurant to operate independently while providing consolidated views to management.

Technical Architecture

• 52+ Supabase tables with Row Level Security for data isolation per location
• Multi-tenant: single deployment, 12 independent workspaces
• Artificial intelligence: computer vision scanning of POS receipts (Z-tickets) and supplier invoices to eliminate manual data entry
• Real-time: stock alerts, scheduling notifications, continuously updated dashboard

Key Features Developed

• Real-time stock management with automatic threshold alerts
• Team scheduling with automatic conflict detection
• Supplier purchasing with billing error detection
• Automatic food cost calculation based on recipes and supplier prices
• Sales analysis and KPIs per location and consolidated
• AI scanning of Z-tickets and delivery invoices

Results

Business Impact

• -40% daily management time for site managers
• Estimated savings of €24,000/year from reduced stock discrepancies
• Data-driven decisions through real-time profitability visibility