FulfillmentEvents
Create, delete, and query information regarding fulfillment events.
Table-Specific Information
Select
The OrderId and FulfillmentId are required to query this table. The connector uses the Shopify API to process search criteria that refer to the OrderId, FulfillmentId, and Id columns. The supported SQL operator is '='. The connector processes other filters client-side within the connector.
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. |