Print jewelry inventory barcodes from Excel
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.
A jewelry book is SKU, description, and price. Design a small tag in the free label maker, barcode {{sku}}, add metal and {{price}}, then upload and print the case reset.
Good to know: Measure the tag stock. A 2x1 will not wrap a ring. Use a jewelry tag size you actually bought.
How to print jewelry inventory barcodes from Excel
- Open https://app.mylabelmaker.com. No signup. Set the tag size you actually bought, often 2x0.5 or 2x1.
- Put headers in row 1: sku, name, metal, price.
- Add a small CODE128 barcode on {{sku}}. Put {{name}}, {{metal}}, and {{price}} next to it.
- Upload the Excel file. Print two tags, check they fold, then print the case.
Sample spreadsheet
A Saturday case reset.
| sku | name | metal | price |
|---|---|---|---|
| J-104 | Chain 16in | SS | $42 |
| J-105 | Hoops small | 14k | $120 |
| J-106 | Signet 7 | SS | $58 |
First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.
Generic jewelry maker: jewelry label maker.
Print or save
Got a Zebra? Print from the browser with Browser Print, at the printer's DPI. Otherwise download PNG, JPG, SVG, PDF, or ZPL. JSON keeps the label you can open later.
Print this case reset
Map the book, print two tags, check the fold, then the tray. No signup.
Open free label maker