Refunds
Represents refund records, including refund reason, associated order, total amounts, and refund transactions.
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 identifier for the refund record. | |
| LegacyResourceId | String | True |
The identifier of the corresponding refund resource in the REST Admin API, used for backward compatibility. | |
| OrderId | String | True |
Orders.Id |
The globally unique identifier of the order associated with this refund. |
| Note | String | True |
An optional note entered by the merchant to describe or justify the refund. | |
| CreatedAt | Datetime | True |
The date and time when the refund record was created in Shopify. | |
| UpdatedAt | Datetime | True |
The date and time when the refund record was last updated. | |
| ReturnId | String | True |
The globally unique identifier of the related return record, if the refund is associated with a product return. | |
| StaffMemberId | String | True |
The globally unique identifier of the staff member who processed the refund. This field is available only to Shopify Plus merchants. | |
| TotalRefundedSetPresentmentMoneyAmount | Decimal | True |
The total refunded amount in the customer's presentment currency, expressed as a decimal money value. | |
| TotalRefundedSetPresentmentMoneyCurrencyCode | String | True |
The ISO 4217 currency code representing the presentment currency of the refund amount. | |
| TotalRefundedSetShopMoneyAmount | Decimal | True |
The total refunded amount converted to the shop's base currency, expressed as a decimal money value. | |
| TotalRefundedSetShopMoneyCurrencyCode | String | True |
The ISO 4217 currency code representing the shop's base currency of the refund amount. | |
| RefundLineItems | String | True |
A list of line items included in this refund, detailing the refunded products, quantities, and associated financial values. |