How to Use QR Codes for Inventory: Step-by-Step Guide

You have stuff — tools, stock, IT equipment, medical supplies, event gear — and you want to know what's in the closet, who took it, and where it went. QR codes solve this for pennies, and you can build the whole system yourself in an afternoon.

This tutorial is for the small business owner, warehouse manager, or ops lead who searched "how to use QR codes for inventory" and wants a simple way to know how many boxes are on shelf 4B. We'll walk through the full workflow (assign IDs, generate codes, print, scan, track) using free tools you can wire up today.

QRelix is free to start, with dynamic QR codes and live scan tracking on the free plan, so you can follow this tutorial end-to-end without a credit card. Each free code works for its first 50 scans, so labels that get scanned often need Pro ($5.99/month).

What You Need Before You Start

You need three things:

• A spreadsheet or database to track item metadata. Google Sheets is enough to start. Airtable or Notion give you a richer interface if you want one.
• A QR code generator that supports tracking. Static QR codes work for basic identification, but dynamic QR codes (which QRelix offers free) let you update the destination without reprinting labels — critical for inventory that moves.
• A label printer or a way to print stickers. Any inkjet or laser printer with adhesive label paper works. For high volume or harsh environments (workshops, warehouses), a thermal label printer that prints waterproof labels is worth having.

If you already use Google Workspace and a home printer, you're set.

Step 1: Assign a Unique ID to Every Item

Before you generate a single QR code, decide how you'll ID items. This is the foundation, and it's the step people skip. Pick a scheme that's:

• Human-readable. TOOL-DRILL-042 beats x9F2K1Q. When something breaks or gets lost, you want to say the ID out loud without looking it up.
• Categorized. Prefix by type (TOOL-, IT-, MED-, STOCK-). Filtering becomes trivial later.
• Zero-padded. Use 042, not 42, so sorting works in spreadsheets.

Create a Google Sheet with columns: ID, Name, Category, Location, Assigned To, Notes, QR Code URL, Last Scanned. This is your source of truth.

Step 2: Generate a QR Code for Each Item

For every row in your spreadsheet, generate a QR code that points to a URL unique to that item. There are two schools of thought.

Option A — Dynamic QR codes pointing to a hosted landing page. Each item gets a dynamic QR code whose destination you control, such as a page or spreadsheet row with the item details and a check-in/check-out form. This is the modern approach because you can change the destination without reprinting labels. QRelix's free plan includes dynamic QR codes and scan tracking, with 50 scans per code, so this costs nothing to test.

Option B — Static QR codes pointing directly to your spreadsheet row. Each code encodes a direct link to a Google Sheet row or Airtable record. It works, but you can't track scans, and if you ever move the sheet, every label breaks.

Go with Option A. It's what serious operations use, and it's free.

To batch-generate: open QRelix, create a dynamic QR code for each item pointing to a hosted item page (or a Google Form pre-filled with the item ID). Save the QR image and short URL back into your spreadsheet. If you're setting up hundreds of items, batch it in groups of 50 rather than trying to do it in one sitting.

Step 3: Print and Attach the Labels

Print each QR code onto adhesive label paper. A few notes from experience:

• Print the human-readable ID next to the QR, not just the code. When a QR is scratched or dirty, the text is your backup.
• Minimum size: 1 inch by 1 inch (2.5 cm). Smaller than that and phone cameras struggle in dim warehouses or garages.
• Test-scan before you batch-print. Print one, scan it with your phone, confirm it resolves to the right page. Then run the rest.
• Use durable material for items that get handled a lot. Waterproof vinyl labels cost pennies more and outlast paper by years.

Attach labels in a consistent spot — top-right corner, next to the serial number, wherever — so scanners always know where to look.

Step 4: Set Up Check-In and Check-Out Scans

This is where most DIY setups fall apart. If checking out an item requires opening a spreadsheet on a laptop, no one will do it. Make it a phone-based, sub-10-second task.

The workflow:

1. Employee scans the QR code with their phone camera (no app needed on iOS or Android).
2. The QR opens the item's landing page.
3. The page shows current status (available, checked out, in for repair) and a button to change it.
4. If checking out, the employee enters their name (or picks from a dropdown) and submits.
5. The action is logged, and the item's status updates.

You can build this in Google Forms + Google Sheets in 30 minutes. Point each QR at a pre-filled Form URL that captures the item ID, timestamp, action (check-in or check-out), and employee name. Every submission appends to a sheet.

