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

Open address labels for orders

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

  1. 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.

  2. Export

    Click Export and choose which orders, such as the current page or Orders by date.

  3. 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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

Open address labels for orders

The top of a sheet of 1 by 2⅝ inch labels: six addresses, each with a small order number such as Order #1041 at the top right
A made-up export of 6 orders in 10 rows: 6 labels, each with its order number. Drawn by the tool itself.

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 sizePer sheetSheetCompatible with
1 × 2⅝ in30 (3 × 10)US LetterAvery® 5160, 8160, 5260, 18160
1 × 4 in20 (2 × 10)US LetterAvery® 5161, 5261, 8161
1⅓ × 4 in14 (2 × 7)US LetterAvery® 5162, 5262, 8162
63.5 × 38.1 mm21 (3 × 7)A4Avery® 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.

Open address labels for orders Printing help

Shopify, Etsy, eBay and WooCommerce are trademarks of their owners. EncodeLabel isn’t connected with or endorsed by them.

Feedback

Suggestions and feedback

What would make EncodeLabel better, or what isn’t working? It goes straight to the people who run the site.

Only if you’d like a reply.

We use your email only to reply to you. Please don’t include passwords or private details. Privacy Policy

Add EncodeLabel to your Home Screen

One tap to your labels, like an app, with nothing to download from an app store.