Export Shopify Orders to CSV with Product Options

When you export Shopify orders with the standard order CSV, line-item properties such as engraving text, gift messages and upload links are left out of the file. Columna: Order Export & Sheets exports your orders to CSV or XLSX with those properties as their own columns, and the file is processed in your browser.

If you sell products with custom options, such as engraving text, a chosen font, a gift message or a photo upload, that gap means someone opens orders one by one and copies each value into a spreadsheet. This guide shows how to get the options from many orders into one table, one column per option, and how to check the columns before the file goes to your workshop.

How do I export Shopify orders with line-item properties?

1. Open Columna: Order Export & Sheets from your Shopify admin.
2. Choose the orders you want in this file.
3. Pick the columns, including a Property: <key> column for each option your team needs.
4. Export the file as CSV or XLSX.

The steps further down go through each part in more detail, including how to keep option names consistent and how to check the columns before a large export.

Who needs this

• Shops that hand orders to production, such as an engraving, printing or embroidery workshop.
• Shops that hand orders to a fulfilment partner who needs each option next to its item.
• Shops that hand orders to accounting, where a bookkeeper works from a spreadsheet.

You can get Columna: Order Export & Sheets on the Shopify App Store.

Why the standard export leaves options out

Product options apps and theme forms usually save what the customer picked as line item properties on the order, such as “Engraving: For Anna” or “Font: Script”. In a theme these come from form inputs named properties[Engraving], properties[Font] and so on, as Shopify’s theme docs describe. You see them under the product title on the order page.

The standard order CSV export has line item columns such as Lineitem name, Lineitem quantity and Lineitem SKU, plus Notes and Note Attributes for the whole order. It has no column for line item properties. That is a problem when the file goes to a workshop, a fulfilment partner or a bookkeeper who needs each option next to the item it belongs to.

Before you change anything, open one recent order and look at the line item. If the customer’s choices appear under the product title, they are line item properties, and the steps below apply. If a choice such as a gift message appears for the whole order instead, it is the order note or a note attribute, which the standard CSV already includes.

Step 1: Use one name per option

Each distinct property name becomes its own column, so Engraving, Engraving text and engraving text end up as three columns. Pick one name per field and use it on every product that offers that option. If a product options app creates the fields, check the name it saves on the order, not only the label customers see.

Renaming an option mid-season has the same effect: old orders carry the old name, new orders the new one, and your file gets two columns for one field.

Step 2: Choose the orders for this batch

Export only the orders you are about to make or ship, for example paid, unfulfilled orders from the last few days, or orders with a production tag. Filtering keeps already-handled orders out of the file, so nothing gets made twice.

Step 3: Add one column per option

In Columna: Order Export & Sheets, you do not type in a list of option names. The app looks through your last 250 orders for property keys and offers a column for each one, named Property: <key>. An option called “Engraving” becomes Property: Engraving. Tick the ones your team needs and leave out the rest. If you prefer, one Properties column keeps every pair together instead.

Properties whose names start with an underscore, such as _preview_id, are hidden from customers at checkout, as the Liquid line_item reference notes. Options apps use them for their own data, and most production sheets do not need them.

A short file that production can read at a glance is more useful than every field you have. Keep customer emails and prices out of a file that goes to an outside printer.

Step 4: Check the columns before you export many orders

Run the export on a handful of recent orders first and look at the result across several products, not just one:

• A column is empty on every row. The option name may differ from what you expected, or the products in this batch do not use it.
• Two similar columns exist, for example Property: Engraving and Property: Engraving text. The option was renamed at some point; fix the name on the product form (step 1).
• An upload option shows a link. That is normal; the link is what the customer’s upload produced. Open it and save the artwork in your job folder, named by order number.
• Each text sits with its own item. On orders with several personalised items, check that each item carries its own engraving text.

Step 5: Export, and save the columns as a template

When the columns look right, export the whole batch as CSV or XLSX, or send it to a Google Sheets spreadsheet you connect. The file is put together in your browser and saved to your computer.

Keep the columns you picked as a template, so the next batch uses the same layout without setting it up again.

Common mistakes to avoid

• Judging the file from one order. Different products carry different options, so check rows from several products.
• Exporting everything. Filter to the orders production needs now.
• Everything lands in one column in Excel. Many European Excel setups expect a semicolon instead of a comma. An XLSX file avoids this.
• Accents and emoji look broken. The CSV was opened with the wrong encoding. Import it through Excel’s data import, or use XLSX.

For the general steps of getting a file from Shopify to Excel, see our guide on Shopify to Excel order exports. If you ship abroad, the same steps apply when you export Shopify international orders.

FAQ

Can I export custom product options from Shopify without an app?

Not from the standard order CSV, which has no line item property columns. You can read the options on each order page and copy them by hand, or use an app or custom report that reads them from your orders.

Why is my gift message in the standard export but not my engraving text?

Your gift message is probably saved as the order note or a note attribute, which the standard order CSV includes. Your engraving text is saved on the item as a line item property, which it does not include.

For more on the file layout, see exporting orders with line item properties to CSV or XLSX.

Try Columna: Order Export & Sheets

Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX with line-item properties (engraving text, gift messages and upload links), each in its own column named Property: <key>. The file is processed in your browser. It is made for shops that hand orders to production, fulfilment or accounting.

Ready to stop opening orders one by one? Try Columna: Order Export & Sheets on the Shopify App Store and export your next batch of personalised orders.