ReturnLineItems
Displays the line items included in a return request, including refund amounts and restock eligibility.
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.
- ReturnId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM ReturnLineItems WHERE ReturnId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the return line item record. | |
| ReturnId [KEY] | String |
Returns.Id | The globally unique identifier of the return associated with this line item. |
| Quantity | Int | The number of units of the product being returned as part of this return record. | |
| CustomerNote | String | An optional message from the customer describing the reason or context for the return. Limited to 300 characters. | |
| RefundableQuantity | Int | The total number of units that are still eligible to be refunded for this return line item. | |
| RefundedQuantity | Int | The number of units that have already been refunded for this return line item. | |
| ReturnReason | String | The primary reason provided for the return, such as 'damaged', 'wrong size', or 'defective'. | |
| ReturnReasonNote | String | Additional merchant or customer notes elaborating on the reason for the return. Limited to 255 characters. | |
| TotalWeightUnit | String | The unit of measurement used for the total returned item weight, such as 'grams' or 'kilograms'. | |
| TotalWeightValue | Double | The numeric weight value of the returned items, measured using the specified unit system. | |
| WithCodeDiscountedTotalPriceSetPresentmentMoneyAmount | Decimal | The total discounted price of the returned item, including discount codes, in the customer's presentment currency, expressed as a decimal money value. | |
| WithCodeDiscountedTotalPriceSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for the discounted total price. | |
| WithCodeDiscountedTotalPriceSetShopMoneyAmount | Decimal | The total discounted price of the returned item, including discount codes, in the shop's base currency, expressed as a decimal money value. | |
| WithCodeDiscountedTotalPriceSetShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the discounted total price. | |
| FulfillmentLineItemId | String | The globally unique identifier of the fulfillment line item associated with the return. |