Print Shopify inventory barcodes from Excel

Yes. You can print Shopify inventory barcodes from Excel. Export the catalog, barcode SKU or the Barcode column, add the title, then print. No Shopify app.

← 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}}, then 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 https://app.mylabelmaker.com. No signup. 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

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.

Print this Shopify catalog

Export once. Stickers on the shelf.

Open free label maker