Part of the Library Koha Suite — quickly compare two barcode lists and find items missing from your shelf-check against the catalogue, then export or print the results.
The Stock Verification Module helps library staff perform physical stock-taking (shelf verification) by comparing a full inventory export against a list of barcodes that were actually scanned during the stock check. Any barcode present in the inventory but not found in the scanned list is flagged as a missing record — meaning that item could not be located on the shelf.
The tool runs entirely in the browser via a simple upload form: no data is stored permanently, results are calculated on the fly, and you can preview, print, or download them as a CSV file.
Upload two CSV files — your master inventory list and your scanned-barcode list — directly from your computer.
Instantly identifies every barcode from the inventory file that is missing from the scanned file.
Missing items are listed with a running serial number and all original columns (Title, Author, Price, etc.).
Automatically sums the price column of all missing items so you know the total value unaccounted for.
Download the missing-items list as a timestamped CSV file, ready to file or share.
Print the results table directly from the browser for physical record-keeping.
Only authenticated Koha Suite users can access the tool; the current user and login time are always shown.
The layout adapts cleanly to tablets and phones, so stock checks can be reviewed on any device.
The comparison relies on two CSV files, each with a specific column layout:
| Column | Field | Notes |
|---|---|---|
| 1 | Barcode | Unique identifier used for matching |
| 2 | Title | Item title |
| 3 | Author | Item author |
| 4 | Price | Used to calculate the total value of missing items |
A single-column CSV containing only the barcodes that were physically scanned/found during the stock check. The first row is treated as a header and skipped.
Exported files are named automatically using the pattern
missing_barcodes_YYYY-MM-DD_HH-MM-SS.csv so every export is uniquely timestamped and easy
to file alongside your stock-take records. The exported CSV always includes the S.No column, the
original headers from File 1, and the total price row.
Use the Print Results button to send the current results table straight to your browser's print dialog — useful for physical sign-off sheets.
Make sure both files are selected before submitting — both uploads are required.
Confirm that the Price column is the 4th column in File 1 and contains plain numbers (no currency symbols or thousands separators).
Barcode matching is exact and case-sensitive — check for extra spaces, leading zeros, or formatting differences between the two files.
No — files must be saved as CSV first. Most spreadsheet programs offer "Save As → CSV (Comma delimited)".