Help CenterContact support
All Columna: Order Export & Sheets articles

How do I export orders with line item properties?

Updated

On this page
  1. Before you start
  2. Steps
  3. Verify it worked
  4. Print instead of download
  5. Troubleshooting

Export orders to a CSV or Excel file with custom options, such as engraving text or gift messages, each in its own column.

Before you start

The columns of your file come from a template. To get line item properties as columns, use a template with One row per line item and columns from the Line item properties group, or start from the Personalized items preset. See “How do I create, edit, duplicate or delete export templates?”.

Steps

  1. In the app, open Orders.
  2. Narrow the list if you need to: the view menu (All, Unfulfilled, Unpaid, Paid), the search box, the date filter, Status and More filters. See “How do I filter orders before I export them?”.
  3. Optionally tick the orders you want. If you tick none, the app exports every order that matches your filters.
  4. Click Export. The Export orders window opens.
  5. If you ticked orders, choose under Orders to export either your selected orders or All orders that match your filters.
  6. Pick a Template. Your own templates are under My templates, the built-in ones under Presets.
  7. Check Rows under the template. It shows how the template writes rows:
    • One row per order: each order becomes one row. Line item data is not repeated.
    • One row per line item: each product in an order becomes its own row, with the order columns repeated. Use this to split line item properties into columns.
  8. Choose the File format: CSV or Excel (XLSX).
  9. Click Export.

The app remembers the template and file format you used for the next export.

Verify it worked

  • While the export runs, you see “Exporting orders” with the steps “Counting orders…”, “Fetching orders…” and “Building your file…”. Click Cancel to stop it.
  • When it finishes, the download starts and you see a message such as “Exported 3 rows”. If the download does not start, click Download again in that message.
  • The export appears on the History page.

In the Export orders window, click Print sheet to print the rows of the template instead of downloading a file. With the Production list preset the button is called Print.

Troubleshooting

You see “The start date must be before the end date.” Fix the date range in the date filter on the Orders page.

You see “Orders older than 60 days are not accessible yet. This app needs Shopify’s read_all_orders permission to export them. Choose a date range within the last 60 days.” Choose a date range within the last 60 days.

You see “This app does not have permission to read this data from your store.” Reopen the app from your Shopify admin and approve its updated access, then try again.

You see “Your Shopify session expired. Reload the app from your Shopify admin.” Reload the app from your Shopify admin.

You see “Export failed”. Click Try again. If it keeps failing, use Open support chat in the app.

You see “250 selected (max)”. You ticked the most orders one export allows (250). To export more, choose All orders that match your filters in the Export orders window.

The Export button in the window is greyed out. No order matches your filters. Change the filters on the Orders page.

Built and supported by StoreFleet, Shopify app developers since 2021.