Print receiving labels from a PO spreadsheet

A dock tagging cartons as they come off the truck.

← Back to Blog

Print receiving labels from a PO spreadsheet

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 product sticker template

A PO export tells you what should land. Design one receiving sticker in the free label maker. Barcode {{sku}}. Add {{po}} and {{qty}}. Upload. 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 stickers from a PO

  1. Headers: po, sku, name, qty.
  2. Open the free label maker. Set 3x2 or 4x3.
  3. {{po}} at the top. CODE128 with {{sku}}. {{name}} and {{qty}} under it.
  4. Upload the Excel file. Print a sticker per line, stick it as you count.

Sample spreadsheet

Tomorrow morning’s PO 8841, trimmed to what the dock needs.

poskunameqty
8841FLT-20Cabin filter24
8841BLT-7Drive belt12
8841GLV-MNitrile M10

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

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.

Print this morning’s receiving stack

The PO list. Stickers on the cartons.

Open free label maker