Online Sales Dashboard

Why We Built This

A small-batch distillery client was running their direct-to-consumer business on a third-party e-commerce platform that exported monthly sales as raw CSV files — useful data, but locked in a format nobody could actually read on the go. Leadership needed a fast way to see what’s selling, where it’s shipping, and how each expression is performing month-over-month, without waiting for someone to wrestle a spreadsheet into shape.

We built a lightweight, mobile-first sales dashboard that ingests the platform’s CSV exports in one click, enriches each order with product-level detail pulled directly from the storefront, and surfaces the numbers that matter — revenue, top expressions, state-by-state reach, and customer concentration — in a clean interface designed for a phone screen during a meeting or a tasting. The result: a private, passcode-protected app that turns a monthly data dump into an at-a-glance view of the business, deployed to a dedicated cloud instance and built to scale as the catalog grows.

Tech Stack

• Frontend: React, TypeScript, Tailwind CSS, shadcn/ui
• Backend: Node.js, Express, SQLite (Drizzle ORM)
• Hosting: Fly.io (dedicated app + persistent volume)
• Data pipeline: CSV ingestion → automated product enrichment → normalized order/line-item schema
• Security: Passcode gate, HTTPS, read-only public demo mode with anonymized data