Stock Tracker App: Real-Time Dealer Inventory Dashboard


Full-Stack Internal Tool • Built for PSC Motorsports

I designed and deployed a live, real-time stock visibility platform for PSC Motorsports’ wholesale dealer network. Over 800 SKUs needed to be instantly accessible to multiple dealers 24/7 — without granting access to the internal ERP system.

In under 48 hours, I shipped a production-ready, zero-maintenance web dashboard that replaced twice-weekly emailed spreadsheets.

Key Technologies • React 18 + TypeScript – Fast, modern frontend • Vite – Lightning-fast builds and hot reload • Bootstrap 5 + React-Toastify – Clean, responsive UI with instant feedback • json-server + custom Node.js endpoints – Full REST API from a single db.json file • basic-ftp + PapaParse – One-click CSV generation and automated FTP upload • Render.com (Static Site + Web Service) – Free, auto-deployed hosting with zero server management

Features • Real-time searchable and sortable inventory table (800+ parts) • Inline editing of stock quantities with instant persistence • Configurable FTP server management stored securely in localStorage • One-click CSV export and automated upload to up to 4 dealer FTP servers simultaneously • Mobile-responsive design – dealers can check stock from anywhere • Fully deployed and self-updating on every git push • End-to-End Development – Solo built: database design, API routes, frontend logic, UX, deployment pipeline

What I Learned This project pushed my ability to deliver a complete, client-ready full-stack solution at high speed. I mastered monorepo-style deployment quirks on Render, built a custom FTP automation flow that works reliably in production, and created a buttery-smooth React data table experience with debounce, pagination, and live search — all while keeping the codebase clean and maintainable.

Summary The Stock Tracker App eliminated hours of manual work each week and gave PSC’s dealers instant, accurate inventory visibility. It’s now the single source of truth for wholesale stock levels — running 24/7 for $0/month in hosting costs.

A perfect example of building fast, functional, and beautiful tools that solve real business problems on day one.

Comments

Leave a Reply