How to Make Product Price Tags with Barcodes from a Spreadsheet

Price tags often need to be small, dense with info, and scannable.

1. Prepare Data

Columns needed:

• Product Name (e.g., "Silk Scarf")
• Price (e.g., "$25.00")
• SKU (e.g., "SCARF-001") - for the barcode
• Variant (Optional: "Red", "Small")

2. Choose Template

Retail tags come in various shapes.

• Specialty Shapes: Jewelry barbells, rattails (requires specialized thermal printers).
• Standard: Rectangles (e.g., 1" x 2") printed on standard sheets.
• Cardstock: If printing on cardstock to cut later, define a custom grid with "guides" as cut lines.

3. Design Layout

1. Price: Make this the largest element. Bold, bottom right or top right.
2. Name: Legible, top left.
3. Barcode:
   • Add Barcode element.
   • Bind to SKU column.
   • Use EAN-13 (if you have GTINs) or Code 128 (internal use).
   • Ensure it's not too small to scan.

Image Placeholder: [Example of a completed price tag design]

4. Tips

• Currency Symbol: If your data is just "25.00", add the "$" in a text box before the merge field: ${{Price}}.
• Discount Codes: Add a small distinct marking (like a star or dot) for items on sale, referencing a column in your data.