TDV Adapter for WooCommerce

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462