Every piece different, thousands of them
A standard bulk print run produces thousands of identical copies. A variable data run produces thousands of copies where something changes on each one: a sequential number, a person's name, a unique QR code, a membership ID or a personalised offer. Digital presses make this possible without a separate set-up for each piece, because the press receives a new page image for every sheet.
Variable data printing is now common for event tickets, vouchers, membership cards, direct mail, certificates and packaging with serial numbers. It also brings a different set of risks from a standard run. A typo in one record is a misprinted piece, a duplicate number is a real problem, and the data file has to be right before the press starts. This guide explains how variable data jobs work at volume, how to prepare the data, how they affect turnaround and cost, and how to check the output.
Types of variable data
| Type | Examples | What to watch |
|---|---|---|
| Sequential numbering | Tickets, vouchers, raffle stubs, forms | Start and end number, leading zeros, no gaps or duplicates |
| Names and addresses | Direct mail, certificates, invitations | Spelling, long names, character sets |
| Unique codes | QR codes, barcodes, promo codes | Code format, scan testing, matching your database |
| Variable images or text blocks | Offers by customer segment, regional versions | File paths, image sizes, which version goes to whom |
If what changes is a whole design version shared by hundreds of copies, the job is closer to a multi-version run. Our article on printing many versions of one flyer covers that case.
Preparing the data file
Most delays and almost all errors on variable data jobs come from the data file. The printer merges your data into a template exactly as supplied, so whatever is in the spreadsheet ends up on paper.
- One row per piece. Each row is one printed item. If 5,000 pieces are needed, the file has 5,000 data rows plus a header.
- One column per field. First name, last name, member number, QR content and so on, each in its own clearly named column.
- Clean the data first. Remove duplicates, trailing spaces, and test entries like "asdf". Check for names entirely in capitals if you want them in normal case.
- Use CSV or Excel with UTF-8 encoding if any names contain Chinese characters, Tamil script or accented letters. Ask the printer whether the chosen font supports those characters.
- Agree what happens to long entries. A name that is 40 characters long may not fit the space. The template can shrink text to fit, or long entries can be flagged for manual review.
Send a small sample of the data early, even if the full file is not ready. The printer can build and test the template while you finalise the list.
Numbering without gaps or duplicates
Numbered items such as tickets and vouchers have their own rules. State the start number, the end number, the format (for example 000001 with leading zeros), and where the number prints. If numbers appear twice on one item, for example on a ticket and its stub, both must come from the same record.
Spoiled sheets are the tricky part. On a standard run a spoiled sheet is replaced by any other copy. On a numbered run, the spoiled numbers must be reprinted individually, or the set has gaps. Ask the printer how they track and replace spoiled numbers. For controlled items, ask for a report of the final number range delivered. Our guide to overs and unders on a bulk print run explains why exact quantities need special planning.
QR codes and barcodes at volume
Unique QR codes let you track who scanned what, link to personalised pages or validate tickets at the door. The printer generates the codes from the content you provide in the data file, usually a URL or an ID.
- Keep QR content short. Shorter content produces a less dense code that scans more reliably at small sizes.
- Print size matters. Ask the printer for a minimum size for your code density, and keep a quiet zone of blank space around the code.
- Test scan the proofs. Scan a sample of codes from the printed proof with several phones before approving the run.
- Match the database. Make sure the codes being printed are the same ones loaded into your ticketing or CRM system.
Handling personal data safely
A variable data file often contains names, addresses, phone numbers or member IDs. In Singapore, the Personal Data Protection Act applies to how that data is collected, used and shared, including when you pass it to a printer. Send only the fields that will actually print. If a mailing needs names and addresses, there is no reason to include dates of birth or purchase histories. Use a secure transfer method agreed with the printer, not an open email attachment, and ask how long the printer keeps the file after the job and how it is deleted. For regular jobs, a short written agreement covering these points is good practice, and your data protection officer will usually want to see it.
Turnaround and cost
Variable data jobs take longer to set up than static jobs. The template must be built, the data merged and checked, and the proofs reviewed. Once that is done, the print run itself moves at normal digital press speeds. For a fast turnaround, the most useful thing you can do is send clean data early.
Cost is driven by the number of pieces, the complexity of the variable elements and the amount of checking needed. Simple sequential numbering adds little to the cost. Full personalisation with images and several fields costs more per piece. Very large quantities of identical content with only a number changing may suit an offset run with numbering added later on a separate machine; ask the printer to compare.
Proofing and quality checks
A single proof is not enough for a variable data job. Ask for proofs that include:
- The first and last records in the file
- The longest name or entry, to check it fits
- Any records with special characters
- A random sample from the middle of the file
During production, a good printer checks samples from the run against the data file, especially at the start of each batch. On high-value items such as tickets and certificates, ask how the printer confirms the sequence is complete before dispatch. Our article on press checks and sign-off on a bulk run covers approval more broadly.
Packing and delivery
Personalised items often need to be delivered in a specific order: alphabetical for name badges at a registration desk, by postcode for mail, by branch for membership cards. Tell the printer the sort order before printing, because sorting thousands of unique pieces afterwards is slow. Ask for cartons to be labelled with the range they contain, for example "Tickets 000001 to 002500".
Variable data printing with us
We run variable data jobs at volume: numbered tickets and vouchers, personalised letters and certificates, membership cards and items with unique QR codes. Send us a sample of your data and the template, and we will build the merge, return proofs with first, last and longest records, and confirm the schedule. We sort and label output in the order you need. For other digital work, see our digital printing services, or send your requirements through the contact page.
