Mehta Jewellers
Luxury jewellery showroom website with a full admin CMS, live gold/silver rates & realtime inquiry management
Turn showroom browsers into WhatsApp leads — premium catalog and live metal rates, zero e-commerce overhead.
A look inside
A full-featured jewellery showroom website — deliberately not e-commerce (no cart, checkout, payments, or customer accounts). It showcases collections, categories, and products; captures leads through dual WhatsApp + database inquiry logging; lets visitors book showroom appointments; and displays live gold/silver rates that update in realtime. Built as a single-page app on React 19 + Vite with TypeScript and Tailwind CSS v4 in a luxury gold/black/cream theme, it pairs a rich animated public experience (Framer Motion + Lenis smooth scroll) with a complete, auth-protected admin dashboard that manages every piece of content and runs realtime-updating inboxes for inquiries and appointments. Supabase powers the database, auth, storage, and realtime layer, with Row Level Security enforcing access control server-side and an optional Edge Function refreshing spot rates daily.
Features built in
Public Showroom Experience
- Animated home page: hero, featured collections, live rate ticker, testimonials, craft process, shop-by-category, FAQ, CTA & stats
- Collections, categories, and product catalogs with filtering and dedicated detail pages
- Live gold/silver rates with realtime auto-updates and a floating WhatsApp button
- About & Contact pages with map embed, SEO via react-helmet-async, and a friendly 404
- Demo-mode banner when Supabase credentials are unconfigured
Dual Lead Capture
- Inquiry system saves to the database AND generates pre-filled WhatsApp deep links
- Product-level quick inquiry forms with source tracking ('product')
- Showroom appointment booking with preferred date/time slots from centralized config
- WhatsApp source tracking surfaced in the admin inbox
Admin Dashboard & CMS
- Email/password auth (single admin role) with a client-side ProtectedRoute guard
- Stats dashboard: inquiries, appointments, active products & collections
- Full CRUD over products, collections, categories, gallery, testimonials & gold rates
- Image upload/management with bulk operations and a product image manager
- Realtime inquiry & appointment inboxes with status tracking
Architecture & Realtime
- Thin per-table Supabase API layer with one TanStack Query hook per table
- Realtime subscriptions on inquiries & appointments with unique channel topics to avoid collisions
- Row Level Security on every table: public-read (active only), authenticated-insert & authenticated-CRUD
- Centralized site config for WhatsApp number, phone, email, address, hours, socials & slots
- Lazy-loaded routes, error boundary, and session persistence with auto-refresh
Automated Gold Rates
- Optional Supabase Edge Function refreshes gold/silver spot rates daily
- Sources spot price from gold-api.com and currency conversion from open.er-api.com
- Applies a configurable markup and upserts into the gold_rates table
- Scheduled via cron; rates can also be entered manually in the admin
- A jewellery showroom wanting a premium catalog site without selling online
- A retailer capturing leads via WhatsApp while logging every inquiry to a database
- A store displaying live, auto-updating gold/silver rates to build trust
- A business managing all content and bookings from a single realtime admin dashboard
From idea to live in 4 steps
Enquiry
Tell me what you want to build using the form below — platform, features, budget, and timeline.
Quote & Scope
Within 24 hours you get a fixed quote, a clear scope, and a delivery plan — no surprises.
Design & Build
I design and build in weekly milestones with live previews so you watch it come together.
Deploy & Support
I ship it live — web, App Store, Play Store — and stick around for support and iteration.
Common questions
Is this an e-commerce site?
No — it's deliberately a showroom/catalog site. There's no cart, checkout, payments, orders, or customer accounts. Visitors browse and then inquire via WhatsApp or book a showroom appointment.
How do the live gold rates work?
Rates display in realtime and can be entered manually in the admin or refreshed automatically by a daily Supabase Edge Function that pulls spot prices, applies a configurable markup, and upserts them.
How are leads captured?
Every inquiry is saved to the database AND generates a pre-filled WhatsApp message, so you get both a logged record in the admin inbox and an instant chat with the customer.
How is the admin secured?
Supabase email/password auth with a client-side ProtectedRoute guard, backed by Row Level Security policies that enforce access control server-side on every table.
Can I rebrand and extend it?
Yes — business details live in a centralized site config, the theme is Tailwind-driven, and the per-table API and hooks make adding new content types straightforward.
What's needed to deploy?
A Supabase project for the backend and a Vercel deployment for the front end with SPA rewrites. Just set VITE_SUPABASE_URL and VITE_SUPABASE_ANON_KEY and add the domain to Supabase auth URL configuration.