Silencio Co — E-commerce Platform
My streetwear brand needed a real storefront with customer accounts, not just a brochure site — plus clear numbers behind the scenes (margins, cash flow, break-even) without paying for heavy accounting software.
Overview
A live e-commerce web app built with Next.js and TypeScript on a Supabase Postgres database — a limited-drop store with secure customer accounts — backed by a Google Sheets accounting & operations dashboard that auto-calculates COGS, margins, A/R, A/P, inventory value, and break-even.
My role
- Full-stack build (Next.js + TypeScript + Supabase)
- Authentication & account management
- Accounting & operations dashboard (Google Sheets)
The problem
My streetwear brand needed a real storefront with customer accounts, not just a brochure site — plus clear numbers behind the scenes (margins, cash flow, break-even) without paying for heavy accounting software.
What I built
- Secure accounts & authentication
- Limited-drop product catalog
- Accounting dashboard: auto P&L, margins & break-even
Tools used
- Next.js
- TypeScript
- Supabase
- Auth
- Google Sheets
Challenges
- Building secure customer accounts and authentication on Supabase.
- Running the storefront and the numbers as one system, with the dashboard auto-updating from raw sales and expense logs — no paid accounting software.
Outcome
- Live e-commerce store with secure customer accounts
- Limited-drop catalog on a Supabase Postgres database
- Google Sheets dashboard: auto-calculated P&L, COGS, margins, A/R, A/P and inventory value