ReturnLineItemsUnverified
Shows return line items pending verification, often awaiting condition or receipt confirmation.
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 ReturnLineItemsUnverified WHERE ReturnId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the unverified return line item record. | |
| ReturnId [KEY] | String |
Returns.Id | The globally unique identifier of the return associated with this unverified item. |
| CustomerNote | String | An optional note provided by the customer describing the item being returned. Limited to 300 characters. | |
| Quantity | Int | The number of units being returned for this unverified line item. | |
| RefundableQuantity | Int | The number of units eligible to be refunded once the return is verified. | |
| RefundedQuantity | Int | The number of units that have already been refunded for this unverified return line item. | |
| ReturnReason | String | The stated reason for returning the item, such as 'damaged', 'incorrect item', or 'not as described'. | |
| ReturnReasonNote | String | Additional comments elaborating on the reason for return. Limited to 255 characters. | |
| UnitPriceAmount | Decimal | The per-unit price of the item in monetary format, expressed as a decimal value. | |
| UnitPriceCurrencyCode | String | The ISO 4217 currency code representing the currency of the item's unit price. |