Serial in the code or serial in the link?
A plain-text static QR can encode SN-000001 directly. It needs no website to reveal that string, but the printed payload cannot later be edited. For this plain-text static QR approach, use a suitable separate generator.
A dynamic QR instead encodes a hosted short link, which redirects to a destination such as https://example.com/p/SN-000001. VastQR describes its dynamic codes as hosted short links in its terms, section 1. The serial is in your destination URL; do not assume the printed QR pattern itself contains the serial, or that a scan can establish the physical item's authenticity.
| Need | Practical design |
|---|---|
| Read a serial without visiting a site | Plain-text static QR from a suitable generator |
| Open a product record that may change | One dynamic QR per item, with a unique destination |
| Use one SKU for many identical units | One code per SKU, unless unit-level traceability is required |
| Verify genuine products or prevent copying | A separate authenticated verification system; a QR alone can be duplicated |
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-000020For 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.
Print and match each label to its item
Use a human-readable serial alongside the QR, and keep a manifest mapping serial, destination, exported image filename and physical item. VastQR states that it exports PNG, SVG and PDF. Check the exported artwork against the manifest and scan physical proofs under expected lighting, distance and surface conditions. The November 18 preview did not establish download correctness or scan success.
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.