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
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| 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. |