AlCOOl.
A neighbourhood shop. A connected operation.
A neighbourhood shop. A connected operation.
I built AlCOOl around the work of running a neighbourhood store: recording counter sales, receiving stock, keeping purchase evidence and giving owners records they can understand. A luxury-inspired storefront brings the same business onto customers’ phones, while scheduled Excel reports make stock history available outside the app. The Flask platform runs in Docker on Azure; the Android rider companion remains a pilot.
A premium storefront, practical POS and automatic daily stock reports for a working neighbourhood shop in Kutus, Kenya.
Make everyday work clear
Role-specific workspaces give owners, counter staff, IT and riders relevant actions. Counter baskets distinguish whole bottles, measured shots and cocktails. Serving-size changes apply to new sales, preserve earlier allocations and ask stale counter screens to refresh.
Keep the records dependable
Supplier receipts, stock movements and audit history explain each change. Daily Excel exports put six clear columns first, keep shots and mixers separate, and preserve detailed records and original files. Verified downloads catch up when the owner’s laptop reconnects.
Design for the shop and the phone
A curved full-width navbar, expressive typography, real bottle photography and removable filters make the catalogue easier to explore. Shared styles work across the storefront and staff tools, with native browser motion, reduced-motion support and one stylesheet request per page.
From the counter
to the customer.
The most useful work happens behind the storefront: keeping stock counts consistent, separating bottle and measured sales, and saving supplier receipts alongside the quantities received. Owners can review records without relying on a message thread or a paper tally.
The refreshed storefront pairs a full-width navbar with a curved lower edge, the original eye logo and real bottle photography. Search, category filters and a persistent basket keep the next action close on a phone. Seasonal themes share the same controls.
CURRENT RELEASE / NOVEMBER 2026The storefront and staff record keeping are live. Customers can submit delivery requests; online payments remain locked for launch. The Android rider app is a pilot, with provider and device acceptance still required before a full delivery rollout.
Good records.
Less guesswork.
A stock report should help someone run the shop. The first Excel tab now answers six everyday questions, with remaining stock highlighted and discrepancies clearly marked for review.
| Drink | Start | Added | Sold / used | Corrections | Left |
|---|---|---|---|---|---|
| Example gin · 250ml | 8 | 6 | 5 | 0 | 9 |
| Example soda · 300ml | 12 | 0 | 4 | 0 | 8 |
| Example juice · 500ml | 4 | 6 | 3 | 0 | 7 |
Start + Added − Sold / used + Corrections = Left. Bottles assigned to shots are included in used stock.
Clarity first.
The main tab shows bottles and cans. Shots and mixers have their own units and tab. Detailed movements stay available without crowding the everyday view.
A daily record.
The server exports the previous day at 12:10am Nairobi time. The laptop checks hourly and downloads missed reports when it reconnects.
Keep the evidence.
Simplified copies use the original saved data. Older workbooks remain archived, downloads are checked against their checksums, and edited copies are never silently overwritten.
Let’s make it
worth building.
A new website, a product idea, or something that needs to work better.