Print Shopify inventory barcodes from Excel

Export the catalog. Sticker every SKU on the shelf.

← Back to Blog

Print Shopify inventory barcodes from Excel

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

Shopify can export products to CSV. You do not need an app. Open the free label maker, barcode {{sku}} or the barcode column Shopify already filled, add {{title}}, upload, print.

Good to know: We do not connect to Shopify. Export the CSV, then upload it. Postage and Fulfillment stay in Shopify.

How to print barcodes from a Shopify export

  1. In Shopify: Products, Export, CSV. Keep SKU, Title, and Barcode if you use one.
  2. Open the free label maker. Set 2x1.
  3. CODE128 with {{sku}} (or {{barcode}} if that column is the retail code). {{title}} under it.
  4. Upload the CSV or Excel file. Preview two variants. Print.

Sample spreadsheet

A trimmed Shopify export. Rename headers to sku and title if yours say Handle and Variant SKU.

skutitlebarcode
SOAP-12Lavender soap / 4oz
SOAP-12BLavender soap / 8oz
CAND-04Pine candle012345678905

First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.

Full catalog stickers: Shopify products CSV. UPC you own: how to make UPC labels.

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 Shopify catalog

Export once. Stickers on the shelf.

Open free label maker