FulfillmentLineItems

Line items from orders that are included in fulfillments.

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		A globally-unique ID.
FulfillmentId	String	Fulfillments.Id	A globally-unique ID.
DiscountedTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
DiscountedTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
DiscountedTotalSetShopMoneyAmount	Decimal		Decimal money amount.
DiscountedTotalSetShopMoneyCurrencyCode	String		Currency of the money.
OriginalTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
OriginalTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
OriginalTotalSetShopMoneyAmount	Decimal		Decimal money amount.
OriginalTotalSetShopMoneyCurrencyCode	String		Currency of the money.
Quantity	Int		Number of line items in the fulfillment.
LineItemId	String		A globally-unique ID.
LineItemName	String		The title of the product, optionally appended with the title of the variant (if applicable).
LineItemTitle	String		The title of the product at time of order creation.
LineItemVariantTitle	String		The title of the variant at time of order creation.
LineItemVariantId	String		A globally-unique ID.
LineItemProductId	String		A globally-unique ID.
LineItemSellingPlanSellingPlanId	String		The ID of the selling plan associated with the line item.
LineItemQuantity	Int		The number of variant units ordered.
LineItemRestockable	Bool		Whether the line item can be restocked.
LineItemSku	String		The variant SKU number.
LineItemTaxable	Bool		Whether the variant is taxable.
LineItemVendor	String		The name of the vendor who made the variant.
LineItemCurrentQuantity	Int		The line item's quantity, minus the removed quantity.
LineItemMerchantEditable	Bool		Whether the line item can be edited or not.
LineItemRefundableQuantity	Int		The line item's quantity, minus the removed quantity.
LineItemRequiresShipping	Bool		Whether physical shipping is required for the variant.
LineItemUnfulfilledQuantity	Int		The number of units not yet fulfilled.
LineItemNonFulfillableQuantity	Int		The total number of units that can't be fulfilled. For example, if items have been refunded, or the item is not something that can be fulfilled, like a tip. Please see the object for more fulfillment details.
LineItemIsGiftCard	Bool		Whether the line item represents the purchase of a gift card.
LineItemDiscountedTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
LineItemDiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts	Decimal		Decimal money amount.
LineItemDiscountedTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
LineItemDiscountedTotalSetShopMoneyAmount	Decimal		Decimal money amount.
LineItemDiscountedTotalSetShopMoneyAmountWithCodeDiscounts	Decimal		Decimal money amount.
LineItemDiscountedTotalSetShopMoneyCurrencyCode	String		Currency of the money.
LineItemDiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
LineItemDiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
LineItemDiscountedUnitPriceSetShopMoneyAmount	Decimal		Decimal money amount.
LineItemDiscountedUnitPriceSetShopMoneyCurrencyCode	String		Currency of the money.
LineItemImageId	String		A unique ID for the image.
LineItemImageWidth	Int		The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
LineItemImageAltText	String		A word or phrase to share the nature or contents of an image.
LineItemImageHeight	Int		The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
LineItemImageUrl	String		The location of the image as a URL.
LineItemOriginalTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
LineItemOriginalTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
LineItemOriginalTotalSetShopMoneyAmount	Decimal		Decimal money amount.
LineItemOriginalTotalSetShopMoneyCurrencyCode	String		Currency of the money.
LineItemOriginalUnitPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
LineItemOriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
LineItemOriginalUnitPriceSetShopMoneyAmount	Decimal		Decimal money amount.
LineItemOriginalUnitPriceSetShopMoneyCurrencyCode	String		Currency of the money.
LineItemTotalDiscountSetPresentmentMoneyAmount	Decimal		Decimal money amount.
LineItemTotalDiscountSetPresentmentMoneyCurrencyCode	String		Currency of the money.
LineItemTotalDiscountSetShopMoneyAmount	Decimal		Decimal money amount.
LineItemTotalDiscountSetShopMoneyCurrencyCode	String		Currency of the money.
LineItemUnfulfilledDiscountedTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
LineItemUnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
LineItemUnfulfilledDiscountedTotalSetShopMoneyAmount	Decimal		Decimal money amount.
LineItemUnfulfilledDiscountedTotalSetShopMoneyCurrencyCode	String		Currency of the money.
LineItemUnfulfilledOriginalTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
LineItemUnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
LineItemUnfulfilledOriginalTotalSetShopMoneyAmount	Decimal		Decimal money amount.
LineItemUnfulfilledOriginalTotalSetShopMoneyCurrencyCode	String		Currency of the money.

ODBC Driver for Shopify

FulfillmentLineItems

View-Specific Information

Select

Columns