ERP System for Manufacturing
Replacing spreadsheet chaos with a unified system - inventory, purchases, production and accounts in one place.
The Problem
A manufacturing business with 50 employees managed operations across 8 spreadsheets - inventory, purchase orders, production schedules, dispatch, accounts receivable, accounts payable, employee records and quality tracking.
Nobody had the full picture. Inventory was wrong half the time. Purchase orders were duplicated. Production delays were discovered days after they happened.
Requirements
- Unified inventory management with real-time stock levels across raw materials, work-in-progress and finished goods.
- Purchase order management with approval workflows.
- Production tracking with stage-wise visibility.
- Financial dashboards with receivables, payables and cash flow.
- Role-based access for warehouse, production, purchase, accounts and management.
- Mobile access for warehouse staff.
Architecture
- 01React and TypeScript frontend with role-based views.
- 02Python backend with FastAPI.
- 03Postgres database with row-level security.
- 04Supabase for auth and real-time updates.
- 05Mobile-optimised warehouse interface for scanning and stock updates.
- 06Scheduled jobs for reorder alerts and report generation.
Results
- Inventory accuracy went from 70% to 98%.
- Purchase order processing time dropped from 2 days to 2 hours.
- Production delays are now caught in real-time instead of days later.
- Management gets a daily dashboard with key metrics.
- Warehouse staff use mobile phones for stock updates - no more paper records.
- Monthly closing time dropped from 5 days to 1 day.
Frequently Asked Questions
Can this handle multiple locations?
Yes - multi-location inventory with location-wise stock levels and inter-location transfers.
Does it work on phones?
Yes - the warehouse and production interfaces are mobile-first for floor staff.
How long did the ERP take?
Core modules (inventory, purchase, production) shipped in 12 weeks. Financial dashboards and reporting added in the following 6 weeks.
Want something similar?
I can build a custom solution for your business. Let's talk about your project.