OrderLineItems

Provides detailed product-level information for all line items included in orders.

View-Specific Information

Select

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

ResourceId supports the '=, IN' comparison operators.

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

  SELECT * FROM OrderLineItems WHERE ResourceId = 'Val1'

Columns


Name	Type	References	Description
Id [KEY]	String		A globally unique identifier for the order line item.
ResourceId	String	Orders.Id	The globally unique identifier for the resource representing this line item.
Name	String		The full display name of the product as shown in the order, typically including both the product title and variant title.
Title	String		The title of the product as it appeared when the order was created.
VariantTitle	String		The title of the specific variant purchased, captured at the time of order creation.
VariantId	String		A globally unique identifier for the purchased product variant.
ProductId	String		A globally unique identifier for the base product associated with this line item.
SellingPlanSellingPlanId	String		The ID of the selling plan (for example, subscription or pre-order) associated with this line item.
Quantity	Int		The total number of units ordered for this product variant.
Restockable	Bool		Indicates whether this item can be returned to inventory if restocked.
Sku	String		The stock keeping unit (SKU) identifier for the purchased variant.
Taxable	Bool		Indicates whether the item is subject to tax based on the shop's tax settings.
Vendor	String		The name of the vendor or manufacturer who supplied the variant.
CurrentQuantity	Int		The remaining quantity for this line item after any cancellations or returns have been applied.
MerchantEditable	Bool		Indicates whether the merchant can edit this line item's details after the order is placed.
RefundableQuantity	Int		The number of units currently eligible for refund.
RequiresShipping	Bool		Whether this product requires physical shipment. False for digital or service items.
UnfulfilledQuantity	Int		The number of units in this line item that have not yet been fulfilled.
NonFulfillableQuantity	Int		The total number of units that cannot be fulfilled due to refunds, cancellations, or non-physical items such as tips.
IsGiftCard	Bool		Indicates whether this line item represents the purchase of a gift card.
DiscountedTotalSetPresentmentMoneyAmount	Decimal		The total discounted price for this line item in the customer's presentment currency.
DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts	Decimal		The total discounted price after applying discount codes, expressed in the presentment currency.
DiscountedTotalSetPresentmentMoneyCurrencyCode	String		The ISO currency code representing the presentment currency for the discounted total.
DiscountedTotalSetShopMoneyAmount	Decimal		The total discounted price for this line item in the shop's base currency.
DiscountedTotalSetShopMoneyAmountWithCodeDiscounts	Decimal		The total discounted price after discount codes, expressed in the shop's base currency.
DiscountedTotalSetShopMoneyCurrencyCode	String		The ISO currency code representing the shop's base currency for the discounted total.
DiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		The discounted price per unit of the item in the customer's presentment currency.
DiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		The ISO currency code representing the presentment currency for the discounted unit price.
DiscountedUnitPriceSetShopMoneyAmount	Decimal		The discounted price per unit of the item in the shop's base currency.
DiscountedUnitPriceSetShopMoneyCurrencyCode	String		The ISO currency code representing the shop's base currency for the discounted unit price.
ImageId	String		The unique identifier for the image associated with this product variant.
ImageWidth	Int		The original width of the associated product image in pixels, or null if not hosted by Shopify.
ImageAltText	String		A short descriptive phrase providing alternative text for the associated product image.
ImageHeight	Int		The original height of the associated product image in pixels, or null if not hosted by Shopify.
ImageUrl	String		The URL of the product image as hosted by Shopify or an external source.
OriginalTotalSetPresentmentMoneyAmount	Decimal		The total pre-discount price of this line item in the customer's presentment currency.
OriginalTotalSetPresentmentMoneyCurrencyCode	String		The ISO currency code for the presentment currency of the original (undiscounted) total.
OriginalTotalSetShopMoneyAmount	Decimal		The total pre-discount price of this line item in the shop's base currency.
OriginalTotalSetShopMoneyCurrencyCode	String		The ISO currency code for the shop's base currency of the original (undiscounted) total.
OriginalUnitPriceSetPresentmentMoneyAmount	Decimal		The pre-discount price per unit in the customer's presentment currency.
OriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		The ISO currency code representing the presentment currency for the pre-discount unit price.
OriginalUnitPriceSetShopMoneyAmount	Decimal		The pre-discount price per unit in the shop's base currency.
OriginalUnitPriceSetShopMoneyCurrencyCode	String		The ISO currency code representing the shop's base currency for the pre-discount unit price.
TotalDiscountSetPresentmentMoneyAmount	Decimal		The total discount value applied to this line item in the customer's presentment currency.
TotalDiscountSetPresentmentMoneyCurrencyCode	String		The ISO currency code representing the presentment currency for the total discount.
TotalDiscountSetShopMoneyAmount	Decimal		The total discount value applied to this line item in the shop's base currency.
TotalDiscountSetShopMoneyCurrencyCode	String		The ISO currency code representing the shop's base currency for the total discount.
UnfulfilledDiscountedTotalSetPresentmentMoneyAmount	Decimal		The discounted total for all unfulfilled units in presentment currency.
UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode	String		The ISO currency code representing the presentment currency for the unfulfilled discounted total.
UnfulfilledDiscountedTotalSetShopMoneyAmount	Decimal		The discounted total for all unfulfilled units in the shop's base currency.
UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode	String		The ISO currency code representing the shop's base currency for the unfulfilled discounted total.
UnfulfilledOriginalTotalSetPresentmentMoneyAmount	Decimal		The original total before discounts for all unfulfilled units, in presentment currency.
UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode	String		The ISO currency code for the presentment currency of the unfulfilled original total.
UnfulfilledOriginalTotalSetShopMoneyAmount	Decimal		The original total before discounts for all unfulfilled units, in the shop's base currency.
UnfulfilledOriginalTotalSetShopMoneyCurrencyCode	String		The ISO currency code for the shop's base currency of the unfulfilled original total.
OrderUpdatedAt	Datetime		The date and time when the order containing this line item was last updated.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.


Name	Type	Description
FulfillmentService	String		The handle of the fulfillment service responsible for stocking or shipping this product variant.
OrderLineItemCustomAttributes	String		Custom metadata fields associated with the line item, often used for personalization or configuration options.
OrderLineItemTaxLines	String		A list of tax line objects, each representing a specific tax applied to this line item.

Power BI Connector for Shopify

OrderLineItems

View-Specific Information

Select

Columns

Pseudo-Columns