Guide
Product barcode labels from a Shopify®, WooCommerce® or Etsy® export
Download your products as a spreadsheet, open it in the label designer, and every variant gets a label with its name, price and barcode. The file is read in your browser and never uploaded.
Updated
Why a product export needs tidying
Your shop already knows every product: its name, its options, its price and its barcode. A product export puts all of that in one spreadsheet, so you don’t have to type it again for the labels.
A product export isn’t laid out for labels, though. A T-shirt in three sizes is three rows, and only the first one has the product’s name. A barcode cell can hold several codes with words like “gtin:” in front. Some rows only add a picture. Print it as it is and you get labels with no name, or a barcode that won’t scan.
The label designer notices a product export when you add it and tidies it first. Then the Price label layout fills itself in: the variant’s name, the price and the barcode, one label per variant.
EncodeLabel doesn’t connect to your shop. You download the file from your shop and open it here, and it is read in your own browser. Nothing is uploaded.
Download your products
From Shopify
Open Products
In your Shopify admin, go to Products and click Export.
Choose the products
The current page, all products, the products you selected, or the ones that match your search and filters.
Choose the file
The CSV file for Excel, Numbers or another spreadsheet program, or the plain CSV file. Either one opens here.
Export
Click Export products. The current page or the products you selected download straight away, unless a product has more than 100 variants; the other choices are sent to you by email.
Shopify’s own steps: Shopify Help Center: Exporting products.
From WooCommerce
Open the products
Go to Products › All Products and click Export at the top of the page.
Choose what goes in
Keep Export all columns, all product types and all categories, or narrow them down.
Generate the file
Click Generate CSV. When it’s ready, your browser downloads it.
WooCommerce’s own steps: WooCommerce: Product CSV importer and exporter.
From Etsy
In Shop Manager, go to Settings › Options, open the Download Data tab and choose Download CSV under Currently for Sale Listings (Etsy Help: How to Download a Spreadsheet of Your Sold Transactions). Etsy lists what the file holds: title, description, price, currency, quantity, tags, materials, picture addresses and your SKUs if you’ve added any. A barcode isn’t on that list (Etsy Help: How to Download Your Listing Information), so use your SKU as a Code 128 barcode instead (see Barcode type below).
Open the file straight from your downloads. Opening it in Excel and saving it again can turn long barcodes into numbers like 1.23E+11 and drop their first zero.
Open it in the designer
Start the layout
The button below opens the designer with the Price label layout on 1 × 2⅝ inch labels, 30 to a sheet. A label you were working on stays one Undo away.
Add your file
Click Add a datalist and choose the file you downloaded. A CSV, an Excel file or a tab-separated text file can be read, up to 15 MB and 20,000 rows.
Read the notes
The Check your list pop-up says what was tidied (see below) and which rows have a problem, then Use this list takes it in.
Check the labels
The layout now takes its words from your list: the name, the price and the barcode of the first variant. Step through the others with the arrows under the label, or use Check every row.
What the tidy step does
When the file is a product export, the pop-up lists each thing it put right, in plain words. For a Shopify export, for example:
- “Left out 3 rows that only add a picture.” Shopify adds a row for each extra product photo.
- “Filled in the product name on 5 variant rows, where the export leaves it blank.”
- “Added a “Variant name” column” with the name and options together, such as “Example Cotton T-Shirt – Small / Blue”, and a column for each option (Size, Color…). The label uses the variant name.
- “3 barcode cells held more than one code.” One is kept for the label, a GTIN, UPC or EAN when there is one, and the others go in an “Other barcodes” column.
- “Took “gtin:”, “upc:” and “ean:” off the front of 7 barcodes.” The digits themselves are never changed.
A WooCommerce export gets the same care: parent products that only group their variations are left out, each variation is named from its options when its name is blank, and a variation that shares its parent’s stock gets the parent’s number.
A list can have up to 60 columns. A wider export keeps only the columns labels can use, and the pop-up says so. Any other list is left exactly as it is.
Barcode type: UPC-A, EAN-13 or Code 128
The Price label layout starts with a UPC-A barcode, the 12-digit kind used in the United States and Canada. When most numbers in your file are 12 digits long, the pop-up checks them as UPC-A before you print: it takes off extra zeros in front of a longer GTIN (“An extra zero in front removed from 1 number”) and lists the rows that can’t be a UPC-A.
- 13-digit codes (EAN-13, used in most other countries): click the barcode on the label and change its Type to EAN-13. EAN-13 also takes a 12-digit UPC, drawn with a 0 in front.
- SKUs with letters, as in an Etsy file: change the Type to Code 128.
- A row with no barcode prints without one, and the pop-up offers to skip it.
Which type your shop or marketplace wants is up to them; UPC-A or EAN-13? explains the difference. EncodeLabel doesn’t issue barcode numbers: it draws the numbers that are in your file.
Prices, quantities and paper
A currency sign
An export holds prices as plain numbers, such as 14.00. To print $14.00, click the price on the label and type $ in front of {{Price}} in its text. For a sale price from WooCommerce, change {{Regular price}} to {{Sale price}} the same way.
One label per item in stock
By default each variant gets one label. In the print step, under How many, choose Use a quantity column and pick the stock column (“Inventory quantity” in a Shopify export, “Stock” in WooCommerce) to print one label for every item in stock. An empty cell counts as 1, and a 0 leaves the row out.
Label paper
Price labels need room for a barcode beside the price: 1 × 2⅝ inch labels (30 per sheet, compatible with Avery® 5160) or 63.5 × 38.1 mm on A4 (21 per sheet, compatible with Avery® L7160) suit them. On a label printer, choose a roll such as 2¼ × 1¼ inches in the paper step: the thermal printer guide explains the set-up. Layouts in the designer has other ready-made labels, and you can move, resize or delete anything on the label.
Print a test page first
Before the first real sheet, open Print, then Line it up, and choose Print a test page. Print it on plain paper and hold it against a sheet of labels, up to a window. It never counts toward your labels.
- Every box is off by the same amount: use the arrows under Line it up to move everything the other way.
- The boxes are too small, or drift toward the edges: set Scale to 100% (or “Actual size”) in the print window.
- Then print one sheet and scan a few barcodes, checking that each scan gives the number in your file.
If a sheet is part used, open Start at and tap the first free label: only the first sheet starts there. The printing help has the print settings for each browser.
Common problems
- The label still shows “Ceramic mug” and $14.50. Those are the layout’s examples: add your file with Add a datalist.
- Some labels have no name. The file may not be one the tool recognizes (an older or translated export). Click the name on the label and put another column’s heading between the braces in its text, such as
{{Title}}, or fill the names in your spreadsheet. - “2 barcodes could not be made”. Those numbers don’t suit the barcode type; see Barcode type.
- Several SKUs in one cell (Etsy). A listing with variations keeps all its SKUs in one cell, and the pop-up says it left them as they are. Give each variation its own row in a spreadsheet if each needs a label.
- Long names. They are made smaller to fit. Shorter names or a bigger label read better on a shelf.
Try it
Free for up to 100 labels a month. No account needed. Your labels are made in your browser.
Shopify, WooCommerce and Etsy are trademarks of their owners. EncodeLabel isn’t connected with or endorsed by them.