Mobile Inventory System with IMEI Scanner – Google Sheets

An inventory system designed to be used from a phone, with Google Sheets behind it. That matters more than it sounds: stock work happens standing in front of a shelf or a display counter, not at a desk, and the phone camera is the scanner. Items are added by scanning, sold with one status change, and invoiced from the same screen.

What it does

Staff log in with a role, and each user sees the data their role allows. A device or item is added with its details, and its IMEI or serial is captured with the camera rather than typed — which is where most stock records go wrong. QR and barcodes can be scanned and also generated, so items that arrive without a label get one. Each item carries a status of Stock or Sale; selling it is a quick status update with the customer, date and price attached, and a printable invoice comes out of the same record. The dashboard reports totals, how many are in stock, how many sold and the value sitting on the shelf, with a stock balance by brand, and any list exports to CSV. Files and images upload to Google Drive with share links.

Highlights

• Camera capture of IMEI or serial numbers
• QR and barcode scanning, plus a generator
• Stock and Sale status with a quick update modal
• Sale details — customer, date and price
• Dashboard metrics: total, in stock, sold and value
• Stock balance by brand
• Printable invoices and CSV export
• Role-based login with per-user data visibility

Who it is for

Mobile phone shops, electronics retailers and small warehouses that track serialised stock. Anywhere an item has a unique number that must match what is physically on the shelf, scanning beats typing.