PHP/MySQL Inventory Management System with Multi-Store Access Control

Заказчик: AI | Опубликовано: 13.11.2025

Project Description We are looking to hire an experienced PHP developer to build a fully customized Inventory Management System powered by PHP and MySQL. The system will support multi-store operations, strict role-based access control, asset lifecycle management, and easy bulk data import. 1. Technology Requirements Backend: PHP (Laravel, CodeIgniter, or pure PHP—developer to propose) Database: MySQL Frontend: Developer may propose (Bootstrap preferred) Hosting: Standard shared hosting / cPanel environment 2. User Roles & Access Control Main Office (HQ) Full visibility of all inventory records across all stores. Ability to: Delete assets Decommission assets Transfer assets between stores Manage/create users / assets across all stores Local Store Manager Can only see and manage inventory for their own store. Can create inventory items (cannot delete). Can create store-level staff users. Can assign assets to staff and track loan/return history. 3. Inventory Asset Fields Each asset record must include the following fields: Equipment Name Asset Tag Number System-generated unique format per store/branch Serial Number (if applicable) Model Number (if applicable) Manufacturer (if applicable) Purchase Price (if applicable) Purchase Date (if applicable) Payment Voucher Number (if applicable) Department In Charge (Dropdown list managed by HQ) 4. Asset Management Features Assign assets to store-level staff. Maintain an audit trail of: Loans Returns Transfers to another store (the other party must accept otherwise inventory remains in their records) Decommissioning All asset movements must be searchable and exportable. 5. Import & Export Functions Bulk upload new users via CSV/Excel. Bulk upload assets via CSV/Excel. Export inventory or loan history to Excel/CSV. 6. Expected Deliverables Full PHP/MySQL web application. Source code with proper documentation. SQL database schema. Admin manual & user guide. Installation instructions for cPanel/shared hosting. 7. Developer Requirements Proven experience building PHP/MySQL systems. Experience with inventory/asset modules is highly preferred. Strong understanding of Role-Based Access Control (RBAC). Ability to build clean, responsive UI (Bootstrap preferred). Able to commit to providing testing support and minor revisions.