FulfillmentEvents
Lists status events (in transit, delivered) associated with fulfillments.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- FulfillmentId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM FulfillmentEvents WHERE FulfillmentId = 'Val1'
Insert
The following columns can be used to create a new record:
FulfillmentId, Status, Address1, City, Country, Latitude, Longitude, Message, Province, Zip, EstimatedDeliveryAt
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The globally unique identifier of the fulfillment event. | |
| FulfillmentId | String | True |
Fulfillments.Id |
The globally unique identifier of the fulfillment associated with this event. |
| OrderId | String | True |
Orders.Id |
The globally unique identifier of the order linked to this fulfillment event. |
| Status | String | True |
The current status of the fulfillment event, such as in transit or delivered. | |
| HappenedAt | Datetime | True |
The exact date and time when the fulfillment event occurred. | |
| Address1 | String | True |
The first line of the street address where the fulfillment event took place. | |
| City | String | True |
The city where the fulfillment event occurred. | |
| Country | String | True |
The country where the fulfillment event occurred. | |
| Latitude | Double | True |
The latitude coordinate of the location where the fulfillment event occurred. | |
| Longitude | Double | True |
The longitude coordinate of the location where the fulfillment event occurred. | |
| Message | String | True |
Any message or note provided with the fulfillment event, often used for delivery updates. | |
| Province | String | True |
The province, state, or region where the fulfillment event occurred. | |
| Zip | String | True |
The postal or ZIP code of the location where the fulfillment event occurred. | |
| EstimatedDeliveryAt | Datetime | True |
The projected delivery date and time for the shipment related to this fulfillment event. | |
| CreatedAt | Datetime | True |
The date and time when the fulfillment event record was created in Shopify. |