How to Run a Stocktake With an iPhone
You can run a full stocktake — the annual physical inventory count — with the iPhones and Android phones your team already carries. The method: divide the space into zones, give every counter DataScan with identical export settings, count each zone as a scan-and-quantity session, then merge each person's exported file into one spreadsheet and reconcile against system stock. No rented scanner hardware, no counting service.
The stocktake problem: one day, all hands, no room for error
A stocktake (physical inventory count, stock count, annual count — the word varies by side of the Atlantic) compresses a year of record-keeping truth into one high-pressure day. The traditional versions both hurt: clipboards mean a second full pass of typing handwriting into a spreadsheet, and rented scanner terminals mean cost, training the night before, and hardware nobody has used since last year. Meanwhile every counter on your team is carrying a device with a better scanner than the rental units.
The phones are not the hard part of a stocktake. Coordination is — which is why most of this guide is about preparation and merging, not scanning.
Before count day: preparation that decides the outcome
- Freeze movement. Count outside trading hours, or cordon receiving and dispatch. Stock that moves mid-count is the classic source of unexplainable variance.
- Tidy first. Returns in the right bin, overstock pulled forward, mystery boxes opened before the count. Counting a messy shelf is slower than tidying and then counting it.
- Label the unlabeled. Bulk goods and house-made items need house barcodes printed ahead of time, or a plan for a short manual list.
- Brief the counters. Ten minutes: how to scan, how to enter quantities, what to do with damaged stock, who to ask. The app itself needs no training beyond that.
Stocktake with iPhones, step by step
- Divide the space into zones Cut the store or warehouse into zones one person can count in 30-60 minutes — an aisle, a wall of shelving, the back room. Draw it on a floor plan and assign names. Every shelf belongs to exactly one zone: gaps and overlaps are how items get counted zero or two times.
- Prepare the phones Every counter installs DataScan — iPhone and Android mix freely, the exports are identical — and gets the same settings: export format, column headers, date format. Settings can be deployed across the device fleet, so this is minutes, not an evening. The 7-day free trial covers a whole stocktake, so a pilot run costs nothing.
- Count zone by zone in Single Value mode Single Value Scan is the stocktake mode: scan the product's barcode, count the shelf, type the quantity, next product. One session per zone, named after it (zone-A3 2026-07-10). Everything stores locally with timestamps — no signal needed in the basement or the cold room.
- Export every session Finished counters export each session as CSV or Excel to one collection point: a shared mailbox via SMTP email, an FTP/SFTP server, or the share sheet. Because each phone exports its own file, there is no mid-count server dependency and no sync to fail.
- Merge the files into one count Identical columns make merging mechanical: one paste per file into a master sheet, then a pivot table by barcode summing quantities — which also correctly handles stock of the same item found in two zones. Spot-check a few rows per counter before moving on.
- Reconcile and book the results Compare counted totals against system stock (the cycle counting guide shows the VLOOKUP-and-variance pattern). Recount significant variances the same day while access is easy, then post adjustments. Keep the session files: timestamped scan data is exactly the evidence your accountant or auditor wants behind a stock valuation.
How long does a phone stocktake take?
Budget from the zones: a practiced counter in Single Value mode moves at a few seconds per product line plus the time to physically count the facing, so a typical retail aisle zone lands in the 30-60 minute range it was designed for. Four counters working parallel zones cover a small store in an evening and a modest warehouse in a day. Merging and reconciliation add an hour of desk work — pastes, a pivot table, and the variance review — which is the part clipboard counts used to spend a full extra day on.
Accuracy tips from painful experience
- Count blind — never show counters the expected quantity; it magnetizes results.
- Recount hot spots by a different person. A second counter repeating the same error is rare; the same counter repeating it is common.
- Watch case-versus-unit quantities. The classic stocktake bug: scanning a case barcode and entering 1 when it holds 12. Decide the rule per category in the briefing.
- Don't split a zone between people. Fatigue-splitting an aisle produces double counts at the seam; reassign whole zones instead.
After the annual count: the same phones, the same modes, and a fraction of the effort keep records accurate all year — that is cycle counting, and it is how retailers like the one in the retail cycle counting case study made the annual shutdown count unnecessary.
Alternatives, weighed honestly
Professional stocktaking services count fast and bring their own hardware; for very large estates or when staff time is the scarcest resource, they are worth the per-count fee — but you learn nothing about where your errors come from, and the data ends up in their format. Rented scanner terminals put the tooling in your hands at rental-plus- shipping cost and one more system to learn annually. Clipboards are free and slow, and the transcription pass adds errors precisely where you were trying to remove them. Phones with a purpose-built app sit in the practical middle: hardware you own, data in your format, and skills that carry over to receiving checks and audits the rest of the year. See what else the same setup covers on the DataScan homepage.
Frequently Asked Questions
Yes, and teams routinely do. Each counter scans their zone with DataScan, exports a file, and the files merge in a spreadsheet. What matters is preparation — clear zones, identical export settings on every phone, one session per zone — not the hardware.
Each phone works independently: its own sessions, its own export file. Because every device uses the same column settings, merging is one paste per counter, and a pivot table by barcode produces the combined count. No live connection between devices is needed.
Loose produce, bulk goods, and handmade items need a house solution: print your own barcode labels for them before the count (any label printer works — DataScan reads Code 128, QR, and 11 other types), or count them on a short manual list and add it to the merged spreadsheet at the end.
Yes. Every scan is stored locally on the phone, so coverage does not matter while counting. Counters export their files when they are back in signal or on Wi-Fi — nothing is lost in between.
