Skip to main content

Orders Export

Every order that includes a product customization is collected in one place so you can see exactly what each customer asked for — and export it all to a spreadsheet. This is especially useful for pr...

Every order that includes a product customization is collected in one place so you can see exactly what each customer asked for — and export it all to a spreadsheet. This is especially useful for production and fulfillment, where you need each option value broken out into its own column rather than buried in a line-item note.

The Orders Page

Open Orders from the app navigation. Only orders that contain product option customizations appear here — plain orders without options are left out to keep the list focused.

For each order you’ll see:

  • Order - The Shopify order number, linked to its details

  • Customer - Who placed the order

  • Customizations - How many option values were captured on that order

  • Date - When the order was placed

  • Total - Order value for the customized items

Use the search box to find an order by number or by a customization value.

Exporting to CSV

The Orders page has an Export action in the top bar. It opens a dedicated export page that shows how many orders and line items are included, then a Download CSV button starts the download.

The file downloads directly to your computer, ready to open in Excel, Google Sheets, or Numbers.

What’s in the File

The export uses a one row per ordered item layout, which is what makes it useful for production sheets:

  • Each customized product in each order becomes its own row

  • Standard columns come first: order number, date, customer, shipping address, product, variant, SKU, quantity, and item price

  • Every option becomes its own column - the option name is the column header and the customer’s choice is the value

So if a customer ordered an engraved bracelet, you’ll see the engraving text, font, and any other options each in their own column, right next to the product and shipping details.

Shipping Address Columns

The export includes the shipping address for each order, split into separate columns for easy sorting and mail-merge:

  • Ship name, Address 1, Address 2, City, Province, Zip, Country, Phone

Because address is order-level, every line-item row from the same order repeats that order’s address. Orders placed before address capture was added may have blank address fields; new orders always include it.

Why Not Just Use Shopify’s Export

Shopify’s built-in order export keeps line-item customizations as a single combined properties field, which is hard to read and impossible to sort or filter by a specific option. This export breaks each option out into its own column, so you can filter by font, sort by size, or hand a clean production sheet to your team.

Common Uses

  • Production sheets - Give your workshop a clear list of what to make, with every customization spelled out

  • Fulfillment - Pack and ship with the shipping address and options side by side

  • Backups and analysis - Keep a snapshot of customization data or analyze which options sell

Did this answer your question?