Skip to content

Stock Lookup Tool

File: /home/dini/Documents/lemo/Stock review V2.1.html

Self-contained offline HTML tool for searching stock by item code from a CSV export.

Features

  • Upload CSV via Admin tab, stored in IndexedDB
  • Live fuzzy search in Lookup tab (200ms debounce)
  • Results limited to 50, sorted by available qty
  • Clear All Data button in Admin tab

Technical Notes

  • Hardcoded column indices (0, 5, 6, 8, 9) — needs header-mapping when CSV layout is known
  • All client-side, no server, works offline
  • Previous version: /home/dini/Documents/lemo/attachments/Stock review V2.0.html

Changes Made

  1. Replaced naive line.split(",") with parseCSVLine() (handles quoted commas)
  2. Removed highlight feature (dead code)
  3. Added 200ms debounce on search
  4. Added try/catch error handling on upload and search
  5. Added keyboard accessibility on tabs
  6. Added Clear All Data button in Admin tab
  7. Saved as V2.1 in Documents/lemo/ (outside attachments/)