All projects · Supabase Full-Stack Apps
VERDE — Sustainable E-commerce Product Manager
A single-file, hash-routed storefront + admin app for a fictional eco home-goods brand, backed by Supabase.
A single-file, hash-routed storefront + admin app for a fictional eco home-goods brand, backed by Supabase. It has a customer-facing storefront (hero, featured bestsellers, all-products page) and an admin dashboard with computed KPIs and an Add Product form that inserts rows and uploads images to Supabase Storage. Ships a companion SQL schema to provision the products table, RLS policies, and a public storage bucket.
- One self-contained index.html with a hash router (#home/#products/#dashboard) — no build step
- Live Supabase CRUD: fetch products, insert new products, image upload to Storage then save the public URL
- Graceful 'Demo mode' fallback to in-page MOCK data when Supabase keys aren't configured
- Admin dashboard KPIs (Total Products, Active, Categories, Avg Price) computed client-side from live data
- verde_schema.sql provisions table + gen_random_uuid PK + wide-open demo RLS policies + public 'product-images' bucket and upload policy
Built with: HTML, CSS, vanilla JavaScript, Supabase (supabase-js v2 via CDN), PostgreSQL, Supabase Storage, Row Level Security, Google Fonts (Fraunces, Jost)