Complete Pharmacy Inventory Tracking Module
Budget: ₹1,500 – ₹12,500 INR
My pharmacy-inventory site on Hostinger is roughly 70 % finished; what remains is the inventory tracking section. The codebase, database, and basic UI are already in place, so the task is to plug in the missing functionality rather than start from scratch.
Scope of the remaining work
• Build a stock-level monitoring module that fits seamlessly into the current layout and uses the existing database connection.
• For every product row, show the item name, its unique code, current quantity on hand, and supplier information. The table must auto-refresh or update without a full page reload.
• Add simple search and filter tools so I can quickly locate items by code, name, or supplier.
• Include safe CRUD actions (add, edit, archive) that respect the current validation rules already coded elsewhere in the site.
• Keep the code consistent with the project’s file structure and commenting style so I can maintain it later.
Tech context
The site is hosted on a standard Hostinger LAMP stack. You will receive FTP access, database credentials, and a quick walkthrough of the existing controllers, models, and views so you can extend them directly. No framework change is needed.
Acceptance criteria
1. Inventory page lists all items with real-time stock levels.
2. Updates made via the interface reflect instantly in the database.
3. All fields—item name, code, quantity, supplier—display correctly and stay aligned on mobile and desktop.
4. No existing pages break; unit test file included or at least clear manual test steps.
5. Final delivery: updated source files + SQL patch (if any) + short README showing where you touched the code.
Optional enhancements such as automatic restocking alerts or batch/expiry management can be discussed later, but for now the focus is solid stock-level visibility.
I’m ready to hand over access as soon as you confirm you can take it from here and hit the ground running.
Scope of the remaining work
• Build a stock-level monitoring module that fits seamlessly into the current layout and uses the existing database connection.
• For every product row, show the item name, its unique code, current quantity on hand, and supplier information. The table must auto-refresh or update without a full page reload.
• Add simple search and filter tools so I can quickly locate items by code, name, or supplier.
• Include safe CRUD actions (add, edit, archive) that respect the current validation rules already coded elsewhere in the site.
• Keep the code consistent with the project’s file structure and commenting style so I can maintain it later.
Tech context
The site is hosted on a standard Hostinger LAMP stack. You will receive FTP access, database credentials, and a quick walkthrough of the existing controllers, models, and views so you can extend them directly. No framework change is needed.
Acceptance criteria
1. Inventory page lists all items with real-time stock levels.
2. Updates made via the interface reflect instantly in the database.
3. All fields—item name, code, quantity, supplier—display correctly and stay aligned on mobile and desktop.
4. No existing pages break; unit test file included or at least clear manual test steps.
5. Final delivery: updated source files + SQL patch (if any) + short README showing where you touched the code.
Optional enhancements such as automatic restocking alerts or batch/expiry management can be discussed later, but for now the focus is solid stock-level visibility.
I’m ready to hand over access as soon as you confirm you can take it from here and hit the ground running.