ReturnExchangeLineItems

Lists exchange line items associated with a return, including replacement products, quantities, and values.

View-Specific Information

Select

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

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

疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。


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.

Power BI Connector for Shopify

ReturnExchangeLineItems

View-Specific Information

Select

Columns

Pseudo-Columns