All case studies
client
Custom Production ERP

Cupcake Studio

Custom production ERP built for a confectionery studio. Order management, client CRM, recipe database with auto-scaling, production scheduling, ingredient procurement, packaging, and delivery coordination - the entire business running from one purpose-built system.

Custom ERP
8 hrs → 1 hr admin/day
Zero double-bookings
Food ProductionUnited KingdomDiscuss a similar project ->
// automation architecture
Airtabletrigger
Makeorchestration
Claude APIintelligence
Airtabledelivery
24/7, no humans
// The problem

Cupcake Studio was running a high-volume custom order business - cakes, dessert tables, corporate orders - entirely out of Instagram DMs, WhatsApp chats, and a personal notebook. Every order required manually calculating ingredient quantities per recipe, checking production capacity by memory, coordinating delivery slots over the phone, and following up with clients manually. As the order book grew past 30-40 orders per week, scheduling conflicts started happening, ingredients were miscalculated, and clients were receiving inconsistent communication. The owner was working 14-hour days mostly on admin, not production.

// What we built

We built a purpose-built production ERP for the confectionery workflow. At the center is a structured order management system: orders come in from Instagram, WhatsApp, or a web form, are captured automatically into a single database, and immediately trigger the production logic. The recipe database holds every product with ingredient ratios - when an order is created, ingredient quantities scale automatically to the required batch size and flow into a running procurement list. A visual production calendar with capacity rules prevents scheduling conflicts: if a slot is full, the system flags it before confirmation. Client communication is fully automated - confirmation, production status, pickup/delivery reminders all fire at the right time without manual sends. A client CRM tracks order history, preferences, and birthdays for retention campaigns. Claude analyzes weekly order patterns and flags which products are most profitable, which time slots are underutilized, and which clients are due for a follow-up.

// Results
01Custom production ERP live - full order lifecycle from intake to delivery in one system
02Ingredient calculations: manual recipe math per order → auto-scaled from recipe database instantly
03Production scheduling: visual calendar with conflict detection - zero double-bookings since launch
04Client CRM: full order history, preferences, and automated retention campaigns
05All client communication automated - confirmations, reminders, delivery updates without manual sends
06Procurement list: auto-generated weekly from confirmed orders, sent to suppliers automatically
07Owner time on admin: ~8 hrs/day → under 1 hour, rest is production
// Tech stack
AirtableMaken8nWhatsApp Business APIInstagram APIClaude APITelegram BotGoogle Sheets
Want something similar?

Free 30-min audit. We tell you what to automate and what it costs.

From $1,000
2-6 week delivery
Fixed scope
Book a free audit