Work / Chapter 04 of 09Full Stack · 2024 — 2025
400,000+ imported items, traceable end to end
OutcomeEvery item has a story
Complex operations.Complete visibility.
Built a custom ERP to track 400,000+ imported items from customs to sales with full personnel traceability.
( private build · no public link )Start a similar project
- Client
- Industrial Import & Manufacturing Client
- Role
- Solo project — design to deploy
- Timeline
- 2024 — 2025
- Category
- Full Stack
01 / The problem
what was in the way.
Designed and built a custom production tracking and inventory system for an industrial importer. The platform handles the full chain from customs intake to warehouse, production line, smart rule-based assembly, finished goods, and sales dispatch. It includes complete personnel logging at every stage and reverse traceability by final serial number, plus AI-powered executive dashboards and flexible Excel report generation for custom operational needs.
- 01Managing high-volume customs data with strict serial-level accuracy requirements
- 02Maintaining full traceability across multiple operational stages and teams
- 03Implementing smart assembly rules to prevent wrong-part and wrong-sequence production
- 04Providing leadership-friendly reporting without requiring technical expertise
02 / How it works
three beats, one system.
- (01)customs & inventory
- (02)rule-based assembly
- (03)dispatch & traceability
- Built automated import pipelines to parse customs Excel files into structured production data
- Implemented chain-level tracking from customs to sales dispatch with stage-by-stage logging
- Added reverse lookup by finished-product serial number to identify all involved personnel
- Developed AI-powered visual dashboards for decision-makers using Gemini AI
- Delivered flexible advanced Excel report generation for custom business requests
03 / What it made possible
what shipped.
400,000+ items per order, extracted automatically
Production ERP80% fewer carelessness-related mistakes
Production ERP- Automated data extraction for customs Excel files covering 400,000+ items per order
- Achieved zero human errors in assembly through smart rule-based production controls
- Reduced carelessness-related operational mistakes by 80%
- Cut report preparation time from days to minutes
- Delivered full end-to-end supply chain transparency with reverse serial traceability
Next case · 05Full Stack
