CustomerAddresses
Lists addresses stored on customer profiles, including default selections.
Table-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following column and operators. The provider processes other filters client-side within the provider.
- CustomerId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM CustomerAddresses WHERE CustomerId = 'Val1'
Insert
The following columns can be used to create a new record:
CustomerId, CustomerFirstName, CustomerLastName, Phone, Address1, Address2, CountryCode, ProvinceCode, City, Company, Zip
The following pseudo-column can be used to create a new record:
SetAsDefault
Update
The following columns can be updated:
CustomerId, CustomerFirstName, CustomerLastName, Phone, Address1, Address2, CountryCode, ProvinceCode, City, Company, Zip
The following pseudo-column can be used to update a record:
SetAsDefault
Delete
You can delete entries by specifying the following columns:
Id, CustomerId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The globally unique identifier of the customer address. | |
| CustomerId | String | False |
The globally unique identifier of the customer associated with this address. | |
| CustomerFirstName | String | False |
The first name of the customer. | |
| CustomerLastName | String | False |
The last name of the customer. | |
| CustomerName | String | True |
The full name of the customer, derived from the first and last name. | |
| Phone | String | False |
The customer's phone number associated with the address. | |
| Address1 | String | False |
The first line of the address, typically a street address or PO Box. | |
| Address2 | String | False |
The second line of the address, typically an apartment, suite, or unit number. | |
| CountryCode | String | False |
The two-letter country code of the address, such as US. | |
| Country | String | True |
The name of the country for the address. | |
| ProvinceCode | String | False |
The alphanumeric code for the province, state, or district of the address, such as 'ON', for Ontario. | |
| Province | String | True |
The province, state, or district of the address. | |
| City | String | False |
The city, town, district, or village of the address. | |
| Company | String | False |
The name of the company or organization associated with the customer address. | |
| FormattedArea | String | True |
A comma-separated string combining the city, province, and country of the address. | |
| Zip | String | False |
The postal or ZIP code of the address. | |
| Latitude | Double | True |
The latitude coordinate of the address. | |
| Longitude | Double | True |
The longitude coordinate of the address. | |
| TimeZone | String | True |
The time zone associated with the customer address. | |
| CoordinatesValidated | Bool | True |
Indicates whether the address corresponds to recognized latitude and longitude values. | |
| ValidationResultSummary | String | True |
The validation status of the address, as determined by the Shopify Admin address validation feature. |
Pseudo-Columns
Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.
| Name | Type | Description |
| SetAsDefault | Bool |
Whether to set the address as the customer's default address. |