OptiPour

OptiPour is a bottle-based wine billing system for restaurants: weigh the bottle out, weigh it back, and charge for exactly what the guest drank. Nothing like it existed at the client before we started, so we built the product end to end, the load-cell hardware and Raspberry Pi controller that measure each bottle, the touchscreen workflow servers use to open and close a tab, and the backend that turns a weight delta into a price. The system also runs under the alias Winepour internally, same client, same platform. Past the initial build, the current work is aimed at manufacturing: moving the electronics off breakout modules onto a custom PCB, documenting a full bill of materials and manufacturing plan, and building the over-the-air update path the deployed devices will need once they are out of our hands.

• There was no existing system to adapt. The load-cell hardware, the touchscreen workflow, and the billing logic all had to be built from nothing
• A guest's bill depends on a load-cell reading being accurate to the ounce, with no room for drift between calibrations
• No separate staging environment exists, so weekly regression testing runs against the live production dashboard with QA-prefixed data
• Breakout modules work for a prototype but cannot be manufactured at volume, so the device needed a path onto a custom PCB

• Built the load-cell scale interface and calibration logic that turns a start weight and end weight into consumed ounces and a price
• Built the touchscreen point-of-service UI servers use for a new bottle, a table assignment, a return, and closing out a tab
• Modeled tabs per bottle rather than per table, so one table can run several open bottles at once without confusion
• Designed the power system and the PWM LED indicator circuit, and wrote the wiring and assembly documentation for the build
• Built the over-the-air update path along with a reliability test plan for pushing firmware changes to deployed devices
• Worked the custom PCB path to move the device off breakout modules and onto a manufacturable board, with a full BOM and manufacturing plan
• Built the Next.js and Supabase web dashboard that runs the production system at dashboard.optipour.com
• Run the weekly regression pass against production with QA-prefixed test data, since there is no separate staging environment yet