Shop
Exposes shop-level settings and identifiers, such as domain, currency, locale, and plan information.
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | A unique numeric identifier for the shop. | |
| Name | String | The name of the shop as it appears to customers. | |
| String | The primary contact email address for the shop. | ||
| Address1 | String | The first line of the shop's street address. | |
| Address2 | String | An optional second line for additional address details such as an apartment, suite, or unit number. | |
| City | String | The city where the shop is located. | |
| Country | String | The shop's country, represented by the two-letter ISO country code by default. | |
| CountryCode | String | The two-letter ISO 3166-1 alpha-2 country code representing the shop's country. | |
| CountryName | String | The full, normalized name of the country in which the shop operates. | |
| CustomerEmail | String | The default email address used for customer communications. | |
| Currency | String | The three-letter ISO 4217 currency code that represents the shop's base currency. | |
| Domain | String | The primary domain associated with the shop. | |
| GoogleAppsDomain | String | The Google Workspace domain associated with the shop, if applicable. | |
| GoogleAppsLoginEnabled | String | Indicates whether login through Google Workspace is enabled for the shop. | |
| Latitude | Double | The geographic latitude coordinate of the shop's physical address. | |
| Longitude | Double | The geographic longitude coordinate of the shop's physical address. | |
| MoneyFormat | String | The format string used to display monetary values without specifying a currency code. | |
| MoneyWithCurrencyFormat | String | The format string used to display monetary values with a currency code included. | |
| WeightUnit | String | The default unit of weight measurement used by the shop (for example, grams, kilograms, or pounds). | |
| MyshopifyDomain | String | The permanent Shopify-hosted domain for the store, typically in the format '(shop-name).myshopify.com'. | |
| PlanName | String | The internal name of the Shopify subscription plan assigned to the shop. | |
| HasDiscounts | Bool | Indicates whether the shop currently has any active discounts configured. | |
| HasGiftCards | Bool | Indicates whether the shop currently offers gift cards. | |
| PlanDisplayName | String | The user-facing display name of the Shopify subscription plan assigned to the shop. | |
| PasswordEnabled | Bool | Indicates whether password protection is enabled on the online storefront. | |
| Phone | String | The primary contact phone number associated with the shop. | |
| PrimaryLocale | String | The default locale or language code used by the shop. | |
| Province | String | The name of the state or province where the shop is located. | |
| ProvinceCode | String | The two-letter code representing the shop's province or state. | |
| ShopOwner | String | The name or username of the shop owner. | |
| Source | String | The referral source handle identifying the partner or program that referred the merchant to Shopify. | |
| TaxShipping | Bool | Indicates whether taxes are charged on shipping rates. | |
| TaxesIncluding | Bool | Indicates whether product prices in the shop include applicable taxes. | |
| CountryTaxes | Bool | Indicates whether the shop applies tax rules based on specific regions or counties (U.S. only). | |
| Timezone | String | The timezone name used by the shop for order and reporting timestamps. | |
| IANATimezone | String | The standardized timezone identifier assigned by the Internet Assigned Numbers Authority (IANA). | |
| Zip | String | The postal or ZIP code of the shop's address. | |
| HasStorefront | Bool | Indicates whether the shop has an active online storefront. | |
| CreatedAt | Datetime | The date and time when the shop record was created. | |
| UpdatedAt | Datetime | The date and time when the shop record was last updated. | |
| SetupRequired | Bool | Indicates whether the shop still requires any setup steps before it is fully operational. |