Refunds
Represents a refund of items or transactions in an order.
Table-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM Refunds WHERE OrderId = 'Val1'
Insert
The following columns can be used to create a new record:
OrderId, Note, RefundLineItems (references RefundLineItems)
RefundLineItems Temporary Table Columns
| Column Name | Type | Description |
| LineItemId | String | A globally-unique ID. |
| LineItemQuantity | Int | The number of variant units ordered. |
| RestockType | String | The type of restock for the refunded line item. |
| LocationId | String | A globally-unique ID. |
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique identifier. | |
| LegacyResourceId | String | True |
The ID of the corresponding resource in the REST Admin API. | |
| OrderId | String | True |
Orders.Id |
A globally-unique ID. |
| Note | String | True |
The optional note associated with the refund. | |
| CreatedAt | Datetime | True |
The date and time when the refund was created. | |
| UpdatedAt | Datetime | True |
The date and time when the refund was updated. | |
| ReturnId | String | True |
A globally-unique ID. | |
| StaffMemberId | String | True |
A globally-unique ID. (This column is available only with a ShopifyPlus subscription) | |
| TotalRefundedSetPresentmentMoneyAmount | Decimal | True |
Decimal money amount. | |
| TotalRefundedSetPresentmentMoneyCurrencyCode | String | True |
Currency of the money. | |
| TotalRefundedSetShopMoneyAmount | Decimal | True |
Decimal money amount. | |
| TotalRefundedSetShopMoneyCurrencyCode | String | True |
Currency of the money. | |
| RefundLineItems | String | True |
The list of the line items in the draft order. |