Covenant Acres Farmstand

Shane and Stephanie run a small sourdough bakery with orders from multiple pickup locations. They needed a way to manage customer orders, track inventory costs, calculate profitability, and coordinate production schedules — without expensive POS software.

A desktop admin app (Electron) paired with a customer-facing web order form, both syncing through Google Sheets. Owners manage everything locally while customers order online.

• Order management with filtering and CSV export
• Multi-location bake slot management
• Customer database with credit tracking and order history
• Recipe and ingredient cost tracking
• Analytics dashboard (revenue, profit margins, profit/hour)
• Prep sheet generation (print-ready production list)
• Role-based access control (Owner, Admin, Staff)
• Google Sheets bidirectional sync
• Mobile-friendly customer order form

Hybrid system: Electron desktop app with React renderer and local SQLite database syncs bidirectionally with Google Sheets. Web order form (Vercel) submits to Sheets, which the desktop app pulls automatically. 11 database tables covering orders, customers, production, and admin.

Sole developer. Gathered requirements directly from the client, designed the architecture, built both the desktop and web applications, and delivered with training and remote support.