Refunds
Retrieve and view refunds from your store, regardless of which order they are associated with.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query.
These columns support the =, !=, IN, and NOT IN comparisons unless specified otherwise. The available columns for this
table are Id and parentId. The Id column also supports Order by. All other columns are processed client-side.
SELECT * FROM Refunds ORDER BY Id SELECT * FROM Refunds WHERE Id = 2592 SELECT * FROM Refunds WHERE Id IN (2592,45) Select * from Refunds where parentid !=2102 Select * from Refunds where parentid NOT IN (12,2102)
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Unique identifier for the resource. | |
| Amount | Decimal | The total refund amount | |
| DateCreated | Datetime | The date the order refund was created, in the site's timezone. | |
| DateCreatedGMT | Datetime | The date the order refund was created, as GMT. | |
| Reason | String | Reason for refund. | |
| RefundedBy | Long | User ID of user who created the refund. | |
| RefundedPayment | Boolean | If the payment was refunded via the API. | |
| ParentId | Long |
Orders.Id | The ID of the order the refund is associated with. |
| LinksCollectionAggregate | String | A collection of links for all refunds. | |
| LinksSelfAggregate | String | Links corresponding to this refund. | |
| LinksUpAggregate | String | Links corresponding to the parent order details. | |
| FeeLinesAggregate | String | Fee lines data for the refund. | |
| LineItemsAggregate | String | Line items data for the refund. | |
| MetaDataAggregate | String | Metadata for the order refund. | |
| ShippingLines | String | Shipping lines data for the order refund. | |
| TaxLinesAggregate | String | Tax lines data for the order refund. |