OrderNotes
Retrieve and modify the notes 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 column for this
table is: 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 OrderNotes WHERE OrderId = 21
Insert
The following attributes are required when performing an insert: Note, OrderId.
INSERT INTO OrderNotes (Note, OrderId) VALUES ("note_text", 144)
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | False |
Unique identifier for the resource. | |
| Author | String | True |
Order note author. | |
| DateCreated | Datetime | True |
The date the order note was created, in the site's timezone. | |
| Note | String | False |
Order note content. | |
| CustomerNote | Boolean | False |
If true, the note will be shown to customers and they will be notified. If false, the note will be for admin reference only. Defaults to false. | |
| AddedByUser | Boolean | False |
If true, this note will be attributed to the current user. If false, the note will be attributed to the system. Defaults to false. | |
| OrderId | String | False |
Orders.Id |
Id of the order. |