Order CSV export
GET /api/admin/orders.csv streams orders as CSV, one row per order line, so the
file pivots: order-level fields repeat across an order’s rows. ?status=, ?from=
and ?to= (epoch milliseconds) narrow it, and there is a hard cap of 50,000 rows,
which is what the date range is for. The button is on the Orders screen.
Money columns
Section titled “Money columns”Every money column is named *_cents and holds an integer, because a column of
dollars in a spreadsheet is how floating-point money gets back in. Divide by 100 in
the spreadsheet if you must, in a column you add.
Spreadsheet safety
Section titled “Spreadsheet safety”Fields whose first character is =, +, - or @ are prefixed with an
apostrophe. A product named =HYPERLINK(...) is a live formula the moment the file
opens in Excel, and product names are merchant- and buyer-supplied. The file starts
with a UTF-8 BOM so Excel reads accented names correctly.
Columns
Section titled “Columns”Order id and reference, status, email, currency, the five money totals, refunded, the shipping address fields, carrier, tracking, oversold, created at, and per line the product and variant ids, names as bought, SKU, unit price, quantity, and the buyer’s options.