FulfillmentLineItems

Lists order line items included in fulfillments for picking and packing.

View-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.

FulfillmentId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM FulfillmentLineItems WHERE FulfillmentId = 'Val1'

Columns


Name	Type	References	Description
Id [KEY]	String		The globally unique identifier of the fulfillment line item.
FulfillmentId	String	Fulfillments.Id	The globally unique identifier of the fulfillment record this line item belongs to.
DiscountedTotalSetPresentmentMoneyAmount	Decimal		The discounted total for the line item in the presentment currency.
DiscountedTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the discounted total in presentment money.
DiscountedTotalSetShopMoneyAmount	Decimal		The discounted total for the line item in the shop's currency.
DiscountedTotalSetShopMoneyCurrencyCode	String		The currency code for the discounted total in shop money.
OriginalTotalSetPresentmentMoneyAmount	Decimal		The original total for the line item in the presentment currency before discounts.
OriginalTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the original total in presentment money.
OriginalTotalSetShopMoneyAmount	Decimal		The original total for the line item in the shop's currency before discounts.
OriginalTotalSetShopMoneyCurrencyCode	String		The currency code for the original total in shop money.
Quantity	Int		The total quantity of items included in this fulfillment line item.
LineItemId	String		The globally unique identifier of the related order line item.
LineItemName	String		The product name, optionally combined with its variant title.
LineItemTitle	String		The title of the product at the time of order creation.
LineItemVariantTitle	String		The title of the variant at the time of order creation.
LineItemVariantId	String		The globally unique identifier of the product variant.
LineItemProductId	String		The globally unique identifier of the product.
LineItemSellingPlanSellingPlanId	String		The identifier of the selling plan tied to the line item.
LineItemQuantity	Int		The number of product variant units ordered for this line item.
LineItemRestockable	Bool		Indicates whether this line item can be restocked.
LineItemSku	String		The SKU (stock keeping unit) of the product variant.
LineItemTaxable	Bool		Indicates whether this line item is taxable.
LineItemVendor	String		The vendor or brand associated with the product variant.
LineItemCurrentQuantity	Int		The current available quantity of the line item, excluding any removed units.
LineItemMerchantEditable	Bool		Indicates whether the line item can be edited by the merchant.
LineItemRefundableQuantity	Int		The number of units eligible for refund, excluding already removed or refunded units.
LineItemRequiresShipping	Bool		Indicates whether the product variant requires physical shipping.
LineItemUnfulfilledQuantity	Int		The quantity of units from this line item that have not yet been fulfilled.
LineItemNonFulfillableQuantity	Int		The number of units that cannot be fulfilled, such as refunded items or non-fulfillable products like tips.
LineItemIsGiftCard	Bool		Indicates whether this line item represents a gift card purchase.
LineItemDiscountedTotalSetPresentmentMoneyAmount	Decimal		The discounted total for the line item in the presentment currency.
LineItemDiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts	Decimal		The discounted total in presentment currency after applying discount codes.
LineItemDiscountedTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the discounted total in presentment money.
LineItemDiscountedTotalSetShopMoneyAmount	Decimal		The discounted total for the line item in the shop's currency.
LineItemDiscountedTotalSetShopMoneyAmountWithCodeDiscounts	Decimal		The discounted total in shop currency after applying discount codes.
LineItemDiscountedTotalSetShopMoneyCurrencyCode	String		The currency code for the discounted total in shop money.
LineItemDiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		The discounted unit price in the presentment currency.
LineItemDiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		The currency code for the discounted unit price in presentment money.
LineItemDiscountedUnitPriceSetShopMoneyAmount	Decimal		The discounted unit price in the shop's currency.
LineItemDiscountedUnitPriceSetShopMoneyCurrencyCode	String		The currency code for the discounted unit price in shop money.
LineItemImageId	String		The unique identifier of the product image associated with this line item.
LineItemImageWidth	Int		The width of the product image in pixels. Returns null if the image is not hosted by Shopify.
LineItemImageAltText	String		Alternative text describing the content or purpose of the product image.
LineItemImageHeight	Int		The height of the product image in pixels. Returns null if the image is not hosted by Shopify.
LineItemImageUrl	String		The URL of the product image.
LineItemOriginalTotalSetPresentmentMoneyAmount	Decimal		The original total before discounts in the presentment currency.
LineItemOriginalTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the original total in presentment money.
LineItemOriginalTotalSetShopMoneyAmount	Decimal		The original total before discounts in the shop's currency.
LineItemOriginalTotalSetShopMoneyCurrencyCode	String		The currency code for the original total in shop money.
LineItemOriginalUnitPriceSetPresentmentMoneyAmount	Decimal		The original unit price before discounts in the presentment currency.
LineItemOriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		The currency code for the original unit price in presentment money.
LineItemOriginalUnitPriceSetShopMoneyAmount	Decimal		The original unit price before discounts in the shop's currency.
LineItemOriginalUnitPriceSetShopMoneyCurrencyCode	String		The currency code for the original unit price in shop money.
LineItemTotalDiscountSetPresentmentMoneyAmount	Decimal		The total discount applied to this line item in the presentment currency.
LineItemTotalDiscountSetPresentmentMoneyCurrencyCode	String		The currency code for the total discount in presentment money.
LineItemTotalDiscountSetShopMoneyAmount	Decimal		The total discount applied to this line item in the shop's currency.
LineItemTotalDiscountSetShopMoneyCurrencyCode	String		The currency code for the total discount in shop money.
LineItemUnfulfilledDiscountedTotalSetPresentmentMoneyAmount	Decimal		The discounted total for unfulfilled units in the presentment currency.
LineItemUnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the discounted unfulfilled total in presentment money.
LineItemUnfulfilledDiscountedTotalSetShopMoneyAmount	Decimal		The discounted total for unfulfilled units in the shop's currency.
LineItemUnfulfilledDiscountedTotalSetShopMoneyCurrencyCode	String		The currency code for the discounted unfulfilled total in shop money.
LineItemUnfulfilledOriginalTotalSetPresentmentMoneyAmount	Decimal		The original total for unfulfilled units in the presentment currency.
LineItemUnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the original unfulfilled total in presentment money.
LineItemUnfulfilledOriginalTotalSetShopMoneyAmount	Decimal		The original total for unfulfilled units in the shop's currency.
LineItemUnfulfilledOriginalTotalSetShopMoneyCurrencyCode	String		The currency code for the original unfulfilled total in shop money.

ODBC Driver for Shopify

FulfillmentLineItems

View-Specific Information

Select

Columns