ReverseFulfillmentOrders
Lists items within returns to be processed by a fulfillment service.
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 ReverseFulfillmentOrders WHERE ReturnId = 'Val1'
SELECT * FROM ReverseFulfillmentOrders WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id for the reverse fulfillment order. | |
| ReturnId | 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. | |
| Status | String | The current status of the reverse fulfillment order (for example, open, in_progress, or completed). | |
| ThirdPartyConfirmationStatus | String | The status of the third-party confirmation for the reverse fulfillment order. |