Back to Portfolio

Carros De USA: Vehicle Import Marketplace

Marketplace Platform

Carros De USA: Vehicle Import Marketplace

Project Overview

Carros De USA is a cross-border vehicle import business operating between the United States and Guatemala. They needed more than a brochure site: a catalog that sells, a customer area that tracks every order, and an admin panel where the team runs the operation.

Public side

  • Bilingual from the ground up — every route exists in Spanish and English (/es/catalogo and /en/catalog), with hreflang, canonical URLs and its own metadata.
  • Catalog with real filters — brand, body type, year, price and mileage, plus sorting and share buttons per card.
  • Vehicle comparison — up to three units side by side, with the rows that differ highlighted.
  • Search alerts — a visitor leaves the filter they care about and gets an email the moment a matching unit is published.
  • Vehicle pages — gallery with responsive AVIF/WebP, specs, video walkaround streamed over HTTP Range so it plays on iOS, and a reservation flow with the deposit method the buyer picks.

Customer portal

  • Favorites, orders with their full status timeline, support tickets and profile editing.
  • TOTP two-factor authentication with QR enrolment, single-use password reset links, email verification, and a "sign out everywhere" switch that invalidates every open session.

Admin panel

  • Five roles (customer, beta, admin, accountant, super admin) with guards that re-read the database on every request, so revoking access takes effect immediately.
  • Its own Spanish/English switch, independent from the public site.
  • Inventory management with VIN decoding against NHTSA, photo upload with automatic AVIF/WebP conversion and EXIF stripping, CSV bulk import, internal auction fields the public never sees.
  • Orders, clients, tickets, expenses, and accounting reports exported as PDF (written by hand, no external engine) and CSV.
  • Analytics with a real funnel: views, favorites, reservations, plus WhatsApp and phone clicks captured by a beacon.
  • Audit log of every staff action and an error log that pings Telegram the first time a new failure appears.

Infrastructure

Docker with Traefik v3 and automatic Let's Encrypt certificates. Nightly PostgreSQL backups with integrity checks and an off-site copy on a second server, a restore that has actually been rehearsed, health checks every five minutes with Telegram alerts on state changes, and a separate staging environment that runs beside production with its own database and mail disabled.

Technologies Used

Next.jsReactTypeScriptPostgreSQLTailwind CSSDockerTraefikResendTOTP 2FA

Key Results

19-table schema, public catalog plus customer and admin portals, bilingual end to end, automated backups verified by restore, and a 28-check end-to-end suite against production.

Project Links