Locations
Retrieve information regarding store locations.
View-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operator is '='. The adapter processes other filters client-side within the adapter.
For example, the following queries are processed server side:
SELECT * FROM Locations
SELECT * FROM Locations WHERE Id='123'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | The ID for the location. | |
| Name | String | The name of the location. | |
| Legacy | Boolean | Whether this is a fulfillment service location. If true, then the location is a fulfillment service location. If false, then the location was created by the merchant and isn't tied to a fulfillment service. | |
| Address1 | String | The first line of the address. | |
| Address2 | String | The second line of the address. | |
| City | String | The city the location is in. | |
| Zip | String | The zip or postal code. | |
| Province | String | The province the location is in. | |
| Country | String | The country the location is in. | |
| Phone | String | The phone number of the location. This value can contain special characters like - and +. | |
| CountryCode | String | The two-letter code (ISO 3166-1 alpha-2 format) corresponding to country the location is in. | |
| CountryName | String | The name of the country the location is in. | |
| CreatedAt | Datetime | The date and time when the location was created. | |
| UpdatedAt | Datetime | The date and time when the location was last updated. | |
| DeletedAt | Datetime | The date and time when the location was deleted. |