QRAnalytica

How Do I Use QR Codes for Inventory Tracking?

For QR code inventory tracking, put an item ID in each code, log every scan as stock in or out, and let a sheet or app add it up into current stock.

Nookesh Karri · 8 min read
Dark cover card with the title 'How Do I Use QR Codes for Inventory Tracking?' in white and a lime accent bar

QR code inventory tracking works when each code holds a short item ID, every scan records a movement (stock in, stock out or a count), and a spreadsheet or app adds those movements up into current stock. The code never stores the quantity. It only tells the system which item you’re holding.

Most guides blur that point, and it’s where small setups go wrong.

How QR code inventory tracking works

QR code inventory tracking is a lookup: the code identifies the item, and a separate record holds everything that changes. Price, location and quantity live in a sheet or database. The printed label stays the same for the life of the item.

Think of it as a ledger. Each scan adds a row: which item, how many, in or out, who and when. Current stock is then a calculation, not a number someone types over. Google’s own AppSheet inventory tutorial uses exactly this shape. It keeps Product, Sales and Purchases tables and works out stock as initial stock + stock in - stock out.

A ledger also beats a single “quantity” cell. When two people scan at once, both rows survive. With one cell, the second edit overwrites the first and a sale quietly disappears.

What to put in the code and what to keep in the sheet

The code should hold one thing: a short, unique item ID such as SKU-0142, or a link that ends in that ID. Everything else goes in the sheet.

Put in the QR codeKeep in the sheet or app
Item ID or SKUName and description
(Optionally) a link containing the IDCurrent quantity
Shelf or bin location
Supplier, cost and reorder level
Every stock movement

Short codes also print smaller and scan faster. QR codes come with four error correction levels, and a higher level makes the code bigger. Level M (15%) is the usual choice. For labels that get scuffed in a warehouse, a higher level is worth the extra size, and a short ID keeps that size manageable.

Benefits over barcodes, and where barcodes still win

QR codes beat 1D barcodes for small teams mainly because any phone camera reads them. They also hold a full link, so one scan can open a form or record directly.

Barcodes still win when your products already carry them. Relabelling stock that has a working UPC adds cost and no benefit. Retail is changing slowly, though. The GS1 Sunrise 2027 effort is a shift from 1D UPC barcodes to 2D codes like QR at the checkout. GS1 asks brands to move existing QR codes to its Digital Link standard. That applies to codes on retail packaging, not to the shelf labels in your stockroom.

A free setup with Google Forms and Sheets

The cheapest working setup is one QR code per item that opens a Google Form with that item’s ID already filled in. The responses land in a sheet, and a formula totals them.

  1. List your items in a sheet with columns for ID, name, location, starting stock and reorder level.
  2. Build one movement form with three questions: Item ID (short answer), Direction (In, Out, Count) and Quantity (number).
  3. Make a pre-filled link per item. In Google Forms, use More > Pre-fill form, type the item ID, then Get link. Each link opens the form with that item’s ID set.
  4. Turn each link into a QR code. With dozens of items, a bulk generator saves hours; see our bulk QR code guide for the CSV approach.
  5. Link the form to a sheet and add a summary tab that sums In minus Out per item ID, plus starting stock.
  6. Flag low stock with a filter or conditional format where current stock is at or below the reorder level.

A real example: a bike repair shop labels the bin of inner tubes TUBE-700C. A mechanic grabs two for a job, scans the bin, picks Out, types 2 and submits. The summary tab drops from 7 to 5. When it hits the reorder level of 4, the row turns red and the owner orders more.

For more on the form side, our guide to making a QR code for a Google Form covers sharing settings that trip people up.

When to move to an app or inventory software

A form-and-sheet setup suits a few people and a few hundred items. Past that, scanning one form per movement gets slow, and you’ll want an app that scans straight into a record.

SetupGood forWatch out for
QR codes + pre-filled form + sheetOne shop, a stockroom, a club, a school labOne movement per form; no offline mode
No-code app on a sheet (AppSheet)Small teams that want a real scan buttonCamera scanning needs a paid tier
Inventory softwareMany locations, purchase orders, sales channelsMonthly cost and setup time

AppSheet is the usual middle step. Its scanner reads QR Code, Code 128, Data Matrix and PDF417, and the scanned value goes straight into a column. Two catches: scanning needs the Core or Enterprise plan, and it doesn’t work in the browser version, only on a phone, a tablet or an external scanner. Google’s Inventory Management template is a decent starting point.

Labels, placement and counts

Inventory labels fail from wear, not from the code. Print on synthetic or laminated labels for anything handled daily, and keep a white margin around each code.

  • Label the bin, not the screw. Small or loose items get a code on the bin, shelf or case.
  • Size for how people scan. A code on a high shelf needs to be larger than one on a desk. Our QR code print size guide has the numbers.
  • Do cycle counts. Use the Count direction once a week on a few bins. The difference between the counted and calculated stock shows theft, breakage or missed scans.
  • Train everyone on one rule: no item leaves without a scan.

Where QRAnalytica fits, and where it doesn’t

QRAnalytica is not an inventory system, and I wouldn’t use it as one. It counts scans of dynamic QR codes by city, device and hour, anonymously, without cookies or personal data. It doesn’t know which item was taken or how many, and it doesn’t keep a stock count.

Where it helps is the other side of the label: codes on product packaging that customers scan, where you want to know which product, city or batch drives scans. Bulk CSV creation is on the Pro plan at $39/month if you need many codes at once.

The limitation: any dynamic code depends on its provider’s redirect servers staying up. A shelf label that only holds an item ID takes on that risk for no gain, so use free static codes there.

My take

I’d start every small inventory project with QR codes, a pre-filled form and a sheet. It costs nothing, it teaches your team the scan habit, and the ledger it builds carries over to any app you move to later. Move to AppSheet or inventory software only when one-form-per-scan starts to annoy people, not before.

FAQ

Can a QR code store the stock quantity?

Not in a useful way. A printed code can’t change, so a quantity inside it is wrong after the first sale. Put an item ID in the code and keep the count in a sheet or inventory app.

Do I need a barcode scanner for QR inventory?

No. A phone camera reads QR codes. Dedicated scanners are faster for high-volume counting, but most small shops and stockrooms start with phones.

Should inventory QR codes be static or dynamic?

Static, in most cases. An inventory label only needs a fixed item ID. Dynamic codes help when the label opens a web page you may want to change later.

Can I do QR code inventory with Google Sheets?

Yes. Make one QR code per item that opens a Google Form with the item ID pre-filled, send responses to a sheet, and add a formula that totals stock in and out per item.

Will QR codes replace UPC barcodes on products?

Retail is moving that way. The GS1 Sunrise 2027 effort is a shift from 1D UPC barcodes to 2D codes like QR at the point of sale, though full adoption isn’t required by that date.

Sources

Track your dynamic campaigns. 7-day trial, no credit card.
Generate Dynamic QR