OrderCouponLines
Retrieve the coupon lines for an order.
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 column for this
table is: OrderId. All other columns are processed client side.
SELECT * FROM OrderCouponLines WHERE OrderId = 144
Columns
Name | Type | Description |
Id [KEY] | Long | Item ID. |
Code | String | Coupon code. |
Discount | String | Discount total. |
DiscountTax | String | Discount total tax. |
MetaData | String | Meta data. See Order - Meta data properties |
OrderId | String | Id of the order. |