Hey there,
With the REST API, there are multiple endpoints involved here:
- Tax1 name
- Tax1 value
- Tax2 name
- Tax2 value
- Tax3 name
- Tax3 value
- Tax4 name
- Tax4 value
- Tax5 name
- Tax5 value
Order API: tax_lines
- Receipt number
I’m wondering about this myself, this might even be deprecated as it’s not mentioned on their docs: https://help.shopify.com/en/manual/orders/export-orders#order-export-csv-structure
- Duties
Order API: original_total_duties_set
- Billing province name
Order API: billing_address.province
- Payment ID
Order Transaction API: payment_id
- Next payment due date
Order API: payment_terms.payment_schedules.due_at
- Payment references
Order Transaction API: payment_id
- Risk level
Order Risk API: recommendation
- Employee
Order API: can’t get actual staff name, but you can get the record ID via the user_id field.
- Location
Not sure about this one, there’s a location_id field though in the Order API.
- Device ID
Order API: device_id
- Refunded amount
Order API: refunds (you’ll need to parse the list of refund transactions and add up the amounts)
- Payment reference
Order Transaction API: payment_id
- Note attributes
- Notes
- Shipping method
- Discount amount
- Shipping
Order API: note_attributes, note, shipping_lines.title, total_discounts, shipping_lines (add up the price attribute)
- Line item compare-at price
Order API and Product Variant API: Get the variant_id from the line_items.variant_id field of the Order API. Use that ID and make a call to the Product Variant API to get the compare_at_price field.