Print kitting barcodes from a BOM spreadsheet
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 kit is a parent ID plus parts. Design a kit face in the free label maker with {{kit}} as the barcode. For each part line, print a small {{part}} sticker from the same sheet, or run a second pass.
Good to know: One row is one sticker. A kit with six parts is six part rows, plus a kit-header row if you want a tote label.
How to print kit and part stickers from a BOM
- Open https://app.mylabelmaker.com. No signup.
- Make two sheets if you can. Totes: kit, name. Parts: kit, part, name, qty.
- First design: barcode {{kit}}, text {{name}}. Upload the tote sheet and print tote labels.
- Second pass: barcode {{part}}, text {{qty}}. Upload the parts sheet and print into the tote.
Sample spreadsheet
Parts for kit K-12. Print one sticker per row. Duplicate a row if you need that many physical stickers.
| kit | part | name | qty |
|---|---|---|---|
| K-12 | HX-M4-12 | M4x12 hex | 8 |
| K-12 | BRG-608 | 608 bearing | 2 |
| K-12 | SHM-0.5 | 0.5mm shim | 4 |
First row is the header. Those header words go inside the curly braces on the label, like {{kit}}.
Quantity copies: labels by quantity. Generic kits: kitting labels.
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.