MuleSoft Connector for WooCommerce

Build 21.0.7930


Retrieve the line items 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 columns for this table are: TotalTax, OrderId. All other columns are processed client side. If the 'OrderId' filter is not specified, the connector will fetch a list of all the orders and perform a request for each order in the list.

SELECT * FROM OrderLineItems WHERE OrderId = 13
SELECT * FROM OrderLineItems WHERE TotalTax = 14.21


The following attribute is required when performing an insert: OrderId.

INSERT INTO OrderLineItems(Productid,Quantity,OrderId) VALUES (28,9,35)


The following attribute is required when performing an update: OrderId.

UPDATE OrderLineItems SET Quantity = 12 WHERE Id = 4 and OrderId = 35


Name Type Description
Id [KEY] Integer Item ID.
Name String Product name.
ProductId Integer Product ID.
VariationId Integer Variation ID, if applicable.
Quantity Integer Quantity ordered.
TaxClass Integer Tax class of product.
Subtotal String Line subtotal (before discounts).
SubtotalTax String Line subtotal tax (before discounts).
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
Sku String Product SKU.
Price String Product price.
OrderId String Id of the order.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930