Excel Add-In for WooCommerce

Build 23.0.8839


Add, update and view 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 add-in 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 ReadOnly Description
Id [KEY] Long False

Item ID.

Name String False

Product name.

ProductId Long False

Product ID.

VariationId Long False

Variation ID, if applicable.

Quantity Integer False

Quantity ordered.

TaxClass String False

Tax class of product.

Subtotal String False

Line subtotal (before discounts).

SubtotalTax String True

Line subtotal tax (before discounts).

Total String False

Line total (after discounts).

TotalTax String True

Line total tax (after discounts).

Taxes String True

Line taxes. See Order - Taxes properties read-only

MetaData String False

Meta data. See Order - Meta data properties

Sku String True

Product SKU.

Price String True

Product price.

OrderId String True

Id of the order.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ReferenceNumber String

This column will be used in Bulk operations to get specific values from the Temp tables.

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