Refunds
Represents a refund of items or transactions in an order.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operator. The connector processes other filters client-side within the connector.
- OrderId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Refunds
SELECT * FROM Refunds WHERE OrderId = 'Val1'
Insert
The following columns can be used to create a new record:
OrderId, Note
The following pseudo-columns can be used to create a new record:
RefundLineItems
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. |