Retrieve information regarding store locations.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operator is '='. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

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	Bool		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.