Full-Stack Developer

PureYuna — Full-Stack Skincare E-Commerce Platform

PureYuna — Full-Stack Skincare E-Commerce Platform

Project Overview

Modern clean botanical skincare store with dynamic curated multi-step routine packages, proportional pricing engine, and role-based admin controls.

Main Features

✓ 36-Product Multi-Category Catalog✓ Curated Multi-Step Routine Packages✓ Smart Cart Drawer & Pricing Engine✓ Admin Management Suite✓ Personalized Product Discovery✓ Role-Based Admin & Auth✓ RESTful API Architecture✓ Responsive UI

Technology Stack

Next.jsReactTypeScriptTailwind CSSNode.jsExpress.jsPostgreSQLPrisma ORMNeon DBRenderVercel

Challenges & Solutions

⚡Relational Data Modeling & Multi-table Relations

ChallengeStructuring complex e-commerce entity relationships (Users, Orders, OrderItems, Products, Categories, Packages, Wishlists) while preventing data inconsistency and slow query performance.
SolutionDesigned a normalized PostgreSQL schema using Prisma ORM with strict foreign key constraints, cascading rules, and indexed search attributes to ensure fast and consistent data retrieval.

⚡Secure Checkout, Stock & Serverless Connection Management

ChallengePreventing invalid quantities, pricing mismatches, and stock inconsistencies during checkout, alongside handling database connection pool exhaustion on cloud-hosted serverless PostgreSQL.
SolutionMoved critical checkout validation to the backend, verified stock using Prisma transactions, and integrated Neon PostgreSQL connection pooling to maintain low latency under concurrent traffic spikes.

⚡Role-Based Admin & Production Deployment Pipeline

ChallengeProtecting administrative routes from unauthorized access and managing automated database migrations with CORS handshake policies during live deployment on Render.
SolutionImplemented JWT-based authentication with strict role authorization, automated build-time Prisma migrations on Render, and configured centralized production CORS headers.

Future Improvements

Personalized skincare recommendations based on user skin profilesOnline payment gateway integration (Stripe / SSLCommerz)Customer review and product rating systemAdvanced admin analytics and real-time sales dashboardRedis caching layer for top-selling products and frequent queriesReal-time stock inventory tracking & webhook notificationsAI-powered skincare assistant