ReturnLineItemsUnverified
Lists unverified return line items pending inspection or validation.
View-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The provider processes other filters client-side within the provider.
- ReturnId supports the '=, IN' comparison operators.
- OrderId supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM ReturnLineItemsUnverified WHERE ReturnId = 'Val1'
SELECT * FROM ReturnLineItemsUnverified WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id for the unverified return line item. | |
| ReturnId [KEY] | String |
Returns.Id | A globally unique Id for the associated return. |
| OrderId | String |
Orders.Id | A globally-unique ID. |
| OrderReturnStatus | String | The order's aggregated return status for display purposes.
The allowed values are IN_PROGRESS, INSPECTION_COMPLETE, NO_RETURN, RETURN_FAILED, RETURN_REQUESTED, RETURNED. | |
| CustomerNote | String | A note from the customer describing the item to be returned. Maximum length: 300 characters. | |
| Quantity | Int | The number of units being returned. | |
| RefundableQuantity | Int | The number of units that can still be refunded. | |
| RefundedQuantity | Int | The number of units that have already been refunded. | |
| ReturnReasonDefinitionId | String | The return reason definition id. | |
| ReturnReasonDefinitionHandle | String | A unique, human-readable, stable identifier for the return reason. | |
| ReturnReasonDefinitionName | String | The localized, user-facing name of the return reason. | |
| ReturnReasonNote | String | Additional details about the reason for the return. Maximum length: 255 characters. | |
| UnitPriceAmount | Decimal | The unit price of the item in decimal format. | |
| UnitPriceCurrencyCode | String | The currency code for the unit price. |