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