Custom Web App · Inventory & Sales
Mar y Limón
Inventory & sales management for an artisanal cevichería
Built in 2026 · Deployed & in active use
Mar y Limón, an artisanal cevichería, needed a reliable multi-user system to manage daily product inventory and sales, accessible from several devices at once. Their previous process was manual and error-prone, with no visibility into daily revenue, payment breakdowns or stock movement.
The product on screen
The Challenge
Key requirements included:
- ▸Track products by name, unit price, quantity produced and quantity sold.
- ▸Record sales distinguishing cash vs bank transfer.
- ▸Generate daily accounting closes.
- ▸Filtered sales history (by day and date range).
- ▸Accessible from any device without per-user licensing costs.
The Solution
After evaluating Bubble.io, Google Sheets + AppSheet, and a custom build, the custom stack was chosen for its near-zero running cost and full product ownership. A React + Vite + Tailwind frontend (fully in Spanish) talks to a Node.js + Express REST API with JWT auth via httpOnly cookies, backed by PostgreSQL on Railway. The UI follows a strict light-mode, WCAG 2.1 AA design inspired by the brand's ocean palette.
Results
- ▸Zero per-user licensing cost — runs on Railway at minimal cost vs Bubble's per-user pricing.
- ▸4+ concurrent users from different devices.
- ▸Replaced a fully manual process with a real-time digital record.
- ▸Clear daily visibility into revenue, payment methods and stock movement.