ERP / POS · 2026
Flower Shop ERP
Point-of-sale, inventory, customers and profit & loss for a flower shop, in one zero-dependency Node app that runs on a shop PC and prints 78mm slips.
- Client
- Flower retail business, Lahore
- Role
- Design, build, deploy
- Stack
- Node.js 22 · node:sqlite · Vanilla JS SPA · Print CSS (78mm) · FS Tech Solutions UI kit
Updated 11 Nov 2026
The problem
Sales were written on paper slips, stock was counted from memory and the owner only learned the real margin weeks later. Every bouquet is assembled from loose products (stems, wrapping, ribbon), so the usual retail POS could not tell whether a price actually covered the cost.
What I built
A single-page app on a Node server with the built-in SQLite driver: the cashier builds an invoice from items, each item is made of products with a minimum price, and the server refuses any sale below the sum of those floors. Daily closing stock becomes the next day's opening; monthly P&L values consumption and wastage at the latest purchase cost.
- POS with coupons, partial payment, held invoices and WhatsApp slip sharing
- Item recipes: default product list per item, adjustable per sale
- Inventory with opening/closing carry-over, purchase batches and freshness alerts
- Customers with credit ledger, loyalty points and occasion reminders
- Day close / Z-report with expected vs counted cash
- Monthly and daily P&L with named charge rules (rider share, bank charges)
- PIN login, order status flow, void with reason, pre-orders by delivery date
Outcome
The owner sees margin per day instead of per month, under-priced sales are blocked at the till, and stock counts take minutes because yesterday's closing is already today's opening.
Screens
Want this for your company?
The engagement is described on the Restaurant back office service page: who it is for, what you get, how it runs, and the questions I get asked.
Offered through Tech Solutions
This kind of system is delivered commercially by my company, Tech Solutions. The matching pages there:
Notes from this build
Have a process like this?
Send me the thing your team does by hand every week. I will tell you honestly whether it is worth automating, even when the answer is no.
