Mapping API Keys to Order & Customer Fields

Products and Orders APIs
1

Hi,

We are trying to fetch data via apis and while fetching it is unclear about the following columns

  1. order Paid_at
  2. order Fulfilled_at
  3. Customer_created_at
  4. order Created at
  5. Risk
    which keys corrosponds to the above columns
2

Hi @Store_Astroyogi The mapping depends on where those column names are coming from. Are those from a Shopify admin CSV export, a third-party reporting tool, or something else? The naming convention doesn’t match the API field names directly, so knowing the source would help point you to the right fields.

If you’re working from the API itself, the Order and Customer objects both have a createdAt field for those two. “Paid at” and “Fulfilled at” aren’t top-level fields on the Order though. Payment timing comes from the order’s transactions, and fulfillment timing comes from the Fulfillment object’s createdAt. Risk data is available via order.risk in GraphQL.

Share the source of those column names and which API you’re using (REST or GraphQL) and I can look into the exact field paths.