Customers
Stores customer profiles including contact details, marketing preferences, and order associations.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the customer. | |
| LastOrderId | Long | True |
Orders.Id |
The unique identifier of the customer's most recent order. |
| LastOrderName | String | True |
The name or reference label of the customer's most recent order. | |
| FirstName | String | False |
The customer's first name. | |
| LastName | String | False |
The customer's last name. | |
| String | False |
The customer's unique email address used for communication and account identification. | ||
| Phone | String | False |
The customer's unique phone number associated with their account. | |
| TaxExempt | Bool | False |
Indicates whether the customer is exempt from being charged taxes on orders. | |
| TotalSpent | Decimal | True |
The total monetary amount the customer has spent in the shop, across all orders. | |
| OrdersCount | Int | True |
The total number of orders placed by the customer. | |
| MultipassIdentifier | String | True |
The customer's identifier used for Multipass login authentication. | |
| Note | String | False |
A merchant-added note providing internal details or context about the customer. | |
| EmailMarketingState | String | False |
The customer's current subscription state for email marketing communications. | |
| EmailMarketingLevel | String | False |
The opt-in level defining how the customer consents to receive marketing emails. | |
| EmailMarketingUpdatedAt | Datetime | False |
The date and time when the customer's email marketing consent was last updated. | |
| State | String | True |
The current account status for the customer within the shop (for example, enabled or disabled). | |
| Tags | String | False |
A list of tags associated with the customer, separated by commas. | |
| VerifiedEmail | Bool | True |
Indicates whether the customer's email address has been verified. | |
| CreatedAt | Datetime | True |
The date and time when the customer record was created. | |
| UpdatedAt | Datetime | True |
The date and time when the customer record was last 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 |
The customer's password used for authentication. |
| PasswordConfirmation | String |
A confirmation value matching the customer's password for verification purposes. |
| SendEmailWelcome | Bool |
Indicates whether a welcome email should be sent to the customer after account creation. |
| SendEmailInvite | Bool |
Indicates whether an account invite email should be sent to the customer. |