Cosmovex/tools

Do a shop stocktake with your phone, aisle by aisle, with prices

Retail stocktake with Scanlist

This page opens in Add quantity mode with Location and Price columns suggested and CSV as the first export, for counting the stock in a shop one aisle or bay at a time. Scan each unit and the quantity climbs; the export is a count per barcode with the aisle and the shelf price alongside, ready for your stock system or a spreadsheet that works out the stock value.

  1. Make one list per aisle or bay and set its default Location (Pro), for example Aisle 3, so every scan in that aisle carries it without typing.
  2. Tap Start scanning and read the EAN or UPC on each unit. Scanning the same product again adds 1, so a shelf of 8 identical items is 8 scans, or one scan and the plus button 7 times.
  3. Put the shelf-edge price in the Price column (Pro) on the first scan of each product; it stays on that row and is written as a number in the Excel export.
  4. Note anything damaged, out of date or in the wrong bay on its row, then move on to the next bay.
  5. Export the list as CSV at the end of the aisle, or press Continue when you come back and keep one running count; Import CSV to continue merges an earlier export into the current list.
  6. For a variance report, use Compare with expected stock (Pro) with the stock-on-hand CSV from your till or stock system: missing, short, over and extra per barcode.
retail stocktake with phone stocktake app for small shopshop stock count barcode scannerstock take by aislestocktake to csvcount stock with phone camera
Open Scanlist Free to start · no account

What to know

A stocktake goes faster when each list is one physical area, because the count can be checked against the shelf while you are still standing in front of it. Add quantity mode turns repeat scans into a count per barcode, and the Price column lets a spreadsheet multiply quantity by price for the stock value. Codes are saved in one canonical form: an EAN-13 that starts with 0 is the same bars as a UPC-A and is kept as the 12-digit UPC-A, and a UPC-E on a small pack is kept as the 8 digits printed under it. If your till stores the expanded 12- or 13-digit forms, line the two up in the spreadsheet before you compare.

Variable-weight products such as cheese, meat and deli packs use barcodes that start with 2 and embed the price or weight, so every pack scans as a different code and the count spreads across many rows. Count those by product in the note, or type the product's PLU into the box under the scanner and use the plus button. Chilled cabinets and glossy packaging reflect the light; angle the phone a little and switch the light off if the glare is worse with it on. A crushed or faded barcode can be typed instead of scanned.

Compare (Pro) reads the stock-on-hand CSV from your till, takes the column named code, barcode, sku, ean or upc (or the first column) and a quantity column, sums quantities per code on both sides and lists each product as missing, short, over or extra. Keep the till export's code column as text, because a lookup between a text code and a numeric code never matches. Free covers a small section: three exports a day of 25 rows each. A whole shop needs Pro, which lifts the row limit, keeps a named list per aisle and scans continuously without a tap between products.

Updated · Cosmovex

Questions

Do I have to scan every single unit on the shelf?

No. Scan one unit and press the plus button for the rest, or type the quantity. Scanning every unit is slower but catches a stray product hiding in the wrong facing, because it would appear as its own row.

Why do fresh-food packs scan as a different code each time?

Variable-weight barcodes starting with 2 embed the weight or price in the code, so each pack is unique. Count those by product in a note, or type the PLU for the product into the box under the scanner and add up with the plus button.

My till exports UPC codes with 13 digits. Will Compare match them?

Not as they are: the scanner keeps a UPC-A as its 12 digits and a UPC-E as its 8 printed digits, and Compare matches the exact text. Add or remove the 0 at the start in the till export with a formula first, keeping the column as text, then save it as CSV.

How much stock can I count on the free plan?

Scanning is unlimited. Exports are limited to three a day of 25 rows each, which suits a bay or a small section. Pro removes both limits and keeps a named list per aisle.

Can I count the shop over two evenings?

Yes. The list is saved on the phone after every scan; open the page again and press Continue. Exporting a CSV each evening and importing it the next with Import CSV to continue also works, and quantities add up per code.

Is my stock list uploaded?

No. The list stays on the phone until you export it. Only an export count with a random browser ID is sent, to apply the free limit.

The free plan covers everything on this page. Scanlist Pro ($5/mo, billed monthly) is described on the Scanlist page.