OrderShippingLines
Retrieve the shipping 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. If the 'OrderId' filter is not specified,
the provider will fetch a list of all the orders and perform a request for each order in the list.
SELECT * FROM OrderShippingLines WHERE OrderId = 21
Columns
Name | Type | Description |
Id [KEY] | Long | Item ID. |
MethodTitle | String | Shipping method name. |
MethodId | String | Shipping method ID. |
Total | String | Line total (after discounts). |
TotalTax | String | Line total tax (after discounts). |
Taxes | String | Line taxes. See Order - Taxes properties read-only |
MetaData | String | Meta data. See Order - Meta data properties |
OrderId | Long | Id of the order. |