How to

Open Item Master (under Stock in the menu) and choose the department.
Press With my stones in stock to get a sheet filled with every stone’s details as they are now — or Blank sheet for just the columns. For only some stones, tick them on Stock and press Update from Excel.
Change the sheet in Excel. A blank cell leaves the stone as it is; type a single - (minus) to clear a detail. Delete any column you don’t want to touch.
Back in Item Master, upload the file. Every change shows as Now and Will be, and any problem is listed by row — nothing is saved yet.
Fix any problems in the file and upload it again, then press Apply. Every stone in the file is saved, or none.

Good to know

Pcs, carat, cost, status, branch and the Refno / SKU No itself are never changed here — they only change through a purchase, sale, memo or other document.
The columns are the ones on your Purchase screen, with your own names. The selling price column only appears for people allowed to see selling prices.
Colours, labs and other list values must match your Reference Data (capitals don’t matter). Add a new one there first.
A HUID already on another piece is refused, so two pieces never share one.
To set the same value on many stones — say, the same lab — tick them on Stock and use Edit details instead.

Still stuck? WhatsApp or call us on +91 97262 88072, or use Help & support inside Avirat — we’ll see the screen you’re on.