Airtable does this cleaner if you want a nicer UI — set up a public form per item and let responses flow into a shared base.

Step 5: Track Scans and Attribution

Here's where dynamic QR codes pay off: you get scan-level analytics without wiring anything.

QRelix's free tier logs every scan with:

• Timestamp
• Approximate location (city-level)
• Device type
• Referrer (if the QR was scanned from a digital source)

Combine that with your check-in/check-out log and you have a full picture: what was scanned, when, by whom, and roughly where. Review it monthly for reporting.

On QRelix's free plan this scan logging costs nothing. Each free code works for its first 50 scans and shows a brief QRelix screen before forwarding; QRelix Pro ($5.99/month) removes both limits.

Step 6: Add Alerts and Reports

Once the basics work, layer on light automation:

• Low-stock alerts. If a spreadsheet column crosses a threshold (say, stock ≤ 5), trigger an email via Google Apps Script or a Zapier task.
• Missing item flags. If an item hasn't been scanned in 30+ days, surface it in a weekly report.
• Check-out duration alerts. For loanable items (tools, laptops), flag anything checked out longer than a set window.

None of this requires code — Google Sheets IF formulas, conditional formatting, and Apps Script triggers cover most of what you'll want.

Common Mistakes to Avoid When Using QR Codes for Inventory

Every DIY inventory system dies the same three deaths:

1. Using static QR codes for items that move. The moment you rename a category or migrate to a new tool, every static label becomes worthless. Static is fine for permanent metadata (a fixed asset that never changes). For anything mobile, dynamic wins.
2. Making check-in/out too slow. If the workflow is longer than 10 seconds, staff will bypass it. Test with the person who complains loudest — they're your quality bar.
3. Not printing the human-readable ID. Codes get scratched. Cameras fail. You'll thank yourself the first time you read "TOOL-DRILL-042" in plain text alongside the QR.

Static vs. Dynamic QR Codes for Inventory: Which You Actually Need

Short answer: dynamic, almost always.

Static QR codes encode the destination directly into the code image. Change the destination and you reprint every label. Fine for permanent metadata, terrible for inventory that moves.

Dynamic QR codes point to a redirect URL you control. You can change the destination anytime, and scans are trackable. QRelix's free plan includes dynamic QR codes with scan analytics.

If you're testing this workflow, start with dynamic. You'll thank yourself the first time you need to fix a broken link or repoint to a new landing page.

When a Spreadsheet Stops Being Enough

This DIY approach works fantastically up to about 500 to 1,000 items. Past that, you'll hit real limits:

• A shared spreadsheet gets harder to manage when many people edit it at once.
• Manual check-in/out doesn't scale to warehouses with dozens of scans per minute.
• You need purchase orders, hardware barcode scanners, or reporting across several locations.

At that scale, write down what you need before you change your setup. Until then, keep the simple system.

FAQ

Do I need a special app to scan QR codes for inventory?

No. iOS and Android camera apps have scanned QR codes natively since 2017. Point, focus, tap the notification. That's it.

Can I use QR codes in cold storage or freezers?

Yes, with the right label material. Use freezer-grade vinyl adhesive labels — standard paper degrades in condensation and falls off within weeks.

What if a QR code gets damaged?

Reprint from your spreadsheet. Because each item has a unique ID and a stable dynamic URL, the replacement label points to the same landing page. No data loss.

Can multiple people scan the same item at once?

Yes. Several people can scan the same label at the same time, and each form submission is saved as its own row. On the QRelix free plan each code works for its first 50 scans, so labels that are scanned often need Pro ($5.99/month), which makes scans unlimited.

Are QR codes better than barcodes for inventory?

For most small ops, yes. QR codes hold more data, scan from any smartphone (no hardware scanner required), and tolerate damage better. Barcodes still win in retail POS environments where speed and hardware integration matter more than flexibility.

Start Your Free QR Code Inventory System Today

You need a spreadsheet, a printer, and a dynamic QR code for each item.

Try QRelix free, no credit card required, and generate your first dynamic, trackable QR code in under a minute. The free plan includes unlimited dynamic QR codes and scan analytics, with 50 scans per code. Follow the six steps above and you'll have a working inventory system by end of day.

Related guides: QR code asset tracking for tools, IT gear, and field equipment, and QR code for product tracking for items that leave the building.