Customers
Create, update, delete, and query customers.
Table-Specific Information
Select
The adapter uses the Shopify API to process WHERE clause conditions built with the following column and operator. The adapter processes other filters client-side within the adapter.
- Id supports the '=,IN' comparison.
- FirstName supports the '=' comparison.
- LastName supports the '=' comparison.
- Email supports the '=' comparison.
- Phone supports the '=' comparison.
- TotalSpent supports the '=' comparison.
- OrdersCount supports the '=' comparison.
- AcceptsMarketing supports the '=' comparison.
- State supports the '=' comparison.
- VerifiedEmail supports the '=' comparison.
- CreatedAt supports the '>=,<=' comparison.
- UpdatedAt supports the '>=,<=,=' comparison.
SELECT * FROM Customers
SELECT * FROM Customers WHERE Id = '123'
SELECT * FROM Customers WHERE Id IN ('123', '456')
SELECT * FROM Customers WHERE CreatedAt >= '2017-10-25'
SELECT * FROM Customers WHERE CreatedAt <= '2017-10-25'
SELECT * FROM Customers WHERE UpdatedAt <= '2017-10-25'
SELECT * FROM Customers WHERE UpdatedAt >= '2017-10-25'
SELECT * FROM Customers WHERE FirstName = 'abc'
SELECT * FROM Customers WHERE LastName = 'xyz'
SELECT * FROM Customers WHERE Email = 'abcxyz@gmail.com'
SELECT * FROM Customers WHERE OrdersCount = 5
SELECT * FROM Customers WHERE Phone = '999999999'
SELECT * FROM Customers WHERE VerifiedEmail = true
SELECT * FROM Customers WHERE UpdatedAt = '2017-10-25'
Insert
The Email field is required to insert.
INSERT INTO Customers(Email, Phone) VALUES('steve.lastnameson@example.com', '+15142546011')
INSERT INTO Customers(Email, Phone, SendEmailInvite) VALUES('steve.lastnameson@example.com', '+15142546011', true)
Update
You must specify the Id of the customer to update a customer.
UPDATE Customers SET Note='Customer is a great guy' WHERE Id='123'
UPDATE Customers SET Tags='New Customer, Repeat Customer' WHERE Id='123'
Delete
You must specify the Id of the customer to delete a customer.
DELETE FROM Customers WHERE Id='123'
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 | 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. |