Gestion des prix
A mobile stock and pricing app built for a client, backed by a PocketBase server installed on their premises, with real-time sync across the team.
A client needed to manage prices and stock day to day, with several people working on the same data at once. Off-the-shelf solutions were either oversized or billed monthly per user, so I built a tailored application, from the back end to the interface.
The catalogue: over 200 products with photos, instant search and multiple sort options (recent, alphabetical, price ascending or descending, and above all by margin). Each product holds its purchase price, selling price, packaging (unit or pack), quantity and unit, plus stock, adjustable with quick increments.
From that data, the app automatically computes the margin percentage and the price per litre or kilo. That's what lets the team spot the least profitable products at a glance, simply by sorting the catalogue by margin.
Barcode scanning goes beyond a simple catalogue lookup: the app queries Open Food Facts, the free and collaborative food product database. Scanning an unknown item identifies the product directly and pulls in its details automatically, removing almost all manual entry when adding a product.
Finally, a label module generates print-ready A4 sheets: product name, price, price per litre and a regenerated barcode, paginated to cover the whole catalogue.
On the server side I chose PocketBase and installed it directly on the client's premises. Their data stays in-house, with no cloud subscription, and real-time comes built in: as soon as someone changes a price or a stock level, the update appears instantly on the rest of the team's devices, with no refresh.