How to Export Shopify Orders With Line Item Properties
Shopify's order export leaves out line item properties, such as engraving text and custom options. Here are the ways to get them into a CSV or spreadsheet.
Line item properties are the extra details a customer enters for one item on an order: the text for an engraving, a gift message, a chosen colour that isn’t a variant, an uploaded file. Product customiser apps add them, and so do custom fields in many themes.
They show on the order page in the Shopify admin. Getting them into a spreadsheet is harder.
What Shopify’s order export includes
Shopify’s order export, from the Orders page, gives you a CSV with one row per line item. It includes the order’s totals, its customer and shipping details, and each line item’s name, SKU, quantity and price.
Two things catch merchants out:
- Line item properties aren’t in the export. The fields a customer filled in for an item are missing.
- Order details are only on the first row. For an order with three items, the order’s fields, like its total and tags, appear on the first line item’s row and are blank on the other two, so sorting or filtering the file breaks the link between items and their order.
Ways to get line item properties out
Copy them from the order page
For a handful of orders, open each one and copy the properties by hand. It works, and it stops working at about ten orders a day.
Use the Admin API
Line item properties are available through Shopify’s Admin API, as custom attributes on each line item. A developer can write a script that pulls orders with their line items and attributes and writes a CSV. It’s flexible, but someone has to build it, run it and fix it when it breaks.
Use a reporting or export app
A reporting app that reads full order data can put line item properties in columns. Check three things before you choose one: whether the order’s fields repeat on every line item row, whether you can filter which orders are exported, and whether it can send the file on a schedule so nobody has to remember.
Exporting orders with Queryful
Queryful’s order reports list orders one row per order or one row per line item, with the order’s fields repeated on every row. Line item properties, notes, tags and UTM parameters are columns like any other.
A report like this one lists last week’s paid orders with their line item properties:
FROM orders
SHOW order_name, created_at, total_price, line_item_properties
WHERE financial_status = 'paid'
DURING last_7_days
Download it as a CSV or Excel file, or email it on a schedule to the person who makes the engravings, packs the gifts or prints the labels.