Refunds
Represents refunds of items or transactions on an order, with amounts and reasons.
Table-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.
- 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 |
A globally unique Id of the refund. | |
| LegacyResourceId | String | True |
The Id of the corresponding resource in the REST Admin API. | |
| OrderId | String | True |
Orders.Id |
A globally unique Id of the associated order. |
| Note | String | True |
An 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 last updated. | |
| ReturnId | String | True |
A globally unique Id of the associated return. | |
| StaffMemberId | String | True |
A globally unique Id of the staff member associated with the refund. (Available only with a ShopifyPlus subscription) | |
| TotalRefundedSetPresentmentMoneyAmount | Decimal | True |
The total refunded amount in the presentment currency, expressed as a decimal money amount. | |
| TotalRefundedSetPresentmentMoneyCurrencyCode | String | True |
The currency code of the total refunded amount in the presentment currency. | |
| TotalRefundedSetShopMoneyAmount | Decimal | True |
The total refunded amount in the shop's currency, expressed as a decimal money amount. | |
| TotalRefundedSetShopMoneyCurrencyCode | String | True |
The currency code of the total refunded amount in the shop's currency. | |
| RefundLineItems | String | True |
The list of line items included in the refund. |