Variable-data labels for batch tracking

Three cases drive 90% of VDP demand. First: FDA-regulated products where lot tracking is required for potential recall — dietary supplements (cGMP), drugs, cosmetics in some categories, food products with allergen contamination risk. The FDA requires you to be able to identify and recall a specific production lot within hours. Variable lot codes on every unit make this possible.

Second: retail traceability. Whole Foods, Erewhon, Sprouts, and most natural-channel retailers expect lot codes per case for their inventory management. You don't always need unique-per-bottle codes, but you need lot-level codes that distinguish production runs.

Third: customer-facing personalization or unique URLs. QR codes linking to a per-bottle landing page, per-bottle warranty registration, per-bottle authentication for anti-counterfeit. Becoming standard for premium supplements and prestige beauty.

• FDA traceability (supplements, drugs, regulated cosmetics)
• Retail lot codes (Whole Foods, Erewhon, natural channel)
• Unique QR codes per piece (anti-counterfeit, personalization, registration)
• Sequential serial numbers (limited edition, drops, gift personalization)
• Expiration date per batch (food, drink, supplements)

Most digital presses accept a CSV with one row per label. Column headers map to variable fields in the label artwork. Example: a supplement label might have three variable fields — LotCode, ExpirationDate, QRCodeURL — and your CSV looks like LotCode,ExpirationDate,QRCodeURL with 5,000 rows underneath.

Common formats: CSV, TSV, Excel (.xlsx), JSON. Bazaar Printing accepts all four. The total record count must match the order quantity — if you order 5,000 labels you need 5,000 rows in the CSV. The press won't auto-repeat the data file unless explicitly configured to.

For sequential codes (lot codes that increment, like LOT-2026-00001, LOT-2026-00002), most printers can generate the sequence on the press side — you specify the format string and starting number, and the press does the increment. For random or external codes (codes pulled from your manufacturing system), upload the CSV.

QR codes can be generated two ways. First: pre-generate every QR code as an SVG or PNG and include the file paths in the CSV (one column with the QR image filename). Second: include just the encoded URL in the CSV and the printer's RIP software renders the QR on the fly. The second approach is cheaper and avoids data file size problems.

Reserve a defined area in the label artwork for each variable field. Lot codes, batch numbers, and expiration dates need at least 0.4 in wide × 0.15 in tall in 6-8 pt monospace type. Don't try to embed a variable lot code in a decorative typographic treatment — the press composites the variable in a fixed font and a fixed location.

QR codes need at least 0.5×0.5 in minimum for a smartphone camera to scan reliably from 6 inches away. For consumer-facing QR codes, 0.75-1 in is the sweet spot. Quiet zone (white space around the QR) must be at least 4 modules wide — usually 1/8 in.

Color: variable-data fields print best in process black or a single spot color. Don't run variable data through a full CMYK overprint sequence — the press will register slightly differently between fixed artwork and variable artwork, and small offset registration issues are most visible in the variable block.

Reserve a defined rectangle in the artwork for each variable field. Lot codes need 0.4 in wide. QR codes need 0.5×0.5 in. Quiet zones are non-negotiable.

Variable-data printing on digital presses doesn't slow the press meaningfully. HP Indigo 6K runs at the same 30-40 linear meters per minute whether the data is fixed or variable. Konica and EFI presses are similar. The cost premium for VDP is in prepress (the RIP setup to ingest and compose the variable data) and is a one-time setup cost on the first job, then included on reorders.

Per-piece cost on variable data is minimal on a standard order. Some printers charge a flat per-thousand variable-data premium; others absorb it into base pricing. Ask upfront. Start a Quote for live pricing.

What's not free: sequential serial number tracking, where you need a record of which serial code mapped to which physical case. If you need a chain-of-custody manifest tying serial codes to case-pack assignments, that's additional production overhead.

FDA cGMP for supplements (21 CFR Part 111) requires that every lot of finished product be uniquely identified and traceable to the raw materials, manufacturing equipment, and production date. Most brands implement this with a lot code format like LOT-YYYYMMDD-NN where YYYYMMDD is the production date and NN is a sequence number within the day.

Expiration dates for supplements are required (per cGMP) to be supported by stability testing. The label must show the expiration date in a format the consumer can read (MM/YYYY at minimum, MM/DD/YYYY preferred). Variable data lets you align the printed expiration with the actual production date — print 'EXP 06/2028' on the label of a batch produced 06/2026 with a 24-month stability claim.

For Whole Foods and similar retailers, the lot code format requirement is usually that it be uniquely identifiable and traceable to the vendor. Most retailers accept any reasonable format as long as it's printed, readable, and consistent across cases.

Variable QR codes per bottle unlock three categories. First: anti-counterfeit (premium beauty and supplements). Each bottle has a unique QR linking to a verification API that confirms the bottle hasn't been scanned before. Combats grey-market reselling. Useful at premium retail price points.

Second: customer experience and content. QR links to a how-to-use video, a brand story, a recipe — high-value for products with non-obvious usage (a new supplement, a custom blend). Conversion lift on first-purchase customers is real but small (1-3%).

Third: warranty registration and CRM. QR links to a registration page that captures the customer email and ties the product to a serial number. Useful for premium home goods and beauty devices.

What doesn't work: QR codes for couponing or discount drops on consumable food/bev products. The customer wants the food now and won't scan a QR to get a small discount off a future purchase. Save QR codes for higher-consideration categories.

Bazaar Printing runs variable-data labels in-house on HP Indigo 6K. We accept CSV, Excel, JSON, and sequential-format spec; we render QR codes on the fly from URL data; we ship a CSV-template starter file so you can structure the data file once and reuse it across reorders.

If you're moving from a fixed-data label to variable-data for the first time — say, your supplements brand just hit the cGMP compliance gate — we'll do the prepress setup once, save the template against your brand, and run reorders on the same template with new CSV data only.