Customers
Create, update, delete, and query customers.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the customer. | |
| LastOrderId | Long | True |
Orders.Id |
The id of the customer's last order. |
| LastOrderName | String | True |
The name of the customer's last order. | |
| FirstName | String | False |
The customer's first name. | |
| LastName | String | False |
The customer's last name. | |
| String | False |
The unique email address of the customer. | ||
| Phone | String | False |
The unique phone number for this customer. | |
| TaxExempt | Bool | False |
Indicates whether the customer should be charged taxes when placing orders. | |
| TotalSpent | Decimal | True |
The total amount of money that the customer has spent at the shop. | |
| OrdersCount | Int | True |
The number of orders associated with this customer. | |
| MultipassIdentifier | String | True |
The customer's identifier used with Multipass login. | |
| Note | String | False |
A note about the customer. | |
| EmailMarketingState | String | False |
The current email marketing state for the customer. | |
| EmailMarketingLevel | String | False |
The marketing subscription opt-in level. | |
| EmailMarketingUpdatedAt | Datetime | False |
The date and time when the customer consented to receive marketing material by email. | |
| State | String | True |
The state of the customer's account in a shop. | |
| Tags | String | False |
The tags for this customer. Separate with comma for multiple tags. | |
| VerifiedEmail | Bool | True |
States whether or not the email address has been verified. | |
| CreatedAt | Datetime | True |
The date and time when the customer was created. | |
| UpdatedAt | Datetime | True |
The date and time when the customer information was updated. |
Pseudo-Columns
Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.
| Name | Type | Description |
| Password | String |
Password of the customer. |
| PasswordConfirmation | String |
Password confirmation of the customer. |
| SendEmailWelcome | Bool |
Whether to send a welcome email to the customer or not. |
| SendEmailInvite | Bool |
Whether to send an invite email to the customer or not. |