Excel Add-In for WooCommerce

Build 23.0.8839


Retrieve the shipping lines for an order.

Table Specific Information


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 add-in will fetch a list of all the orders and perform a request for each order in the list.

SELECT * FROM OrderShippingLines WHERE OrderId = 21


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839