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