OrderLineItems

Retrieves a list of line items in the associated resource.

View-Specific Information

Select

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

ResourceId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM OrderLineItems
  SELECT * FROM OrderLineItems WHERE ResourceId = 'Val1'

Columns


Name	Type	References	Description
Id [KEY]	String		A globally-unique ID.
ResourceId	String	Orders.Id	A globally-unique ID.
Name	String		The title of the product, optionally appended with the title of the variant (if applicable).
Title	String		The title of the product at time of order creation.
VariantTitle	String		The title of the variant at time of order creation.
VariantId	String		A globally-unique ID.
ProductId	String		A globally-unique ID.
SellingPlanSellingPlanId	String		The ID of the selling plan associated with the line item.
Quantity	Int		The number of variant units ordered.
Restockable	Bool		Whether the line item can be restocked.
Sku	String		The variant SKU number.
Taxable	Bool		Whether the variant is taxable.
Vendor	String		The name of the vendor who made the variant.
CurrentQuantity	Int		The line item's quantity, minus the removed quantity.
MerchantEditable	Bool		Whether the line item can be edited or not.
RefundableQuantity	Int		The line item's quantity, minus the removed quantity.
RequiresShipping	Bool		Whether physical shipping is required for the variant.
UnfulfilledQuantity	Int		The number of units not yet fulfilled.
NonFulfillableQuantity	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.
DiscountedTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
DiscountedTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
DiscountedTotalSetShopMoneyAmount	Decimal		Decimal money amount.
DiscountedTotalSetShopMoneyCurrencyCode	String		Currency of the money.
DiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
DiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
DiscountedUnitPriceSetShopMoneyAmount	Decimal		Decimal money amount.
DiscountedUnitPriceSetShopMoneyCurrencyCode	String		Currency of the money.
ImageId	String		A unique ID for the image.
ImageWidth	Int		The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
ImageAltText	String		A word or phrase to share the nature or contents of an image.
ImageHeight	Int		The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
ImageUrl	String		The location of the image as a URL.
OriginalTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
OriginalTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
OriginalTotalSetShopMoneyAmount	Decimal		Decimal money amount.
OriginalTotalSetShopMoneyCurrencyCode	String		Currency of the money.
OriginalUnitPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
OriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
OriginalUnitPriceSetShopMoneyAmount	Decimal		Decimal money amount.
OriginalUnitPriceSetShopMoneyCurrencyCode	String		Currency of the money.
TotalDiscountSetPresentmentMoneyAmount	Decimal		Decimal money amount.
TotalDiscountSetPresentmentMoneyCurrencyCode	String		Currency of the money.
TotalDiscountSetShopMoneyAmount	Decimal		Decimal money amount.
TotalDiscountSetShopMoneyCurrencyCode	String		Currency of the money.
UnfulfilledDiscountedTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
UnfulfilledDiscountedTotalSetShopMoneyAmount	Decimal		Decimal money amount.
UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode	String		Currency of the money.
UnfulfilledOriginalTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
UnfulfilledOriginalTotalSetShopMoneyAmount	Decimal		Decimal money amount.
UnfulfilledOriginalTotalSetShopMoneyCurrencyCode	String		Currency of the money.

ODBC Driver for Shopify

OrderLineItems

View-Specific Information

Select

Columns