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

Community

Connector Improvement: Add fulfillsOnlineOrders boolean field to Shopify's LOCATION table

Completed
Arash Tavassoli User

The `fulfillsOnlineOrders` field is missing from the `LOCATION` table that the Shopify's admin GraphQL API can provide - see this page and look for `Location.fulfillsOnlineOrders` field. This boolean field shows if the listed location is allowed to fulfill online orders and plays a big role in our inventory calculations (e.g. to sum up the total inventories for each SKU which can be sold on the website).

In absence of this data we will need to spin up our own custom service to pull that boolean for each location and persist that on the warehouse.

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Ray User

    Hi Arash,

    Thanks for the request. For a little context, the Fivetran Shopify connector is primarily based on the REST APIs and supplemented where possible with the GraphQL API. For this table in particular, we've noticed some missing fields in the GraphQL implementation that challenge our ability to migrate seamlessly to the new interface. We will look further into this and continue to gather feedback on this thread, but no changes for the immediate future.

    Best,

    Ray Harris

  • Jack Stenson User

    Hi,

    Is the GraphQL location table in a position to migrate over to yet? We could also really do with the above field.

    Thanks

    Jack

  • Sandeep Preetam Saila User

    Hi Everyone,

    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