Bulk workflows

How to Create a QR Code with a Serial Number or SKU

Create a QR code for each serial number or SKU. See URL patterns, a 20-row CSV example, leading-zero checks, and the active-code limit.

Written by
VastQR Product & Editorial Team
Last updated
On this page
  1. Serial in the code or serial in the link
  2. Build the URL pattern before the spreadsheet
  3. A 20-row sequential CSV
  4. What the recorded 20-row preview actually showed
  5. Preserve leading zeros from export to print
  6. Print and match each label to its item
  7. When per-item dynamic codes are the wrong fit
  8. FAQ

Build the URL pattern before the spreadsheet

Choose an address structure your own site can resolve:

  • Path: https://example.com/p/SN-000001
  • Query: https://example.com/product?sn=SN-000001

For a SKU-level code, a destination could instead be https://example.com/p/SKU-ABC. Use one SKU-level link for interchangeable units that share information; use serial-level links when each physical unit needs its own record. You can mix the two approaches, but maintain a clear SKU-to-serial mapping. These are illustrative, not live item pages. Define whether the ID is case-sensitive, whether leading zeros matter, and how your site handles unknown IDs. Do not expose private customer or warranty data in a public URL. Test your website's lookup logic independently; generating a QR does not build that lookup service.

A shorter encoded string can produce a less dense symbol at a given error-correction level; DENSO WAVE explains QR code versions and capacity. With a hosted dynamic short link, the encoded link is not necessarily the full destination URL.

A 20-row sequential CSV

Prepare one row per serial. This sample shows the first three and last two of a proposed 20-row sheet; fill the intervening rows in order:

title,destination_url
SN-000001,https://example.com/p/SN-000001
SN-000002,https://example.com/p/SN-000002
SN-000003,https://example.com/p/SN-000003
...
SN-000019,https://example.com/p/SN-000019
SN-000020,https://example.com/p/SN-000020

For example, in a spreadsheet where the first data row is row 2, enter ="SN-"&TEXT(ROW()-1,"000000") in A2 to produce SN-000001, then fill down through A21. Enter ="https://example.com/p/"&A2 in B2 and fill down through B21 to build matching destination URLs. These example URLs are not live pages. The ellipsis is explanatory and must not appear in the actual upload. Generate all 20 rows in the spreadsheet, check that the serial in title matches the serial in destination_url, and export a real CSV. VastQR accepts destination_url (or url) and an optional title column; see its Excel/CSV guide.

What the recorded 20-row preview actually showed

A signed-out public batch-preview check recorded by the VastQR team on November 18, 2026 (Pacific time) submitted 20 sequential rows. The preview reported “20 valid dynamic QR codes ready,” retained the titles SN-000001 onward with leading zeros, and flagged zero rows. This was a preview-only check: no codes were activated, downloaded or decoded, and no physical label was scanned. The preview validates rows before signup or payment; nothing is created until activation, as described on the bulk generator page. Do not treat “ready” as proof that each destination exists or that printed labels will scan.

A second public preview check recorded by the VastQR team on November 18, 2026 (Pacific time; November 19 UTC) used 15 data rows, including bare-numeric titles 000001 onward and four invalid destinations. It displayed 11 valid dynamic QR codes ready and 4 rows needing a valid HTTP(S) URL: empty, not-a-url, javascript: and ftp: destinations were flagged. A repeated valid destination was not flagged. Numeric titles shown in the preview retained their leading zeros. This check did not test spreadsheet export, activation, download, decoding or physical scanning. The preview therefore checks URL validity but does not establish destination uniqueness.

Preserve leading zeros from export to print

Spreadsheets may interpret 000001 as a number and export 1; see the VastQR CSV guide for the leading-zero workflow. Format the serial column as text before entering values, or generate a padded text identifier with a spreadsheet formula. Reopen the exported CSV as plain text and inspect the first, middle and last rows. Compare counts, duplicate identifiers, duplicate destination URLs and missing serials in the sheet. For example, =COUNTIF($A$2:$A$21,A2)>1 flags repeated titles and =COUNTIF($B$2:$B$21,B2)>1 flags repeated destinations; fill each check down. The recorded preview accepted a repeated destination URL. Then inspect the batch preview. For the source-of-truth list, keep a separate item-to-serial mapping.

When per-item dynamic codes are the wrong fit

As recorded on the VastQR pricing page on November 18, 2026, the $19/month plan supports up to 500 active dynamic QR codes. At the ceiling, a new active code cannot be created until another is paused; existing active codes keep redirecting. The pause/reactivate guide states that pausing does not change the printed pattern, stored destination or scan count. A run of 800 individually active item codes therefore exceeds that plan's simultaneous active-code limit.

For items whose destination will never change, a static code from another suitable tool may be simpler. If units of a SKU share one product page, a SKU-level code may be sufficient. Build sequences in your spreadsheet; VastQR's print guide says live Sheets synchronization and a public API are not offered.

For long-life product labels, plan for subscription continuity. VastQR's terms, section 6, last updated September 15, 2026, state that hosted dynamic codes stop resolving when a subscription ends and resume without reprinting after resubscription.

Frequently asked questions

Is a serial-number QR code a type of barcode?

Yes. A QR code is a two-dimensional barcode that can hold text or a link; the serial number is the identifier you choose to encode or reference. Your inventory system must decide how that identifier is interpreted.

Can I edit a printed item's destination later?

A VastQR dynamic code's destination can be changed without changing its printed pattern; see the edit-after-printing guide. A plain-text static code cannot have its encoded text edited after printing. For long-life labels, consider the subscription-continuity limitation explained above.

Does one QR per serial prove an item is genuine?

No. A visible QR image can be copied. Authentication requires additional server-side controls, verification policy and threat modeling.