OrderRefundLineItems
Retrieve the line items for a refund.
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 only the = comparison, unless stated otherwise. The available columns for this
table are: OrderId, RefundId. All other columns are processed client side. If the 'OrderId' filter is
not specified, the driver will fetch a list of all the orders and perform a request for each order in the list.
The above behaviour will happen apply also for refunds, if 'RefundId' is not specified.
SELECT * FROM OrderRefundLineItems WHERE OrderId = 16
Columns
| Name | Type | Description |
| Id | Long | Item ID. |
| Name | String | Product name. |
| ProductId | Long | Product ID. |
| VariationId | Long | Variation ID, if applicable. |
| Quantity | Integer | Quantity ordered. |
| TaxClass | Integer | Tax class of product. |
| Subtotal | String | Line subtotal (before discounts). |
| SubtotalTax | String | Line subtotal tax (before discounts). |
| Total | String | Line total (after discounts). |
| TotalTax | String | Line total tax (after discounts). |
| TaxesAggregate | String | Line taxes. See Order refund line item - Taxes properties read-only |
| MetaDataAggregate | String | Meta data. See Order refund - Meta data properties |
| Sku | String | Product SKU. |
| Price | String | Product price. |
| OrderId | String | Id of the order. |
| RefundId | String | Id of the refund. |