Lubricentro Chachi
High-performance B2C e-commerce for lubricants and automotive products. The platform uses SSG (Static Site Generation) with on-demand revalidation to combine fast load times with always up-to-date data.
The catalog handles products with complex variants (packaging, polarity, brand) and dynamic pricing by type. The PostgreSQL (Supabase) database includes efficient normalization and RLS policies to protect sensitive data.
Three payment options: Mercado Pago (with commission), Yape/Plin, and direct bank transfer. Real-time stock management and a database-backed persistent cart that can be cleared from the server after confirming payments.
- Database schema design with normalization and join tables for product attributes
- SQL migrations to maintain a history of database structure changes
- Mercado Pago integration with webhooks for asynchronous payment confirmation
- On-demand revalidation using triggers and Edge Functions
- PostgreSQL RPC functions to optimize multiple queries in a single transaction
- Admin panel for managing products, orders, receipts, and site content
- Product administration form with variants using Field Arrays and Zod validation
- Database-backed persistent shopping cart with up-to-date pricing
