HOLO·SCAN

Point at bottle caps — names float over every code automatically. Search a code to locate a bottle on the shelf. Load any Excel list to scan a different inventory.

ADD MEDICINE

Saved on this phone and scannable immediately.

CODE MEDICINE NAME POTENCY PACK SIZE

Print at 100% scale — label is 1 cm. Scannable from screen too.

LOAD EXCEL LIST

Pick any .xlsx/.csv with a code column and a name column (potency & pack optional — header names are auto-detected). Choose whether it replaces or merges with the current list. Stored on this phone.

MODE

GOOGLE SHEET SYNC

Publish your sheet (File → Share → Publish to web → CSV), paste the link once, and every phone stays in sync. Columns auto-detected like Excel import.

PUBLISHED CSV URL

WHIMS LIVE

Connect to your WHIMS Google Sheet to see live stock for any code you search, add found bottles straight to inventory, and flag low stock for reorder.

WEB APP URL USERNAME PASSWORD

ADD TO WHIMS INVENTORY

isn’t tracked in WHIMS yet. Fill in the starting details to create it as a new inventory row — Status is set as a live formula automatically, same as every other item.

MEDICINE NAME POTENCY PACK SIZE CATEGORY STARTING STOCK — BOTTLES STARTING STOCK — ML (optional) REORDER PRIORITY 0–5 (optional) PRIMARY SUPPLIER (optional) PRIMARY COST ₹ (optional) REMARKS (optional)