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

Community

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

Not planned
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

2 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