CustomerAddresses
List addresses associated with customers.
Table-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.
- 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 | True |
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, based on the first name 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 the street address or PO Box number. | |
| Address2 | String | False |
The second line of the address, typically the number of the apartment, suite, or unit. | |
| CountryCode | String | False |
The two-letter code for the country of the address (for example, 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 region of the address, such as the province, state, or district. | |
| City | String | False |
The name of the city, district, village, or town. | |
| Company | String | False |
The name of the customer's company or organization. | |
| FormattedArea | String | True |
A comma-separated list of the values for city, province, and country. | |
| Zip | String | False |
The zip or postal code of the address. | |
| Latitude | Double | True |
The latitude coordinate of the customer address. | |
| Longitude | Double | True |
The longitude coordinate of the customer 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 that is leveraged by the address validation feature in the Shopify Admin. |
Pseudo-Columns
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description |
| SetAsDefault | Bool |
Indicates whether to set the address as the customer's default address. |