Industrial ERP Platform
- Client
- Industrial Lubricants & Oils Distributor
- Duration
- Ongoing / Production
- Built with
- NestJS, Next.js 14, TypeScript, PostgreSQL, Prisma, Supabase, Stripe, EasyPost, Resend, OpenAI API
Images coming soon — real screenshots being uploadedA complete enterprise resource planning system built for an industrial lubricants and oils distributor — spanning the public storefront customers order from, the admin dashboard staff run the business on, and the backend API tying it all together. Built with AI and automation at its core: reorder points trigger purchase orders on their own, every financial transaction posts its own accounting entries, transactional emails fire automatically off business events, and an internal AI chatbot answers stock questions straight from live ERP data.
Architecture
Three independently deployed services sharing one PostgreSQL database via Prisma:
- Backend (NestJS) — REST API, JWT auth, role-based access control (Super Admin / Staff)
- Admin Dashboard (Next.js) — staff-facing ERP console, installable as a PWA
- Public Website (Next.js, App Router) — customer storefront with Server Components
Core capabilities
- Inventory & Warehousing — multi-warehouse stock tracking, stock transfers, batch/expiry tracking with QC alerts, production/blending orders that convert raw materials into finished goods
- Procurement Automation — supplier management, RFQ-to-purchase-order workflow, automated reorder-point replenishment (MRP-lite) that watches stock levels and one-click generates draft purchase orders, vendor bills (AP)
- Sales & Orders — guest checkout, quote requests, customer groups with tiered pricing rules, credit limit/hold enforcement, returns/RMA workflow linked to credit notes and restocking
- Fulfillment — dispatch orders, in-house delivery driver assignment, multi-carrier shipping labels and tracking via EasyPost
- Finance Automation — double-entry bookkeeping engine that auto-posts journal entries on every order, payment, credit note, and bill, budgets with variance reporting, financial statements
- Internal AI Chatbot — staff-facing assistant answering inventory and stock questions directly against the ERP's live data, no manual report-pulling needed
- Operations — full audit log across every module, automated transactional email (Resend) with per-event throttling, analytics dashboard (revenue, top products, payment aging)
- Storefront extras — blog/CMS, distributor lead-gen forms, supplier self-service portal, Stripe payments
Engineering notes
- Strict TypeScript across all three services, Zod + react-hook-form for every form
- CI pipeline (GitHub Actions) auto-builds and commits backend production output on push
- Sentry error monitoring, Next.js Image optimization throughout, mobile-first responsive design