Print receiving labels from a PO 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 PO export tells you what should land. Design one receiving sticker in the free label maker, barcode {{sku}}, add {{po}} and {{qty}}, then print before the truck backs in.
Good to know: This tags the inbound carton. It is not an ASN, a packing slip, or carrier postage.
How to print receiving labels from a PO spreadsheet
- Headers: po, sku, name, qty.
- Open https://app.mylabelmaker.com. No signup. Set 3x2 or 4x3.
- {{po}} at the top. CODE128 with {{sku}}. {{name}} and {{qty}} under it.
- Upload the Excel file. Print two cartons. Check the scan. Then the stack.
Sample spreadsheet
Tomorrow morning’s PO 8841, trimmed to what the dock needs.
| po | sku | name | qty |
|---|---|---|---|
| 8841 | FLT-20 | Cabin filter | 24 |
| 8841 | BLT-7 | Drive belt | 12 |
| 8841 | GLV-M | Nitrile M | 10 |
First row is the header. Those header words go inside the curly braces on the label, like {{po}}.
After it is put away: location barcodes.
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.