ReturnExchangeLineItems
Lists exchange line items associated with a return, including replacement products, quantities, and values.
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 ReturnExchangeLineItems WHERE ResourceId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the return or exchange line item record. | |
| ResourceId | String |
Returns.Id | The globally unique identifier of the related order line item resource. |
| Name | String | The display name of the product, optionally including the variant title if applicable. | |
| Title | String | The product title as it appeared at the time the original order was created. | |
| VariantTitle | String | The variant title as it appeared at the time the original order was created. | |
| VariantId | String | The globally unique identifier of the variant associated with this return or exchange line item. | |
| ProductId | String | The globally unique identifier of the product associated with this return or exchange line item. | |
| SellingPlanSellingPlanId | String | The unique identifier of the selling plan (such as a subscription or recurring purchase) tied to this line item. | |
| Quantity | Int | The number of variant units being processed as part of the return or exchange. | |
| Restockable | Bool | Indicates whether this returned item can be restocked into inventory. | |
| Sku | String | The stock keeping unit (SKU) assigned to the product variant. | |
| Taxable | Bool | Indicates whether the product variant is subject to sales tax. | |
| Vendor | String | The name of the vendor or supplier associated with the product variant. | |
| CurrentQuantity | Int | The remaining quantity for this line item after accounting for previously fulfilled, refunded, or removed units. | |
| MerchantEditable | Bool | Indicates whether the merchant can modify this line item during the return or exchange process. | |
| RefundableQuantity | Int | The total quantity eligible for refund or exchange after considering prior adjustments. | |
| RequiresShipping | Bool | Indicates whether this line item requires physical shipping to complete the return or exchange. | |
| UnfulfilledQuantity | Int | The number of units for this line item that have not yet been fulfilled or returned. | |
| NonFulfillableQuantity | Int | The number of units that cannot be fulfilled, such as refunded items, or non-physical items like tips. | |
| IsGiftCard | Bool | Indicates whether the line item represents a purchased gift card product. | |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | The total discounted price of this line item in the customer's presentment currency, expressed as a decimal money value. | |
| DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts | Decimal | The total discounted price including code-based discounts in the customer's presentment currency, expressed as a decimal money value. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the discounted total amount. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | The total discounted price of this line item in the shop's base currency, expressed as a decimal money value. | |
| DiscountedTotalSetShopMoneyAmountWithCodeDiscounts | Decimal | The total discounted price including code-based discounts in the shop's base currency, expressed as a decimal money value. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the discounted total amount. | |
| DiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | The discounted price per unit in the customer's presentment currency, expressed as a decimal money value. | |
| DiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the discounted unit price. | |
| DiscountedUnitPriceSetShopMoneyAmount | Decimal | The discounted price per unit in the shop's base currency, expressed as a decimal money value. | |
| DiscountedUnitPriceSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the discounted unit price. | |
| ImageId | String | The globally unique identifier for the product image associated with this line item. | |
| ImageWidth | Int | The original width of the product image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageAltText | String | Alternative text describing the product image for accessibility and SEO. | |
| ImageHeight | Int | The original height of the product image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageUrl | String | The URL where the product image is hosted and accessible. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | The original total (before discounts) for this line item in the customer's presentment currency, expressed as a decimal money value. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the original total amount. | |
| OriginalTotalSetShopMoneyAmount | Decimal | The original total (before discounts) for this line item in the shop's base currency, expressed as a decimal money value. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the original total amount. | |
| OriginalUnitPriceSetPresentmentMoneyAmount | Decimal | The original per-unit price (before discounts) in the customer's presentment currency, expressed as a decimal money value. | |
| OriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the original unit price. | |
| OriginalUnitPriceSetShopMoneyAmount | Decimal | The original per-unit price (before discounts) in the shop's base currency, expressed as a decimal money value. | |
| OriginalUnitPriceSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the original unit price. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | The total discount amount applied to this line item in the customer's presentment currency, expressed as a decimal money value. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the total discount amount. | |
| TotalDiscountSetShopMoneyAmount | Decimal | The total discount amount applied to this line item in the shop's base currency, expressed as a decimal money value. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the total discount amount. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyAmount | Decimal | The discounted total for unfulfilled quantities in the customer's presentment currency, expressed as a decimal money value. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the unfulfilled discounted total. | |
| UnfulfilledDiscountedTotalSetShopMoneyAmount | Decimal | The discounted total for unfulfilled quantities in the shop's base currency, expressed as a decimal money value. | |
| UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the unfulfilled discounted total. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyAmount | Decimal | The original total for unfulfilled quantities in the customer's presentment currency, expressed as a decimal money value. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the unfulfilled original total. | |
| UnfulfilledOriginalTotalSetShopMoneyAmount | Decimal | The original total for unfulfilled quantities in the shop's base currency, expressed as a decimal money value. | |
| UnfulfilledOriginalTotalSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the unfulfilled original total. |
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 | |
| AppliedDiscountValueAmount | Decimal | The value of the discount applied to this exchange line item, represented as a fixed monetary amount. | |
| AppliedDiscountValueAmountCurrencyCode | String | The ISO 4217 currency code representing the currency of the fixed discount amount. | |
| AppliedDiscountValuePercentage | Double | The value of the discount applied to this exchange line item, represented as a percentage. | |
| AppliedDiscountDescription | String | A description of the discount applied to the exchange line item, such as a promotion or return adjustment. | |
| GiftCardCodes | String | A list of gift card codes associated with physical gift cards included in the return or exchange. |