Each store kept its own sheet. Head office never knew what was on the shelf, and transfers were a phone call and a hope.
We built a small inventory app: stock by location, transfers, and a head-office view. Staff use it in the browser. It talks to the accounting tool they already pay for, so sales are not typed twice.
Managers see what is in each store without calling the floor.