Check the box next to any products that need labels. Enter or update the Lot #, Mfg date, and Exp date.
☑ BBS5 │ Lot #: ABC123 │ Mfg: 01/2025
☐ R222 │ Lot #: XYZ789 │ Exp: 07/2027 │ Mfg: 01/2025
☑ BBAC5 │ Lot #: DEF456 │ Exp: 06/2026
Manual — takes ~1 minute
Double-click the shortcut on the desktop. Everything from here is automatic.
Manual — one click
Reads the live spreadsheet, filters to only checked rows, and collects the product code, lot number, and dates for each.
Automatic
For each product, finds the Illustrator file in the product folder, reads the die size from the filename, selects the matching InDesign template, and builds the variable text string.
BBS5 → found BBS5 - Baikal Skullcap 16oz - H - GREEN.ai → Die U → "BBS5 Lot #: ABC123 Mfg: 01/2025"
Automatic
Opens the die-size template, places the product's artwork, overlays the lot/date text, and exports a PDF directly into the product's folder. Repeats for each checked product.
Compliance Page can also be generated at this step.
→ Product Labels/.../BBAC5/BBAC5 - Some Product - T - BLUE.pdf ✓
→ Product Labels/.../BBS5/BBS5 - Baikal Skullcap - U - GREEN.pdf ✓
Output — ready to print
