FulfillmentEvents
Records events tied to fulfillments such as shipment creation, in-transit updates, and delivery confirmation.
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 |
A globally unique identifier for the fulfillment event record. | |
| FulfillmentId | String | True |
Fulfillments.Id |
The unique identifier of the fulfillment associated with this event. |
| OrderId | String | True |
Orders.Id |
The unique identifier of the order linked to the fulfillment event. |
| Status | String | True |
The current fulfillment event status, such as in_transit, delivered, or failure. | |
| HappenedAt | Datetime | True |
The timestamp indicating when the fulfillment event actually occurred. | |
| Address1 | String | True |
The primary street address where the fulfillment event took place, such as a shipping or delivery location. | |
| City | String | True |
The city corresponding to the address where the fulfillment event occurred. | |
| Country | String | True |
The country where the fulfillment event took place, represented by its full name or ISO code. | |
| Latitude | Double | True |
The geographic latitude coordinate of the fulfillment event's location. | |
| Longitude | Double | True |
The geographic longitude coordinate of the fulfillment event's location. | |
| Message | String | True |
A text message describing the fulfillment event, such as tracking updates or courier notes. | |
| Province | String | True |
The province, state, or regional subdivision where the fulfillment event occurred. | |
| Zip | String | True |
The postal or ZIP code corresponding to the fulfillment event's location. | |
| EstimatedDeliveryAt | Datetime | True |
The predicted date and time when the fulfillment is expected to reach its destination. | |
| CreatedAt | Datetime | True |
The timestamp representing when the fulfillment event record was created in Shopify. |