Which keyword or field from the orders.json API response should I use to locate a specific column?

Shopify Discussion

Topic summary

Request to map Shopify Orders API (orders.json) fields to columns found in a Shopify order CSV export. The poster has both datasets but cannot identify which API keys correspond to several CSV headers.

Key CSV fields needing API equivalents:

  • Taxes: Tax1–Tax5 name and value.
  • Payment/identifiers: Receipt number, Payment ID, Payment references, Next payment due date.
  • Charges/amounts: Duties, Refunded amount, Discount amount, Shipping.
  • Address/location: Billing province name, Location.
  • Risk/operations: Risk level, Employee, Device ID.
  • Metadata/content: Note attributes, Notes.
  • Line items/shipping: Line item compare-at price, Shipping method.

Outcome/status:

  • No mappings or solutions provided in the thread yet.
  • The question remains open, seeking guidance on where these CSV columns live in the orders.json response.
Summarized with AI on January 21. AI used: gpt-5.
1

I have exported order data to a CSV file from my Shopify store. Now, I have also extracted order data using the Shopify API. However, I am having trouble identifying the corresponding data or keywords in the API response for the following columns present in the exported CSV file from the Shopify store:

  • Tax1 name
  • Tax1 value
  • Tax2 name
  • Tax2 value
  • Tax3 name
  • Tax3 value
  • Tax4 name
  • Tax4 value
  • Tax5 name
  • Tax5 value
  • Receipt number
  • Duties
  • Billing province name
  • Payment ID
  • Next payment due date
  • Payment references
  • Risk level
  • Employee
  • Location
  • Device ID
  • Refunded amount
  • Payment reference
  • Note attributes
  • Notes
  • Line item compare-at price
  • Shipping method
  • Discount amount
  • Shipping"