Storing a New Offcut
Open the Store page, enter the offcut details, choose the location where the offcut will be stored, and click Store. The system assigns the next board code automatically.
Offcuts Inventory System
This is a Django-based inventory system for tracking reusable board offcuts in a factory environment. Staff can store, search, relocate, and withdraw offcuts using board codes, material details, dimensions, colours, and storage locations.
Workflow Demonstrations
Searching Available Offcuts
Open the Search page and choose the relevant filters. Then, check the result code and location, go to that location and look for the offcut with the matching code.
Relocating and Withdrawing Offcuts
Find the offcut from the Search page, open the action menu, then choose Relocate to move it to another storage position or Withdraw to remove it from active inventory.
Factory Implementation Context
Storing a New Offcut in the Factory
Measure the physical offcut, enter its details in the Store page, save it, then write the generated board code on the board so it can be found later.
Searching Available Offcuts in the Factory
Search using the offcut details you know, then check the result code and match it with the physical board that has the same code written on it.
Factory Board Codes
These photos show examples of boards after their codes have been written on them; once the system search gives a code, staff can use it to identify the correct physical board.
Additional Features
- Repeated storage tasks are optimized by preserving values such as colour, thickness, material, G2S, and location, so the user only needs to enter length and width for similar offcuts.
- If a colour is missing, the user can use Add New Colour. Similar existing colours are flagged to help avoid duplicates.
- Access is password-protected, and staff tracking is intentionally omitted so any authorised worker can manage offcuts as needed.
Tech Stack
- Backend: Django
- API layer: Django views / internal JSON endpoints
- Database: PostgreSQL/Neon in production, SQLite locally
- Frontend rendering: Django templates, CSS, and JavaScript
- Deployment: Render