Hi XYON Team,

The sale_id field is available via Shopify’s GraphQL API. We have a GraphQL-only version of the Shopify connector that supports this field. We can provide you access to this connector; however, it introduces other schema changes compared to the REST API connector (legacy).

Please review both schemas in our documentation to ensure compatibility with your requirements: Shopify connector schemas. The GraphQL schema is listed first under "This schema applies to all Fivetran accounts created on or after August 1, 2025."

Let us know if you would like to enable the GraphQL version for your account and we can assist further.

Thanks,
Sandeep