Get a CSV of orders to ship

In Shopify Admin: Orders → filter to unfulfilled or today's orders → Export → Orders by date range → CSV for Excel/Numbers.

Useful columns (rename headers to simple names for tokens):

• order_number — from Name (e.g. #1042)
• name — Shipping Name
• address1, address2, city, province, zip, country
• tracking — if you have tracking from your carrier tool
• weight, items — optional line for packing slips on same label area

If you use ShipStation or Pirate Ship for purchased labels, export their CSV instead — same variable workflow applies.

Start from the built-in template

Open app.mylabelmaker.com. Left rail → Templates → Shipping category → choose Shopify shipping (4×6 layout with ship-to block, order ref, and tracking barcode area).

Customize branding: add your store logo (Add Image), adjust fonts, or add a return address block. The template is a normal editable design — not locked.

Insert tokens that match your spreadsheet headers

Double-click text fields and replace static text with placeholders like {{name}}, {{address1}}, {{city}} {{province}} {{zip}}. For tracking barcodes, set the barcode value to {{tracking}} (CODE128 works for most carrier tracking numbers).

Column names are case-insensitive and trimmed — {{Name}} matches a header name.

Paste CSV or use Google Sheets

Click the {{ }} Variables button (or Options → Variables). Paste your Shopify CSV, upload the file, or paste a published Google Sheets CSV URL.

Use the row navigator (first / prev / 3 of 47 / next / last) to spot-check addresses and barcodes before printing. Edit a cell inline if one zip code is wrong.

Full walkthrough: print labels from Google Sheets.

Batch print to Zebra

Select your printer in the toolbar. Print now shows row count (e.g. "Print 47 rows"). Each order prints one label with substituted data.

For automated shipping pipelines: Options → Copy ZPL per row or integrate exported ZPL into your backend. See ZPL export for ERP.