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 component 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. |