CustomerMetadata
Retrieve the metadata for each customer.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. Following columns are supported server side, all other columns are processed client side.
- CustomerId supports the '=,IN,NOT IN,ORDER BY' operators.
SELECT * FROM Categories WHERE CustomerId = 294 SELECT * FROM Categories WHERE CustomerId IN (294,295) SELECT * FROM Categories WHERE CustomerId NOT IN (294,295) SELECT * FROM Categories ORDER BY CustomerId
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Metadata ID. | |
| Key | String | Metadata key. | |
| Value | String | Metadata value. | |
| CustomerId | String |
Customers.Id | Id of the customer. |