Excel Add-In for WooCommerce

Build 23.0.8839


Retrieve the coupon 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.

SELECT * FROM OrderCouponLines WHERE OrderId = 144


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.

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