Pistoria & Passion Cakes PH ERP
Custom Bakery Operating System & Wholesale Landing Platform
Transformed manual bakery operations into a centralized digital ERP consolidating dynamic recipe costing, ingredient inventory, daily bake schedules, and wholesale orders.
The Problem & Friction
Wholesale bakery production faced compounding operational friction across order intake, variable ingredient price fluctuations, and manual batch scheduling.
- ✕Uncalibrated recipe costing leading to unmonitored profit margin compression when ingredient prices spiked.
- ✕Manual daily bake planning on paper sheets causing inventory overages and ingredient waste.
- ✕Disjointed order intake between wholesale inquiries, custom orders, and kitchen production queues.
Strategy & Approach
Architected a dual-surface solution: a conversion-oriented landing page for wholesale clients paired with an authenticated, responsive ERP operating system for the kitchen crew and management.
- Dynamic Batch Calculator: Programmed real-time recipe scaling based on current market ingredient price inputs.
- Live Production Schedule: Built a day-by-day bake sheet dashboard syncing order statuses straight to kitchen staff tablets.
- Vibe-Coded Next.js Interface: Prioritized high-speed ergonomic data entry designed for tablet use in high-tempo kitchen environments.
Architecture & Data Flow
Modular Next.js App Router architecture with reactive state management, Tailwind design system, and rapid data synchronization.
Order Ingestion
Incoming wholesale cake orders trigger automatic ingredient deduction & margin calculations.
Dynamic Batch Costing
Yield calculation engine converts grams, batches, and packaging overhead into real-time unit costs.
Kitchen Schedule Queue
Auto-groups cakes by bake cycle and oven availability into a digitized morning production roster.
Inventory Sync & Reorder
Alerts triggers when flour, butter, or specialty dairy drop below minimum batch thresholds.
Technology Stack Breakdown
Verifiable Outcomes & Metrics
Eliminated manual paper bake sheets and gave the business owners instantaneous visibility into true ingredient margins per pastry item.
Interface & System Previews
Engineering Lessons & Takeaways
- ✦Kitchen UX requires ultra-high contrast and touch-friendly controls that accommodate flour dust and rapid tablet tapping.
- ✦Unit conversion between wholesale purchase units (sacks, crates) and bake units (grams, milliliters) must be strictly typed to avoid rounding drift.