Hi Bryan,

We have three fulfillment tables in our ERD: fulfillment_event, fulfillment, and fulfillment_order_line. It sounds like you're saying the fullfillments in the fulfillment table are all pending and don't get updated with information about the fullfillments that have been completed. Is that right? Is the information in fulfillment_event useful for this?

>  Is the information in fulfillment_event useful for this?

Hi Ray,

No. The information in `fulfillment_event` is distinct data from the data I want `fulfillment_order`. Perhaps the issue is confounded because the data entities are named similarly.

A "Fulfillment" represents a record when a vender "fulfills" a customer order -- they begin the process to fabricate a product and send it to the customer.

A "Fulfillment Event" is associated with exactly one "Fulfillment" and represents some timed event like "item shipped" or "item delivered". A "Fulfillment Event" must be created before a "Fulfillment Event" occurs.

A "Fulfillment Order" represents a record in which a merchant sends a request to a vendor to fulfill an order. The fulfillment does not exist yet so the events that have not happened yet are not interesting to me.

I hope this helps,

-bryan.

Hi Ray, any news about the FulfillmentOrder table?
It contains some useful information that is not shown in any of the other fulfillment tables.

Ray tossing my upvote into the mix on this one. Shopify has announced that the fulfillment object will be deprecated (timing tbd), so Fivetran will need a migration soon. 

The fulfillment object is being replaced by FulfillmentOrder

Please let us know if this is on your roadmap, because I'm already seeing some inconsistencies in the reporting from the old fulfillment object as shopify preps for deprecation. 

Hello team,

Regarding fulfillment_order table, will it have line item level information, which includes the fulfillment services for each line item? (just like the fulfillment service in the current order_line and fulfillment_order_line table)

Thanks!

Hi Mingyang and everyone - Calvin from the Product team here!

We are looking to add support for the Fulfillment Order resource in the current quarter. This will include data made available via this GraphQL API endpoint and will include item and order level information.

Hi Calvin,

Thank you for your response!

I have a few follow up questions:

1. What item level information will look like in fulfillment_order table? Will it contain fulfillment service per order line item just like the fulfillment_service field of order_line table which will be deprecated very soon?

2. Also it sounds like we need to use at least API v2022-10 for Shopify connectors in order to properly use fulfillment_order table. How do we know if our current Shopify connectors fulfill all requirements? I believe our Shopify connectors are connected through installing the Fivetran app from the Shopify app store. 

Thank you!