ReturnExchangeLineItems
Lists line items created for exchanges within a return.
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.
- 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 Id for the return or exchange line item. | |
| ResourceId | String |
Returns.Id | A globally unique Id for the related resource. |
| Name | String | The product title, optionally appended with the variant title if applicable. | |
| Title | String | The product title at the time the order was created. | |
| VariantTitle | String | The variant title at the time the order was created. | |
| VariantId | String | A globally unique Id for the product variant. | |
| ProductId | String | A globally unique Id for the product. | |
| SellingPlanSellingPlanId | String | The Id of the selling plan linked to the line item. | |
| Quantity | Int | The number of units of the variant ordered. | |
| Restockable | Bool | Whether the line item can be restocked. | |
| Sku | String | The stock keeping unit (SKU) of the variant. | |
| Taxable | Bool | Whether the variant is taxable. | |
| Vendor | String | The name of the vendor that supplied the variant. | |
| CurrentQuantity | Int | The current quantity of the line item, after subtracting any removed units. | |
| MerchantEditable | Bool | Whether the line item can be edited by the merchant. | |
| RefundableQuantity | Int | The quantity of the line item that can be refunded. | |
| RequiresShipping | Bool | Whether the variant requires physical shipping. | |
| UnfulfilledQuantity | Int | The number of units that have not yet been fulfilled. | |
| NonFulfillableQuantity | Int | The number of units that cannot be fulfilled. For example, refunded items or non-physical items like tips. | |
| IsGiftCard | Bool | Whether the line item is a gift card purchase. | |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | The total discounted amount in the presentment currency. | |
| DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts | Decimal | The total discounted amount in the presentment currency, including code-based discounts. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | The currency code for the discounted total in presentment currency. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | The total discounted amount in the shop currency. | |
| DiscountedTotalSetShopMoneyAmountWithCodeDiscounts | Decimal | The total discounted amount in the shop currency, including code-based discounts. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | The currency code for the discounted total in shop currency. | |
| DiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | The discounted unit price in the presentment currency. | |
| DiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | The currency code for the discounted unit price in presentment currency. | |
| DiscountedUnitPriceSetShopMoneyAmount | Decimal | The discounted unit price in the shop currency. | |
| DiscountedUnitPriceSetShopMoneyCurrencyCode | String | The currency code for the discounted unit price in shop currency. | |
| ImageId | String | A unique Id for the product image. | |
| ImageWidth | Int | The original width of the product image in pixels, or null if not hosted by Shopify. | |
| ImageAltText | String | Alternative text describing the contents of the product image. | |
| ImageHeight | Int | The original height of the product image in pixels, or null if not hosted by Shopify. | |
| ImageUrl | String | The URL of the product image. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | The original total amount in the presentment currency. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | The currency code for the original total in presentment currency. | |
| OriginalTotalSetShopMoneyAmount | Decimal | The original total amount in the shop currency. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | The currency code for the original total in shop currency. | |
| OriginalUnitPriceSetPresentmentMoneyAmount | Decimal | The original unit price in the presentment currency. | |
| OriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | The currency code for the original unit price in presentment currency. | |
| OriginalUnitPriceSetShopMoneyAmount | Decimal | The original unit price in the shop currency. | |
| OriginalUnitPriceSetShopMoneyCurrencyCode | String | The currency code for the original unit price in shop currency. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | The total discount amount in the presentment currency. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | The currency code for the total discount in presentment currency. | |
| TotalDiscountSetShopMoneyAmount | Decimal | The total discount amount in the shop currency. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | The currency code for the total discount in shop currency. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyAmount | Decimal | The unfulfilled discounted total in the presentment currency. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode | String | The currency code for the unfulfilled discounted total in presentment currency. | |
| UnfulfilledDiscountedTotalSetShopMoneyAmount | Decimal | The unfulfilled discounted total in the shop currency. | |
| UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode | String | The currency code for the unfulfilled discounted total in shop currency. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyAmount | Decimal | The unfulfilled original total in the presentment currency. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode | String | The currency code for the unfulfilled original total in presentment currency. | |
| UnfulfilledOriginalTotalSetShopMoneyAmount | Decimal | The unfulfilled original total in the shop currency. | |
| UnfulfilledOriginalTotalSetShopMoneyCurrencyCode | String | The currency code for the unfulfilled original total in shop currency. |
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 | A fixed discount amount applied to the exchange line item. | |
| AppliedDiscountValueAmountCurrencyCode | String | The currency code for the fixed discount applied to the exchange line item. | |
| AppliedDiscountValuePercentage | Double | The discount percentage applied to the exchange line item. | |
| AppliedDiscountDescription | String | A description of the discount applied to the exchange line item. | |
| GiftCardCodes | String | The gift card codes linked to physical gift cards in the order. |