Problem
Managing international trade data and calculating accurate landed costs involves complex rules, multiple entities, and sensitive financial information. Merchants and internal teams required a centralized, secure, and efficient system to handle HS codes, trading partners, countries, and historical cost calculations without errors or data inconsistencies.
Solution
Built a full-stack Next.js dashboard providing secure CRUD operations, role-based access control, and advanced auditing. The platform enables administrators and editors to manage critical trade data, while providing read-only visibility into historical landed cost calculations for compliance and analysis. Key capabilities include:
- HS Document Management: Centralized library of Harmonized System codes, tariffs, and regulations with strong validation.
- Companies & Countries: Maintain profiles of trading partners and reference country data with relational integrity.
- Landed Cost History: Powerful, searchable, and filterable read-only logs of all cost calculations.
- User Management & RBAC: Admins, Editors, and Viewers with precise permissions; forced password set/reset flows for maximum security.
- Audit Trail: Field-level change tracking for all create, update, and delete operations, providing complete visibility into system changes.
Architecture & Tech Stack
- Frontend: Next.js 15 with React 19 and Tailwind CSS, Shadcn/UI for reusable components.
- Backend: Next.js API Routes with SWR for client-side data fetching and caching.
- Authentication & Authorization: Auth.js with server-side session management and middleware-enforced RBAC.
- Database: MongoDB Atlas with Mongoose ODM ensuring schema validation, referential integrity, and predictable data relationships.
- Forms & Validation: React Hook Form + Zod for real-time frontend and backend validation.
- Data Visualization: Recharts for charts and summary dashboards.
Outcome
- Centralized, secure, and highly efficient internal management of trade data.
- Drastically reduced errors in landed cost calculations and regulatory compliance.
- Streamlined workflows with role-based permissions and audit logs, ensuring accountability and security.
- Scalable architecture allowing easy extension to additional trade modules or reporting tools.
