Order note attributes table
The order note attributes table contains extra information about your orders. An order note attribute applies to the whole order and its value is added to a cart by your customer.
An order note attribute contains two parts: a key and its value. For example, given the order note attribute gift-type=birthday, the key is gift-type and the value is birthday.
This table contains one row per order note attribute and it reflects the current state of order note attributes in your Shopify admin.
| Column | Data type | Description |
|---|---|---|
| order_id | numeric | ID of the order. This column is a foreign key reference to the order_id column in the orders table. This column also acts as a primary key for this table. |
| shop_id | numeric | ID of the store. This column is a foreign key reference to the shop_id column in the shops table. |
| key | string | Name of the order note attribute and the first part of the key:value pair. |
| value | array | Value of the order note attribute and the second part of the key:value pair. |
An order note attribute is different from an order note. An order note is a text field that can appear on any cart page. An order note attribute is a key-value pair, which contains the values that your customer added to a cart page. An order note attribute contains the contents that a customer adds to a cart attribute on the cart page.
The following example returns the total prices of orders by the language: