Refunds

Represents a refund of items or transactions in an order.

Table-Specific Information

Select

The server uses the Shopify API to process WHERE clause conditions built with the following column and operators. The server processes other filters client-side within the server.

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

The following pseudo-column can be used to create a new record:

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.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.


Name	Type	Description
RefundLineItems	String	The list of the line items in the draft order.