CustomerAddresses
Create, update, delete, and query customer addresses.
Table-Specific Information
Select
The cmdlet uses the Shopify API to process WHERE clause conditions built with the following column and operator. The cmdlet processes other filters client-side within the cmdlet.- CustomerId supports the '=,IN' comparison.
- CustomerUpdatedAt supports the '<,>,<=,>=' comparison.
For example, the following queries are processed server-side:
SELECT * FROM CustomerAddresses WHERE CustomerId = '123'
SELECT * FROM CustomerAddresses WHERE CustomerId IN ('123', '456')
SELECT * FROM CustomerAddresses WHERE CustomerUpdatedAt >= '2018-05-04'
Insert
You must specify the customer Id to create an address.
INSERT INTO CustomerAddresses (CustomerId, Address1, City, Company) VALUES ('123', '1 Rue des Carrieres', 'Suite 1234', 'Montreal')
Update
You must specify the customer Id and the Id of the customer address to update an address.
UPDATE CustomerAddresses SET Zip = '90210' WHERE CustomerId = '123' AND Id = '456'
Delete
You must specify the customer Id and the Id of the customer address to delete an address. You cannot delete a customer's default address.
DELETE FROM CustomerAddresses WHERE CustomerId = '183467180055' AND Id = '292265787415'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
A unique numeric identifier for the address. | |
CustomerId [KEY] | Long | False |
Customers.Id |
A unique numeric identifier for the customer. |
CustomerUpdatedAt | Datetime | True |
The date and time when the customer information was last updated. | |
Name | String | False |
The customer's name. | |
FirstName | String | False |
The customer's first name. | |
LastName | String | False |
The customer's last name. | |
Company | String | False |
The customer's company. | |
Address1 | String | False |
The customer's mailing address. | |
Address2 | String | False |
An additional field for the customer's mailing address. | |
City | String | False |
The customer's city. | |
Province | String | False |
The customer's province or state name. | |
Country | String | False |
The customer's country. | |
Zip | String | False |
The customer's zip or postal code. | |
Phone | String | False |
The customer's phone number for this mailing address. | |
ProvinceCode | String | False |
The two-letter pcode for the customer's province or state. | |
CountryCode | String | False |
The two-letter country code corresponding to the customer's country. | |
CountryName | String | False |
The customer's normalized country name. | |
Default | Bool | True |
Indicates whether this address is the default address for the customer. |