SKUs · Asset tags · Warehouse labels

Inventory QR Code Generator | Create Product Labels in Bulk

Generate QR codes for your entire product catalog instantly. Perfect for inventory management, warehouse labeling, and asset tracking.

Built for inventory teams

Label products, locations and assets from one spreadsheet

A tidy inventory depends on every item and every location having an ID you can scan instead of type. Whether your master list lives in Excel, Google Sheets or an ERP export, MultipleQR turns one column of SKUs, bin codes or asset tags into a numbered set of QR images you can drop into any label template. It is free, needs no account and runs entirely in your browser.

🏷️

Product and SKU labels

One code per SKU or variant for shelf-edge labels, polybags and cartons. Staff scan to find the item in your system instead of reading long part numbers.

🗄️

Bin and location labels

Encode aisle, rack, shelf and position codes such as BIN-A01-03-B so put-away and picking are confirmed with a scan instead of by eye.

💻

Fixed-asset tags

Tag laptops, tools, furniture and rental kits with an asset number that links to their record in your asset register or spreadsheet.

🧪

Lot and batch numbers

Print lot or batch codes for production runs, so a scan tells you which batch a case belongs to during stock rotation or a recall check.

📋

Cycle-count sheets

Add a code next to each location on printed count sheets, so counters can scan their position and avoid logging stock against the wrong bin.

🔒

Your item master stays private

SKUs, part numbers and internal codes are turned into images on your own device. Nothing is uploaded to a server.

Labeling workflow

From item master to labels on the shelf

01

Clean the master list

Remove duplicate SKUs, fix IDs that Excel has changed and decide on one naming pattern before anything is printed. Relabeling later costs far more time.

02

Pick one label type per batch

Run products, locations and assets as separate batches. Each label type usually goes on different stock and in a different part of the warehouse.

03

Paste the ID column

Copy the single ID column into the generator, or save it on its own as a one-column CSV without a header and upload it.

04

Verify the count, then download

The number of codes should equal the number of rows. Download the ZIP. qr-1.png matches the first ID, qr-2.png the second, and so on.

05

Fill your label template

Merge the PNGs into an Avery sheet, a roll-label layout or a shelf-strip template, with the ID also printed as text beside each code.

06

Apply and spot-check

Label one aisle, scan a sample with the phone or handheld your counters use, confirm the right record opens, then roll out the rest.

Sample input

Inventory IDs that make good QR labels

Short, fixed-format IDs give simple codes that still scan on small labels. Paste one value per line and each line becomes one PNG.

SKU-0001
SKU-0002
SKU-0003
BIN-A01-03-B
BIN-A01-04-A
AST-IT-00427
LOT-2609-17
https://example.com/assets/AST-IT-00427
  • SKU-0001… Product labels. Zero-padding keeps the IDs the same length and sorting in the right order.
  • BIN-A01-03-B Aisle A01, rack level 03, position B. The code describes the place, not what is stored there.
  • AST-IT-00427 / LOT-2609-17 An IT asset tag and a production lot. The prefixes stop them being confused with SKUs.
  • https://…/assets/AST-IT-00427 Opens the asset’s record in your own system from a plain phone camera. Use this when staff do not have a scanner app.

Label sizes

Recommended QR sizes for inventory labels

Each PNG is 300 × 300 px, which is 1 inch (2.54 cm) at 300 DPI. You can print it smaller on tiny tags or larger on rack signs, because QR modules stay square and sharp when scaled evenly. Always print the ID as text too, so a person can still read a damaged label.

Label Suggested QR size Placement tip
Product / polybag label 2–2.5 cm On a flat face, away from folds, seams and heat seals
Shelf-edge strip 2.5–3 cm Left edge of the slot, directly below the product it refers to
Bin or tote front 3–4 cm Centred on the front, above the handle cut-out
High-rack location sign 10–15 cm Read from the floor. Roughly one tenth of the scanning distance
Laptop or tool asset tag 1.5–2 cm Short IDs only. Use a durable polyester or laminated tag
Pallet position on the floor 8–10 cm Under a clear protective cover, out of forklift wheel paths

Go deeper with our guide to QR codes for inventory management, the bulk QR code generator walkthrough and what GS1 Sunrise 2027 means for 2D codes at retail checkouts.

Avoid these

Common inventory labeling mistakes

Encoding data that changes

Price, quantity and current location go out of date, and printed static codes cannot be edited. Encode the ID and keep the rest in your system.

Letting Excel reformat IDs

Lost leading zeros and 1.23E+11-style numbers produce codes that match nothing. Format the column as Text before you copy it.

Uploading the whole item master CSV

Every cell becomes its own code: descriptions, prices and header names included. Export only the ID column, with no header row.

Duplicate IDs in the list

Two identical lines produce two identical codes, and a scan can then match the wrong item. Remove duplicates in your sheet before generating.

Paper labels in cold rooms or outdoors

Condensation, freezer frost and sunlight destroy paper labels quickly. Use synthetic label stock or lamination where conditions are harsh.

Labels on curved or ribbed surfaces

A code wrapped around a pipe or across a ridge distorts the grid. Choose a flat spot, or use a hang tag on cables and tools.

Related tools

More bulk QR generators

Common questions

Inventory QR code generator — FAQ

Should an inventory QR code store the SKU or the full product details?

Store a stable identifier: the SKU, asset tag or bin code. Details such as description, price, quantity or supplier change over time, and a printed static code cannot be edited. Keep those details in your spreadsheet or inventory system and let the scan bring up the record for that ID.

Can scanning the label show the current stock level?

Only if the code points to a system that shows it. The QR code holds fixed text. You can encode a link to the item’s page in your own inventory app, for example with the SKU at the end of the URL, and that page shows live quantities. MultipleQR itself does not store or display stock.

Excel keeps changing my SKUs. How do I stop that before generating?

Excel removes leading zeros (000123 becomes 123) and turns long numeric IDs into scientific notation (1.23E+11). Format the ID column as Text before you paste or import data, or add a letter prefix such as SKU-000123. Check a few values in the generator preview before you download.

QR code or regular barcode for bin and shelf labels?

Both work. Choose based on your scanners. QR codes can be read by phone cameras and most 2D handhelds, hold longer values and still scan when the label is at an angle. If your warehouse only has 1D laser scanners, they cannot read QR codes. MultipleQR only makes QR codes, so check your hardware first.

Can I print inventory labels on standard Avery or roll label stock?

Yes. Place the PNGs in the label template for your sheet or roll in Word, Google Docs, Avery Design & Print, or the software for your Brother or DYMO printer. At 300 DPI each 300 px image is 1 inch wide. Set its size in the template instead of stretching it by eye.

What happens to the labels when a product moves to another bin?

Nothing needs reprinting if you label both the product and the location. The bin keeps its BIN- code, the product keeps its SKU code, and your system records which SKU is in which bin. Encoding the location inside the product label is what forces a relabel.

I have more than 10,000 SKUs. Should I generate them all in one go?

There is no fixed cap, but every code is drawn by your own device, so very large lists take longer and use more memory. Splitting the catalog by aisle, category or site into batches of a few thousand keeps the browser responsive and makes each ZIP easier to match to its print run.

How do I reprint a single damaged or missing label?

Type or paste just that ID, such as BIN-A01-03-B, and download the single PNG. It will be named qr-1.png whatever its position in the original batch, so rename it to the ID before placing it in your template. Because the code only contains the ID, the new label scans exactly like the old one.