ODBC Driver for Shopify

Build 24.0.9062

FulfillmentOrderLineItems

Query fulfillment order line items.

View-Specific Information

Select

The 本製品 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 本製品 processes other filters client-side within the 本製品.

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.
FinancialSummaries String The financial summary data for the line item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062