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