Stock Lookup Tool

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

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

Features

• Upload CSV via Admin tab, stored in IndexedDB
• Live fuzzy search in Lookup tab (200ms debounce)
• Results limited to 50, sorted by available quantity
• Clear All Data button in Admin tab
• All client-side, no server, works offline

Technical Notes

• Hardcoded column indices (0, 5, 6, 8, 9) — needs header-mapping when CSV layout is known
• Replaced naive line.split(",") with parseCSVLine() (handles quoted commas)
• Keyboard accessibility on tabs
• All client-side, no server, works offline

Changelog (V2.1)

1. Replaced line.split(",") with parseCSVLine() for quoted comma handling
2. Removed highlight feature (dead code)
3. Added 200ms debounce on search input
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 in Documents/lemo/ (outside attachments/)

Related

• [[Index]]
• [[JBS LEMO Shopify Storefront]]