Cosmovex/tools

Count spare parts in workshop bins by scanning the bin labels or part codes

Spare parts bin count with Scanlist

This page opens in Add quantity mode with Location and Condition columns suggested, for a stock take of spare parts in a workshop or store room. Scan the part barcode or the bin label, set the quantity you counted, and export a list that carries the location of each bin.

  1. Name the list after the store room or the rack, and set its default Location (Pro).
  2. Scan the part barcode or the bin label. If you are counting loose parts, scan once and set the quantity with the plus button.
  3. Type a note for parts that are worn, ordered or in the wrong bin.
  4. Move along the rack; scanning the same code again adds 1, so a bin scanned twice shows 2.
  5. Export to Excel and compare with the quantity your maintenance system expects.
spare parts inventory scanner parts bin count appworkshop stock take scannerscan bin labels to excelmaintenance spares count
Open Scanlist Free to start · no account

What to know

Bin labels in a store room are often Code 128 or QR codes made for the shelf, not the manufacturer's barcode on the part. Either works, as long as the list uses one consistently: scan the bin label and set the quantity you counted in the bin, or scan every part. The code is saved as text, so labels such as 00417 keep their zeros.

The usual error in a parts count is a bin counted twice or skipped. A Scanned at time on every row shows the order in which the racks were walked, and Pro's duplicate warning mode alerts you when a code is already in the list instead of adding to it, which is useful when each bin should be scanned once. Pro Compare then lists what is missing, short, over or extra against an expected-stock CSV exported from your maintenance system.

Free scanning is unlimited; three exports a day include 25 rows each, and Pro removes the row limit. A phone works without a signal in a basement store room once the page is open, because the list is saved on the device after every scan.

Updated · Cosmovex

Questions

Should I scan the bin or each part?

Either, but not both. Scanning the bin label and typing the counted quantity is quicker for loose parts; scanning each part is more exact for serialised or high-value ones.

Can it warn me if I scan the same bin twice?

Yes, in Pro: duplicate warning mode shows a warning when a code is already in the list instead of adding 1 to it.

Does it work without mobile signal?

Scanning and the list work offline once the page is open, and the list is saved on the device after each scan. Exporting checks the free limit online; when that cannot be reached, one export a day is still allowed.

How do I compare the count with the system?

With Pro, press Compare with expected stock and choose a CSV with a code column and an optional quantity column. It lists missing, short, over and extra lines and can export them.

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