TOOLS
Need & Problem
ROY Kombucha had an existing Airtable system built by a previous developer. During a period of internal restructuring, the system needed to be taken over, stabilized, and significantly extended while remaining in active daily use by the team.
B2B orders were managed in Airtable, while D2C orders came through Shopify, leaving no unified view of sales data. Raw ingredient purchasing, production batches, and warehouse stock were not systematically tracked, making traceability and operational visibility difficult.
The Solution
I took over full ownership of the system and restructured it across three dedicated Airtable bases covering Orders, Warehouse, and Production. I built Shopify and Billbee integrations via Airtable Scripts to centralize all sales data in one place and enable cross-channel reporting through Airtable Interfaces.
I designed and built a complete B2B order management workflow covering order creation, product selection, status tracking, shipment follow-up, order numbering, and invoicing. I also maintained and extended the existing DocsAutomator integration used for invoices and payment reminders.
I built a production traceability system linking raw ingredient purchases to specific production batches, tracking exact quantities used per batch and which batches were sold — supporting both operational control and food safety requirements. The warehouse base I built provided real-time visibility into stock levels for both raw ingredients and finished goods, including supplier tracking to support reordering decisions.
I set up structured Airtable Interfaces for the operations team and maintained, debugged, and developed the full system over a four-year engagement with one dedicated day per week. All changes were documented in Notion and linked to a Loom recording. The collaboration supported the company through a period of sustained growth that led to its acquisition in 2026.