Excel Add-In for WooCommerce

Build 23.0.8839


Retrieve and modify the notes 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 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


The following attributes are required when performing an insert: Note, OrderId.

INSERT INTO OrderNotes (Note, OrderId) VALUES ("note_text", 144)


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

Id of the order.

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