Guide
Address labels from a Shopify®, Etsy® or eBay® order export, one per order
An order export lists every item on its own row. Open it in the address labels tool and each order gets one label, with the address the parcel goes to and the order number small at the top.
Updated
Why an order export needs care
An order of three items is three rows in most order exports. Shopify’s help says it plainly: an order with several items shows each extra item on its own line, and “many of the fields are left blank” on those lines (Shopify Help Center: Exporting orders). The shipping address is usually on the order’s first row only.
Printed one label per row, that gives a label for every item instead of every parcel, and labels with no address at all. A mail merge doesn’t know the difference.
The address labels tool does. When you add an order export, it groups the rows by order number and makes one label per order, taking the address from the row that has it. It can print the order number small above the address, so whoever packs can match each parcel to its order.
These are address labels, not postage. EncodeLabel prints the address; it doesn’t buy postage or make a carrier’s tracking barcode.
Download your orders
From Shopify
Find the orders
In your Shopify admin, go to Orders. Sort and filter them first if you like, so the list holds the orders you are packing.
Export
Click Export and choose which orders, such as the current page or Orders by date.
Choose the file
Under Export as, choose the file format, then click Export orders.
Up to 50 orders download straight away; more, or orders by date, are sent to you by email (Shopify Help Center: Exporting orders).
From eBay
In Seller Hub, open Manage orders, set the results to the orders you want, and select Download report at the top right of the table. To download only some orders, tick them and choose More › Download selected (eBay Help: Seller Hub).
From Etsy
In Shop Manager, go to Settings › Options, open the Download Data tab and go to Orders. Choose the CSV Type, the Month and the Year, then Download CSV (Etsy Help: How to Download a Spreadsheet of Your Sold Transactions). Both the orders file (one row per order) and the order items file (one row per item) work.
From anywhere else
Any order list works the same way when it has a column for the order number (“Order number”, “Order ID”…) and columns for the shipping address. The tool matches columns by their meaning, not their exact names.
Open it in the address tool
Start the tool
The button below opens the address labels tool ready for an order export: one label per order, with the order number on each label.
Add your file
In step 1, choose Upload a file and pick the export. 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 it found and what it tidied (see below). Press Use this list to take it in.
Check the labels
Step through the labels with the arrows under the first one. If a part of the address is in the wrong place, open Which column is which under the label and change it.
What the tool does with an order export
When the file is an order export, the pop-up lists what it found and did, in plain words. For a Shopify export, for example:
- “This looks like an order export: 5 orders in 8 rows.”
- “Filled in the order details on 3 item rows, from the first row of their order.”
- “Labels use the address the parcel goes to (the “Shipping” columns), not the billing address.” In an eBay report it is the “Ship to” or “Post to” columns, not the buyer’s own address.
- “1 row of a cancelled order will be left out.” Press Undo beside it to keep it.
- “1 row has too little for an address label.” Usually a gift card or a download, with nothing to post. Press Skip this row.
A list can have up to 60 columns. A wider export keeps only the columns labels can use, and the pop-up says so: a Shopify order export has more than 70 columns, and the ones left out are taxes and payment details.
One label per order
The switch One label per order sits in step 1, just under the notes about your list. It appears when the list has an order-number column and at least one order runs over several rows, and it starts switched on for an order export. The line under it says what is happening, for example “Your list has 10 rows for 6 orders. Each order gets one label, with the address from the order’s row that has one: 6 labels.” Switch it off to get one label per row again.
An order with no address on any of its rows gets no label, and the tool names it with its row: “1 order has no address on any of its rows, so it gets no label: #1004 (row 7).”
The order number on the label
In step 3, Look, the switch Print the order number adds it small, above the address, as “Order #1041”. The guide’s button turns it on; switch it off for plain address labels.
Pick the label paper
Choose the paper in step 2 by the size printed on the pack. These are a few of the sizes the tool knows:
| Label size | Per sheet | Sheet | Compatible with |
|---|---|---|---|
| 1 × 2⅝ in | 30 (3 × 10) | US Letter | Avery® 5160, 8160, 5260, 18160 |
| 1 × 4 in | 20 (2 × 10) | US Letter | Avery® 5161, 5261, 8161 |
| 1⅓ × 4 in | 14 (2 × 7) | US Letter | Avery® 5162, 5262, 8162 |
| 63.5 × 38.1 mm | 21 (3 × 7) | A4 | Avery® L7160, J8160 |
Some exports write the country as a two-letter code such as US, others as its name. If every parcel stays in your own country, switch off Show the country line in step 3.
A thermal label printer works too: choose its roll in step 2, and see the thermal printer guide for the set-up.
Print a test page first
In step 4, open 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.
- A part-used sheet: 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
- A label for every item. Switch on One label per order in step 1. If the switch isn’t there, the list has no order-number column, or every order in it is a single row already.
- A label shows only an order number, or the billing address. Open Which column is which under the first label and choose the shipping columns.
- An order has no label. No row of that order has an address, which is usual for a download or a gift card. The note in step 1 names it.
- A ZIP code lost its first zero. If you opened the export in a spreadsheet and saved it again, ZIP codes such as 02134 may have become 2134. The tool puts the zero back where the state proves it belongs and says how many it fixed.
The file is read in your own browser and nothing is uploaded. It reaches the site only if you log in, press Save and say yes to keeping the list. The Privacy Policy says what is kept.
Try it
Free for up to 100 labels a month. No account needed. Your labels are made in your browser.
Shopify, Etsy, eBay and WooCommerce are trademarks of their owners. EncodeLabel isn’t connected with or endorsed by them.