Print consignment barcodes from Excel

A shop tagging 40 items from one seller.

← Back to Blog

Print consignment barcodes from Excel

Published: · 3 min read · How-to
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.

Open price tag template

Intake is a spreadsheet: seller, item, price. Design one tag in the free label maker. Barcode {{sku}}. Add {{price}} and a short name. Upload. Print before the items hit the floor.

Good to know: Payout rules and tax wording stay yours. The sticker only shows the row.

How a consignment shop prints intake tags

  1. Headers: sku, seller, name, price.
  2. Open the free label maker. Set 2x1 or a hang tag size.
  3. CODE128 with {{sku}}. {{name}} and {{price}}. Optional {{seller}}.
  4. Upload the Excel file. Print. Hang as you check the rack.

Sample spreadsheet

Saturday intake from one seller.

skusellernameprice
C-881Maya RDenim jacket M$28
C-882Maya RWool scarf$12
C-883Maya RLeather belt$18

First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.

eBay SKUs: eBay SKU barcodes. Price-only reprint: price tags from Excel.

Print or save

Zebra thermal: print from the browser with Browser Print at the printer’s DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. JSON keeps the editable master.

Tag this intake

The seller’s list. Stickers on the rack.

Open free label maker