Fulfillments

Create, update, and query fulfillments.

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Id, OrderId, CreatedAt, and UpdatedAt columns. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side.

If you specify the unique identifier of the order, then this view will only list fulfillment information concerning that order. You can also retrieve a specific fulfillment by specifying OrderId and Id. To retrieve fulfillments associated with a fulfillment order you need to specify the FulfillmentOrderId.
```
SELECT * FROM Fulfillments WHERE OrderId = '5729988903171'

SELECT * FROM Fulfillments WHERE OrderId = '5729988903171' AND Id = '5165361791235'

SELECT * FROM Fulfillments WHERE FulfillmentOrderId = '6817622622467'
```
This view supports filtering by the CreatedAt and UpdatedAt columns on the server-side.
```
SELECT * FROM Fulfillments WHERE CreatedAt > '2017-10-25'
```

Insert

You must specify the FulfillmentOrderId column to insert a fulfillment.

Fulfill all line items.

INSERT INTO Fulfillments (FulfillmentOrderId) VALUES ('6817622622467')

Fulfill one line item using aggregates.

You must specify the fulfillment order line item id and the quantity to be fulfilled in the aggregate.

Note: To obtain the fulfillment order line item id, you can query the Id column in the FulfillmentOrderLineItems table.
```
INSERT INTO Fulfillments (FulfillmentOrderId, LineAggregate) VALUES ('6817622622467','[{\"id\":14179445244163,\"quantity\":5}]')
```
Fulfill one line item using temporary table. The temporary table you are populating is dynamic and will be created at run time the first time you insert to it. Temporary tables are denoted by a # appearing in their name. When using a temporary table to insert, the temporary table must be named in the format [TableName]#TEMP, where TableName is the name of the table you will be inserting to. For instance:
```
INSERT INTO OrdersItems#Temp (ItemId, ItemQuantity) Values ('14179445244163', '5')
```
Once your temporary table is populated, it is now time to insert to the actual table in Shopify. You can do this by performing an INSERT to the actual table and setting as a value for LineAggregate the name of the temporary table. For instance:
```
Insert INTO Fulfillments (FulfillmentOrderId, LineAggregate) VALUES ('6817622622467', 'OrdersItems#TEMP')
```
In cases that two ore more shop locations are specified in your Shopify account the LocationId needs to be added. For instance:
```
Insert INTO Fulfillments (FulfillmentOrderId, LocationId, LineAggregate) VALUES ('6817622622467', '1448280087', 'OrdersItems#TEMP')
```

Fulfill many line items using aggregates.

INSERT INTO Fulfillments (FulfillmentOrderId, LineAggregate) VALUES ('6817622622467', '[{\"id\":14179445244163,\"quantity\":5},{\"id\":14179445276931,\"quantity\":2}]')

Fulfill many line items using temporary table.

INSERT INTO OrdersItems#Temp (ItemId, ItemQuantity) Values ('14179445244163', '5')
INSERT INTO OrdersItems#Temp (ItemId, ItemQuantity) Values ('14179445276931', '2')
INSERT INTO Fulfillments (FulfillmentOrderId, LineAggregate) VALUES ('6817622622467', 'OrdersItems#TEMP')

Fulfill all line items, notify the customer, and set a tracking number.

INSERT INTO Fulfillments (FulfillmentOrderId, TrackingNumbers, NotifyCustomer) VALUES ('6817622622467', 'FEDEX1', true)

Complete a fulfillment (you must specify the Id of the fulfillment as well).

INSERT INTO Fulfillments (FulfillmentOrderId, Id, Status) VALUES ('6817622622467', '5165361791235', 'Complete')

Transition a fulfillment from pending to open (you must specify the Id of the fulfillment as well).

INSERT INTO Fulfillments (FulfillmentOrderId, Id, Status) VALUES ('6817622622467', '5165361791235', 'Open')

Cancel a fulfillment (you must specify Id of the fulfillment as well).

INSERT INTO Fulfillments (FulfillmentOrderId, Id, Status) VALUES ('6817622622467', '5165361791235', 'Cancel')

Update

You must specify the OrderId and Id of the fulfillment to fulfill an order.

UPDATE Fulfillments SET TrackingNumbers = 'FedEx123,UPS123' WHERE OrderId = '5729988903171' AND Id = '5165361791235'

Columns