QR Codes for Inventory and Asset Tracking: Stop Losing Stuff, Start Scanning

If you run a warehouse, a repair shop, a retail store, or any business with stuff that moves — you've lost track of something this month. Maybe it was a power tool left on a job site. Maybe it was a pallet that arrived but never got logged. Maybe it was 40 units of a product sitting in the back room while the shelf stayed empty.

QR codes fix this. Not the enterprise, six-figure, SAP-integration kind of fix. The "stick a label on it, scan it with your phone, done" kind.

Here's how small businesses are using QR codes for inventory and asset tracking — and how you can set it up today.

Traditional barcodes need dedicated scanners, proprietary software, and line-of-sight scanning at close range. QR codes need… a phone. That's the whole pitch.

But the advantages go deeper:

Every QR tracking system has two parts:

1. The QR label — physically stuck on the item (shelf, pallet, tool, equipment)
2. The destination — what the QR code links to when scanned

The destination is where the magic happens. Instead of encoding "SKU-4892" into the QR code (static), you create a dynamic QR code that opens a URL like yourcompany.com/track/SKU-4892. That URL can show:

• Current stock count
• Last scanned location and timestamp
• Who last handled it
• Photos, notes, maintenance history
• A form to log movement or checkout

You update the data in a Google Sheet, Airtable, or Notion database. The QR code never changes. The data is always live.

• QR code generator — QRs.bd (free dynamic codes with analytics)
• Cloud spreadsheet — Google Sheets, Airtable, or Notion
• Label printer — any inkjet or thermal printer, or order pre-printed labels
• Smartphones — your team already has them

Total startup cost: $0 if you already have a printer. Under $50 if you buy a basic thermal label printer.

Stick a QR code on every shelf, bin, or pallet location. When a worker picks an item, they scan the code and log the quantity change. The spreadsheet updates instantly.

What to track: item name, SKU, quantity on hand, reorder point, last restocked date, supplier.

Result: No more walking to a computer to update stock. No more "I thought we had 20 left" conversations. Real-time visibility from the warehouse floor.

Contractors, landscapers, repair shops — anyone who shares tools — knows the pain of "Who had the drill last?" QR codes on tools solve this in seconds.

How it works: Each tool gets a QR label. Scan it, and a form pops up: name, date, job site. Next person scans, sees who had it last, checks it out.

Bonus: Set up alerts when a tool hasn't been scanned in 7 days. That's how you catch equipment left on a job site before it walks away.

Retail stores lose sales when products sit in the backroom instead of on the shelf. QR codes on storage bins let stockers scan, see what's in the bin, and confirm it's been moved to the floor.

Track: bin location, product, quantity, date moved to shelf, who moved it.

Result: Managers see exactly what's in the backroom without walking back there. Stocking accountability goes up. Shelf gaps go down.

Offices, clinics, and shops have expensive fixed assets — monitors, printers, medical equipment, display units. QR codes tied to an asset register let you:

• Scan to see purchase date, warranty status, and depreciation
• Log maintenance and repair history
• Track which room or location the asset is in
• Run audits by scanning every asset in a room in minutes

Pro tip: Use QR codes for insurance documentation. When an adjuster visits, they scan each asset and pull up the full purchase and maintenance record instantly.

When a shipment arrives, scan the QR code on each pallet or carton. The form pulls up the purchase order: what was ordered, what should be there. The receiver confirms quantities, flags shortages or damage, and the log updates automatically.

Result: Disputes with suppliers get resolved in seconds. "We sent 50" meets "we scanned 47" with timestamps and names attached.

Here's the exact workflow to go from zero to QR-tracked inventory:

This is the most important decision in your setup.

Static QR codes encode data directly. The code always resolves to the same content. Good for permanent identifiers — but if you need to change what happens when someone scans it, you reprint every label.

Dynamic QR codes encode a short URL that redirects to your chosen destination. You can change the destination anytime from your QRs.bd dashboard — no reprinting needed.

For inventory and asset tracking, always use dynamic QR codes. Here's why:

Every time someone scans a dynamic QR code, QRs.bd logs the scan — timestamp, location (city-level), device type, and referrer. Over time, this data tells you things your spreadsheet can't:

• Which items get scanned most? Those are your high-traffic, high-movement assets.
• Which items never get scanned? Dead stock. Surplus. Or items that have gone missing.
• What time of day does scanning peak? Staff your warehouse accordingly.
• Which locations scan most? Identify your busiest job sites or departments.

This turns your tracking system into a business intelligence tool — for free.

1. Too-small QR codes. If the code is under 0.75" × 0.75", older phones and bad lighting will struggle. Go at least 1" × 1".

2. No error correction. QRs.bd defaults to 30% error correction (Level H). If you're using another generator, make sure it's not set to Level L (7%) — one coffee stain and the code is dead.

3. Linking to a form that requires login. Your warehouse crew won't create a Google account to log a stock check. Use anonymous form submissions or a public Notion page.

4. Not testing before printing 500 labels. Print one. Scan it. Fill the form. Check the data shows up in your sheet. Then print the rest.

5. Forgetting to update when items move. The QR code doesn't know the item moved — a human has to scan and log it. Build the habit: scan on pick, scan on place.

Mike's setup:

• 120 tools with QR labels (weatherproof vinyl, $18 total)
• Google Form with three fields: name, job site, action (pick/return)
• Google Sheet dashboard showing who has what
• Weekly audit: scan every tool in each van, flag anything missing

Total time to set up: 4 hours over a weekend. Monthly savings: $700+.

Google Sheets works great for 50–500 items. Beyond that, you'll want:

• Airtable — handles 50,000+ records with linked tables, automations, and views
• Notion databases — great for teams already in Notion
• Custom app — a simple web form + database (Bubble, Glide, or Retool can build this in a day)
• Dedicated inventory software — Sortly, inFlow, or Fishbowl, all of which support QR scanning

The beauty of dynamic QR codes: you start with Google Sheets, then swap the destination URL to your new system. Zero relabeling. The codes stay the same.