RefundLineItems

Lists refunded line items from an order, including product, quantity, and refund amount details.

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.

RefundId supports the '=, IN' comparison operators.

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

  SELECT * FROM RefundLineItems WHERE RefundId = 'Val1'

Columns


Name	Type	References	Description
Id [KEY]	String		A globally unique identifier for the refund line item record.
LineItemId	String		The globally unique identifier of the original line item being refunded.
RefundId	String	Refunds.Id	The globally unique identifier of the refund transaction associated with this line item.
LineItemName	String		The display name of the refunded item, combining the product title and variant title if applicable.
LineItemTitle	String		The product title as it appeared at the time of the original order creation.
LineItemVariantTitle	String		The variant title as it appeared at the time of the original order creation.
LineItemQuantity	Int		The number of variant units originally ordered for this line item.
LineItemRestockable	Bool		Indicates whether the refunded item can be returned to inventory and restocked.
LineItemSku	String		The stock keeping unit (SKU) code identifying the product variant.
LineItemTaxable	Bool		Indicates whether sales tax was applied to this product variant.
LineItemVendor	String		The name of the vendor or supplier who provided the product variant.
LineItemCurrentQuantity	Int		The remaining quantity of the line item after subtracting refunded or removed units.
LineItemMerchantEditable	Bool		Indicates whether this line item can be modified by the merchant.
LineItemRefundableQuantity	Int		The total number of units eligible to be refunded for this line item after accounting for previous refunds or removals.
LineItemNonFulfillableQuantity	Int		The number of units that cannot be fulfilled. Includes refunded items and non-physical items such as tips or service charges.
LineItemRequiresShipping	Bool		Indicates whether the variant requires physical shipping as part of fulfillment.
LineItemUnfulfilledQuantity	Int		The number of units from this line item that have not yet been fulfilled.
LineItemImageId	String		The globally unique identifier of the image associated with this line item.
LineItemImageWidth	Int		The original 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 for accessibility or SEO.
LineItemImageHeight	Int		The original height of the product image in pixels. Returns null if the image is not hosted by Shopify.
LineItemImageUrl	String		The URL where the product image is hosted and accessible.
LineItemProductId	String		The globally unique identifier of the product associated with this line item.
LineItemVariantId	String		The globally unique identifier of the product variant associated with this line item.
LineItemSellingPlanSellingPlanId	String		The identifier of the selling plan linked to this line item, such as a subscription or recurring purchase plan.
LineItemStaffMemberId	String		The unique identifier of the staff member associated with the sale. Available only to Shopify Plus merchants.
Quantity	Int		The number of units refunded for this line item in the current refund transaction.
Restocked	Bool		Indicates whether the refunded quantity was restocked into available inventory. Not used in the context of a SuggestedRefund.
RestockType	String		Specifies the type of restock action performed, such as 'cancel', 'return', or 'no_restock'.
LocationId	String		The globally unique identifier of the location where the restock or refund was processed.
PriceSetPresentmentMoneyAmount	Decimal		The price per unit of the refunded item in the customer's presentment currency, expressed as a decimal money value.
PriceSetPresentmentMoneyCurrencyCode	String		The ISO 4217 currency code for the presentment currency of the refunded line item price.
PriceSetShopMoneyAmount	Decimal		The price per unit of the refunded item in the shop's base currency, represented as a decimal money value.
PriceSetShopMoneyCurrencyCode	String		The ISO 4217 currency code representing the shop's base currency for the refunded line item price.
SubtotalSetPresentmentMoneyAmount	Decimal		The subtotal amount for this refunded line item in the presentment currency, before taxes, represented as a decimal money value.
SubtotalSetPresentmentMoneyCurrencyCode	String		The ISO 4217 currency code for the presentment currency of the subtotal amount.
SubtotalSetShopMoneyAmount	Decimal		The subtotal amount for this refunded line item in the shop's base currency, before taxes, represented as a decimal money value.
SubtotalSetShopMoneyCurrencyCode	String		The ISO 4217 currency code for the shop's base currency of the subtotal amount.
TotalTaxSetPresentmentMoneyAmount	Decimal		The total tax amount applied to this refunded line item in the customer's presentment currency, represented as a decimal money value.
TotalTaxSetPresentmentMoneyCurrencyCode	String		The ISO 4217 currency code for the presentment currency of the refunded tax amount.
TotalTaxSetShopMoneyAmount	Decimal		The total tax amount applied to this refunded line item in the shop's base currency, represented as a decimal money value.
TotalTaxSetShopMoneyCurrencyCode	String		The ISO 4217 currency code for the shop's base currency of the refunded tax amount.
LineItemContractId	String		The globally unique identifier of the related contract, if the refunded item was part of a contractual selling agreement or subscription.

Power BI Connector for Shopify

RefundLineItems

View-Specific Information

Select

Columns