Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Add settlementCurrencyRate to Shopify Transaction table

Completed
Claire Eccles User

Add settlementCurrencyRate to Shopify Transaction table

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Shivaprasad Mogili Fivetranner

    Hi Claire,

    The settlementCurrencyRate field is only 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,
    Shiva

  • Sandeep Preetam Saila User

    Hi Claire,

    We just introduced a GraphQL Schema toggle in the Shopify connector setup flow. Enabling this toggle allows you to create a new Shopify connection using our GraphQL schema, which provides access to many newer Shopify fields and tables that are not available in the Legacy schema.

    Since the requested field/table is available only in the GraphQL schema, it will not appear in an existing Legacy schema connection. To sync this data, you'll need to create a new Shopify connection with the GraphQL Schema toggle enabled. Existing connections cannot be switched from the Legacy schema to the GraphQL schema.

    Before creating a new connection, we recommend reviewing the following documentation:

    Since the requested field/table is now supported through the GraphQL schema, we are considering this feature request complete. If you have any questions about setting up a new GraphQL schema connection, please let us know.

    Best
    Sandeep