Dilodoor Watch E-commerce

Dilodoor is a full-stack, production-grade e-commerce platform I designed and built end-to-end for the Bangladeshi watch market — from database schema and API architecture to pixel-perfect, mobile-first UI. The project tackles a uniquely local commerce challenge: Bangladeshi shoppers overwhelmingly prefer paying only when the product is in hand, so the entire purchase flow — cart, checkout, shipping logic, and order lifecycle — is engineered around Cash on Delivery across all 64 districts, with granular district-to-thana delivery rules and Dhaka vs. outside-Dhaka shipping tiers baked directly into the data model.

On the frontend, I used Next.js 15 (App Router) with React 19 and Tailwind CSS 4 to ship a fast, mobile-first storefront: a curated product catalog with filterable browsing, category pages, an image carousel-driven product detail experience, a persistent client-side cart, wishlist syncing between guest sessions and logged-in accounts, and a checkout flow with inline validation and a sticky order summary — all wrapped in a crimson-and-black brand system designed to feel premium on a small screen.

Behind the scenes, I built the entire backend on Supabase Postgres with Row Level Security, writing raw SQL migrations to evolve the schema safely across ten iterations — from the base commerce schema through banners, verified reviews, category imagery, admin roles, and traffic-source attribution. Order creation is fully transactional: a Postgres RPC function locks stock rows, decrements inventory, and generates human-readable order numbers (DD-YYYY-####) atomically, so concurrent checkouts never oversell.

I also designed and shipped a complete internal operations tool: a JWT-authenticated admin dashboard with role-based access control across three tiers (admin, sub-admin, order manager), so a real business could hand out scoped logins to staff without exposing sensitive settings. Admins can manage the full product catalog with a tabbed editor (specs, features, SEO, reviews), reorder gallery images via drag-and-drop, moderate reviews, run a lightweight leads CRM for abandoned checkouts, configure shipping rates and homepage banners, and invite teammates through a secure token-based flow. Uploaded images are automatically compressed with Sharp into sub-50KB WebP files and served from Vercel Blob, keeping the whole stack comfortably inside free-tier hosting limits while still loading fast.

To make the store genuinely marketable, I integrated Facebook Pixel and Google Tag Manager with hashed PII for improved ad match quality, plus a full GA4-style ecommerce dataLayer so every view, add-to-cart, and purchase event is trackable for real ad campaigns — not just a demo storefront.

This project demonstrates my ability to own a product from requirements through architecture, database design, secure multi-role auth, transactional data integrity, third-party marketing integrations, and a polished, conversion-focused UI — all shipped as a lean, cost-efficient, real-world-ready application rather than a tutorial-scale demo.