How to Use QR Codes for Inventory: A Step-by-Step Tutorial (Free 2026)

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 doesn't want to buy $200/month software just 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 tier — so you can follow this tutorial end-to-end without a credit card. We'll flag where paid tiers make sense, but the whole system in this post runs on free.

What You Need Before You Start

You don't need a warehouse management system. You need three things:

• A spreadsheet or database to track item metadata. Google Sheets works for under 10,000 items. 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 Brother QL-820NWB or Zebra thermal printer runs under $200 and prints waterproof labels.

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 short URL like qrelix.com/i/tool-drill-042 that resolves to a page showing item details, last scan, and a check-in/check-out button. This is the modern approach because you can update the landing page without reprinting labels. QRelix's free tier includes dynamic QR codes and scan tracking, 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. Export to CSV monthly for reporting.

Most paid inventory systems charge $50 to $200/month for this level of tracking. On QRelix's free tier, you get it for zero.

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 tier includes dynamic QR codes with scan analytics — most competitors charge $10 to $50/month for the same functionality.

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 to Graduate to Paid Inventory Software

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

• Google Sheets slows with heavy concurrent editing.
• Manual check-in/out doesn't scale to warehouses with dozens of scans per minute.
• You'll want features like purchase-order integration, hardware barcode scanner support, and multi-location reporting.

At that scale, tools like Sortly, ClearlyInventory, or Odoo Inventory make sense. But don't buy them until the free system genuinely bottlenecks you — most small ops never hit that ceiling.

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. There's no rate limit on scans, and Google Forms handles concurrent submissions without conflicts.

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 don't need software. You need a spreadsheet, a printer, and a QR code generator that supports tracking.

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