The minimum an inventory program needs
- Products: name, code or barcode, unit, purchase and selling price.
- Movements: received from a supplier, sold, damaged, and count adjustments.
- Minimum level: the quantity at which a reorder alert appears.
- Reports: low items, slow movers and stock value.
Steps to build and run it
- 1Standardize product names
One product, one name, one code. Duplicates are the first thing that ruins stock figures.
- 2Count the shop physically
Count what is on the shelves and enter it as the opening balance; do not trust old numbers.
- 3Build the screens
Product list, stock-in screen, stock-out screen and a low-stock report.
- 4Test the scanner
Scan several products and confirm the program finds them the first time.
- 5Count a section every week
Compare one shelf with the program, correct the difference and look for its cause.
Spreadsheet or program?
| Situation | Best fit |
|---|---|
| Few products and one person recording | A tidy spreadsheet is enough |
| Several staff and many daily movements | A program that records the movement and who made it |
| Barcodes, low-stock alerts and reports | An inventory program |