Query fulfillment order line items.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the FulfillmentOrderId and OrderId columns. The supported SQL operators are '=' for FulfillmentOrderId and OrderId. The connector processes other filters client-side within the connector.

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

SELECT * FROM FulfillmentOrderLineItems WHERE OrderId = '123'

SELECT * FROM FulfillmentOrderLineItems WHERE FulfillmentOrderId='6817622622467'

Columns

Name	Type	References	Description
Id [KEY]	Long		The ID of the fulfillment order line item.
ShopId	Long	Shop.Id	The ID of the shop associated with the fulfillment order line item.
FulfillmentOrderId	Long	FulfillmentOrders.Id	The ID of the fulfillment order associated with this line item.
OrderId	Long	Orders.Id	The ID of the order that's associated with the fulfillment order.
LineItemId	Long	OrdersItems.ItemId	The ID of the line item associated with this fulfillment order line item.
InventoryItemId	Long	InventoryItems.Id	The ID of the inventory item associated with this fulfillment order line item.
Quantity	Int		The total number of units to be fulfilled.
FulfillableQuantity	Int		The number of units remaining to be fulfilled.
VariantId	Long	ProductVariants.Id	The ID of the variant associated with this fulfillment order line item.