A beer list that updates the website and the printed menu in one go
One spreadsheet, two menus
The problem
København is a craft beer bar in Halifax whose list changes almost daily. Every change was being retyped by hand twice: once into the website and once into the printed table menus. Mistakes crept in, and the two never quite matched.
What Matt built
A WordPress plugin that takes the spreadsheet the bar already keeps, validates it hard, and publishes it to the website and to a print-ready PDF menu in one step. Wine follows beer on the same shape.
The file imports, or it doesn’t
The rule that governs everything: there is no partial import. If a single row fails validation the whole file is rejected with a clear message naming the row, so the menu on the wall is never half right. Warnings are shown but never block a publish.
Three layers each do one job: read the spreadsheet into clean rows, check the shape, then check the meaning. Every row that makes it through is complete, so the menu renderer never has to guess.
- 8 hrsof retyping saved each week, roughly
- 1spreadsheet behind both the website and the printed menu
“The bar was typing every beer into the website and then again into the printed menu, most days of the week. That was about eight hours a week. Now they update one spreadsheet and both menus are right.”