FulfillmentEvents
Create, delete, and query information regarding fulfillment events.
Table-Specific Information
Select
The OrderId and FulfillmentId are required to query this table.
The driver uses the Shopify API to process search criteria that refer to the OrderId, FulfillmentId, and Id columns. The supported SQL operator is '='. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
For example, the following queries are processed server side:
SELECT * FROM FulfillmentEvents WHERE OrderId='123' AND FulfillmentId='456'
SELECT * FROM FulfillmentEvents WHERE OrderId='123' AND FulfillmentId='456' AND Id='789'
Insert
You must specify the OrderId, FulfillmentId, and Status to create a fulfillment event.
INSERT INTO FulfillmentEvents (Orderid,FulfillmentId, Status,Message,EstimatedDeliveryAt) VALUES ('202520330263','206541914135', 'in_transit','test','2018-08-02 10:15:25 PM')
Delete
You must specify the OrderId, FulfillmentId, and Id of the fulfillment event to delete it.
DELETE FROM FulfillmentEvents WHERE Orderid='202520330263' AND FulfillmentId='206541914135' AND Id='2374424264727'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A numeric unique identifier for the fulfillment event. | |
| OrderId [KEY] | Long | False |
Orders.Id |
The id of the order the fulfillment event belongs to. |
| FulfillmentId [KEY] | Long | False |
Fulfillments.Id |
A numeric unique identifier for the fulfillment to which the fulfillment event belongs. |
| ShopId | Long | True |
Shop.Id |
A numeric unique identifier for the shop to which the fulfillment event belongs. |
| Status | String | False |
The status of the fulfillment event. Valid values are: confirmed, in_transit, out_for_delivery, delivered, failure. | |
| EstimatedDeliveryAt | Datetime | False |
The status of the fulfillment event. Valid values are: confirmed, in_transit, out_for_delivery, delivered, failure. | |
| Message | String | False |
An arbitrary message describing the status. Can be provided by a shipping carrier. | |
| City | String | False |
The city in which the fulfillment event occurred. | |
| Province | String | False |
The province in which the fulfillment event occurred. | |
| Zip | String | False |
The zip code in the location in which the fulfillment event occurred. | |
| Country | String | False |
The country in which the fulfillment event occurred. | |
| Address1 | String | False |
The fulfillment event's street address. | |
| Latitude | Double | False |
Geographic coordinate specifying the north/south location of a fulfillment event. | |
| Longitude | Double | False |
Geographic coordinate specifying the east/west location of a fulfillment event. | |
| CreatedAt | Datetime | True |
The date and time when the fulfillment event was created. | |
| UpdatedAt | Datetime | True |
The date and time when the fulfillment event was updated. | |
| HappenedAt | Datetime | True |
The date and time when the fulfillment event occurred. |