An online store to sell, and a system to run everything after the sale.
Fancy Water distributes aesthetic-medicine products in Mexico and is the official distributor of the VOL:TENA line in the Americas. It sells to aesthetic-medicine professionals and to consumers, shipping from Monterrey.
Trust outside, control inside.
Outside, it needed a store that earns the trust of two very different audiences and lets them buy and pay online. Inside, precise control of the warehouse and the full sales cycle: lots and expiry dates, quotes, sales, collections and each rep’s commissions.
Clinical luxury, built mobile-first.
- Catalog by category with a price list in MXN
- Product pages with data sheets
- Cart and Stripe checkout, with shipping calculated at purchase
- WhatsApp quote option and product guides
- Tracking for Meta and Google Ads campaigns
28 screens, five roles, one source of truth.
Screenshots show no internal data or staff names.
- Inventory by lot and expiry: sales draw from the earliest-expiring stock first
- Physical counts and adjustments with manager approval
- Supplier purchases with partial receiving
- Quotes by PDF, WhatsApp or email; sales, returns and cancellations
- Confirmed payments, customer credit, collections and commissions
- Excel reports, product analysis, approvals and an audit log
- System manual and role-based training
Technology
Store: website with server functions, Stripe and transactional email. ERP: Next.js and TypeScript on Supabase (PostgreSQL and auth) with row-level security.
Today
The store is live at fancywater.mx and the Fancy Water team runs the system in production. We don’t publish sales figures because they are the client’s internal data.