Customers

Columns

Name

Type

ReadOnly

Description

Id [KEY]

Long

True

A unique numeric identifier for the customer.

LastOrderId

Long

True

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.

Email

String

False

The unique email address of the customer.

Phone

String

False

The unique phone number for this customer.

TaxExempt

Boolean

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

Integer

True

The number of orders associated with this customer.

AcceptsMarketing

Boolean

True

Indicates whether the customer has consented to be sent marketing material via email.

MultipassIdentifier

String

True

The customer's identifier used with Multipass login.

Note

String

False

A note about the customer.

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

Boolean

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 column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

Password

String

Password of the customer

PasswordConfirmation

String

Password confirmation of the customer.

SendEmailWelcome

Boolean

Whether to send a welcome email to the customer or not.

SendEmailInvite

Boolean

Whether to send an invite email to the customer or not.

Last updated