Locations
Retrieve information regarding store locations.
View-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operator is '='. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
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. |