Project description
TranslatedOur small distribution company is drowning in Excel spreadsheets, and we're looking for a developer to build a clean and reliable web application focused entirely on inventory tracking. Goods are stored in three physical warehouses, and right now no one can say in real time how many units of a specific SKU we have, where they are, or when we'll run out. We need a single source of truth: a product catalog with SKU, categories, units of measure, supplier links, and accurate stock by warehouse that updates when goods arrive or leave.
The core is daily goods movement. Employees must receive shipments against supplier orders, move goods between warehouses, and process write-offs or adjustments with reasons and full change history. A supplier order should have a simple lifecycle: draft, sent, partially received, or fully received, and the system should suggest reorder quantities based on reorder points we set for each SKU. Low-stock and out-of-stock alerts should appear on the dashboard and ideally be sent on a schedule so the buyer reacts before shelves empty. Barcode scanning is critical: warehouse staff will use phone cameras or USB scanners to find items, confirm receipt, and recount stock during inventory, so the interface must work well on mobile.
We also need meaningful reporting: current stock value, goods movement history per item, slow movers, and inventory discrepancy reports with CSV or Excel export. Note: this is not a full e-commerce store and not heavy ERP with accounting and payroll; we intentionally need just the narrow warehouse tracking tool with role-based access for warehouse staff, procurement, and managers. Clean interface, sensible permissions, and reliable data integrity matter more than any extras.
— SKU catalog across multiple warehouses with stock by location
— Receipt, transfers, write-offs, and adjustments with history
— Supplier orders with reorder points and volume suggestions
— Low-stock and out-of-stock alerts on dashboard
— Barcode scanning via phone camera or USB scanner
— Stock value, movement history and discrepancy reports, CSV/Excel export
— Role-based access for warehouse, procurement and managers
The core is daily goods movement. Employees must receive shipments against supplier orders, move goods between warehouses, and process write-offs or adjustments with reasons and full change history. A supplier order should have a simple lifecycle: draft, sent, partially received, or fully received, and the system should suggest reorder quantities based on reorder points we set for each SKU. Low-stock and out-of-stock alerts should appear on the dashboard and ideally be sent on a schedule so the buyer reacts before shelves empty. Barcode scanning is critical: warehouse staff will use phone cameras or USB scanners to find items, confirm receipt, and recount stock during inventory, so the interface must work well on mobile.
We also need meaningful reporting: current stock value, goods movement history per item, slow movers, and inventory discrepancy reports with CSV or Excel export. Note: this is not a full e-commerce store and not heavy ERP with accounting and payroll; we intentionally need just the narrow warehouse tracking tool with role-based access for warehouse staff, procurement, and managers. Clean interface, sensible permissions, and reliable data integrity matter more than any extras.
— SKU catalog across multiple warehouses with stock by location
— Receipt, transfers, write-offs, and adjustments with history
— Supplier orders with reorder points and volume suggestions
— Low-stock and out-of-stock alerts on dashboard
— Barcode scanning via phone camera or USB scanner
— Stock value, movement history and discrepancy reports, CSV/Excel export
— Role-based access for warehouse, procurement and managers
Web programming Cash, Bank transfer
