JDBC Driver for WooCommerce

Build 24.0.9062

OrderLineItems

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

SELECT * FROM OrderLineItems WHERE OrderId = 13

Insert

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

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

Update

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

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

Columns

Name Type ReadOnly References 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

Orders.Id

Id of the order.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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 24.0.9062