S.P. AUTO PART
ระบบจัดการอะไหล่รถยนต์แบบละเอียด กรองตามยี่ห้อ/รุ่น, Specifications แบบ Dynamic, และระบบ Activity Logs ติดตามการทำงานของแอดมิน.
Overview
A comprehensive inventory management system specifically built for an auto parts dealership. It features deep filtering by make, model, and year, along with dynamic specifications and robust admin activity tracking.
The Challenge
- Structuring the database to handle the complex many-to-many relationships between car models, years, and specific auto parts.
- Building a fast, faceted search interface for thousands of SKUs.
- Ensuring strict role-based access control (RBAC) and audit trails for all inventory changes.
Implementation
- Designed a normalized relational database schema in Supabase PostgreSQL.
- Implemented server-side filtering and pagination in Next.js to keep the client-side lightweight and snappy.
- Created a global Activity Log system that automatically records who changed what and when.
Outcomes
Drastically reduced time spent searching for compatible parts.
Improved inventory accuracy and accountability among staff members.
Modernized the client's business operations from paper-based tracking to a cloud-native solution.
Tech Stack
Next.js 15SupabaseHeroUITypeScript