Shop
Returns the shop resource for the current token, including business and management settings.
View-Specific Information
Select
The server processes all filters client-side within the server. The following query is the only one processed server-side:
SELECT * FROM Shop
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id for the shop. | |
| Name | String | The name of the shop. | |
| OwnerName | String | The name of the account owner for the shop. | |
| RichTextEditorUrl | String | The URL of the rich text editor available for mobile devices. | |
| Description | String | The shop's meta description, used in search engine results. | |
| String | The shop owner's email address. Shopify uses this address to communicate with the shop owner. | ||
| Url | String | The URL of the shop's online store. | |
| ContactEmail | String | The public-facing contact email address for the shop. Customers use this address to communicate with the shop owner. | |
| CurrencyCode | String | The three-letter currency code the shop sells in. | |
| CustomerAccounts | String | Specifies whether customer accounts are required, optional, or disabled for the shop. | |
| IanaTimezone | String | The shop's time zone as defined by the IANA. | |
| MyshopifyDomain | String | The shop's myshopify.com domain name. | |
| PublicationsCount | Int | The number of publications associated with the shop. | |
| PublicationsCountPrecision | String | The precision of the publication count, or how exact the value is. | |
| SetupRequired | Bool | Indicates whether the shop has outstanding setup steps. | |
| TaxShipping | Bool | Indicates whether the shop charges taxes on shipping. | |
| TaxesIncluded | Bool | Indicates whether product prices include applicable taxes. | |
| TimezoneAbbreviation | String | The abbreviation of the shop's time zone. | |
| TimezoneOffset | String | The shop's time zone offset. | |
| UnitSystem | String | The unit system for weights and measures used in the shop. | |
| WeightUnit | String | The primary unit of weight for products and shipping. | |
| CheckoutApiSupported | Bool | Indicates whether the shop supports checkouts via the Checkout API. | |
| EnabledPresentmentCurrencies | String | The presentment currencies enabled for the shop (for example, 'USD', 'EUR'). | |
| ShipsToCountries | String | A list of countries the shop ships to. | |
| TimezoneOffsetMinutes | Int | The shop's time zone offset expressed in minutes. | |
| TransactionalSmsDisabled | Bool | Indicates whether transactional SMS messages from Shopify are disabled for the shop. | |
| OrderNumberFormatPrefix | String | The prefix that appears before order numbers. | |
| OrderNumberFormatSuffix | String | The suffix that appears after order numbers. | |
| BillingAddressId | String | A globally unique Id for the billing address. | |
| BillingAddressCoordinatesValidated | Bool | Indicates whether the billing address coordinates are valid. | |
| BillingAddressAddress1 | String | The first line of the billing address, typically the street address or PO Box number. | |
| BillingAddressAddress2 | String | The second line of the billing address, typically the apartment, suite, or unit number. | |
| BillingAddressCity | String | The city, district, village, or town of the billing address. | |
| BillingAddressCompany | String | The company or organization associated with the billing address. | |
| BillingAddressCountry | String | The country of the billing address. | |
| BillingAddressLatitude | Double | The latitude coordinate of the billing address. | |
| BillingAddressLongitude | Double | The longitude coordinate of the billing address. | |
| BillingAddressPhone | String | A phone number associated with the billing address, formatted using the E.164 standard (for example, +16135551111). | |
| BillingAddressProvince | String | The province, state, or district of the billing address. | |
| BillingAddressZip | String | The postal or zip code of the billing address. | |
| BillingAddressFormattedArea | String | A comma-separated string of the city, province, and country for the billing address. | |
| BillingAddressProvinceCode | String | The two-letter province or state code of the billing address (for example, ON). | |
| BillingAddressCountryCodeV2 | String | The two-letter country code of the billing address (for example, US). | |
| CountriesInShippingZonesCountryCodes | String | The list of all countries across the shop's shipping zones. | |
| CountriesInShippingZonesIncludeRestOfWorld | Bool | Indicates whether 'Rest of World' is included in the shipping zones. | |
| CurrencyFormatsMoneyFormat | String | Money without currency formatting, used in HTML. | |
| CurrencyFormatsMoneyInEmailsFormat | String | Money without currency formatting, used in emails. | |
| CurrencyFormatsMoneyWithCurrencyFormat | String | Money with currency formatting, used in HTML. | |
| CurrencyFormatsMoneyWithCurrencyInEmailsFormat | String | Money with currency formatting, used in emails. | |
| FeaturesInternationalPriceOverrides | Bool | Indicates whether the shop can enable international price overrides. | |
| FeaturesStorefront | Bool | Indicates whether the shop has an online storefront. | |
| FeaturesGiftCards | Bool | Indicates whether the shop can create gift cards. | |
| FeaturesSellsSubscriptions | Bool | Indicates whether the shop has ever sold subscription products. | |
| FeaturesEligibleForSubscriptions | Bool | Indicates whether the shop is configured to sell subscriptions. | |
| FeaturesInternationalPriceRules | Bool | Indicates whether the shop can enable international price rules. | |
| FeaturesEligibleForSubscriptionMigration | Bool | Indicates whether the shop can be migrated to Shopify's subscription system. | |
| FeaturesLegacySubscriptionGatewayEnabled | Bool | Indicates whether the shop has enabled a legacy subscription gateway for older subscriptions. | |
| FeaturesPaypalExpressSubscriptionGatewayStatus | String | The configuration status for selling subscriptions with PayPal Express. | |
| PendingOrdersCount | Int | The number of pending orders for the shop. | |
| PendingOrdersPrecision | String | The precision of the pending orders count, or how exact the value is. | |
| PaymentSettingsSupportedDigitalWallets | String | A list of digital wallets supported by the shop. | |
| PlanDisplayName | String | The name of the shop's billing plan. | |
| PlanPartnerDevelopment | Bool | Indicates whether the shop is a partner development shop for testing purposes. | |
| PlanShopifyPlus | Bool | Indicates whether the shop has a Shopify Plus subscription. | |
| PrimaryDomainId | String | A globally unique Id for the primary domain. | |
| PrimaryDomainHost | String | The host name of the shop's primary domain (for example, example.com). | |
| PrimaryDomainUrl | String | The URL of the shop's primary domain (for example, https://example.com). | |
| PrimaryDomainSslEnabled | Bool | Indicates whether SSL is enabled on the primary domain. | |
| PrimaryDomainLocalizationCountry | String | The ISO country code assigned to the primary domain (for example, CA or * for 'Rest of World'). | |
| PrimaryDomainLocalizationAlternateLocales | String | The ISO codes for alternate locales available on the primary domain (for example, ['en']). | |
| PrimaryDomainLocalizationDefaultLocale | String | The ISO code for the default locale of the primary domain (for example, en). | |
| PrimaryDomainMarketWebPresenceId | String | A globally unique Id for the market web presence of the primary domain. | |
| PrimaryDomainMarketWebPresenceAlternateLocales | String | The ISO codes for alternate locales used in the primary domain's market web presence. These are exposed as language-specific subfolders. | |
| PrimaryDomainMarketWebPresenceDefaultLocale | String | The default locale ISO code of the market web presence for the primary domain. | |
| PrimaryDomainMarketWebPresenceDefaultLocaleMarketWebPresencesId | String | The Id of the market web presences that use the default locale. | |
| PrimaryDomainMarketWebPresenceDefaultLocaleName | String | The human-readable name of the default locale for the primary domain. | |
| PrimaryDomainMarketWebPresenceDefaultLocalePrimary | Bool | Indicates whether the default locale is the primary locale for the shop. | |
| PrimaryDomainMarketWebPresenceDefaultLocalePublished | Bool | Indicates whether the default locale is visible to buyers. | |
| PrimaryDomainMarketWebPresenceSubfolderSuffix | String | The market-specific subfolder suffix defined by the web presence (for example, 'us' in '/en-us'). Null if 'domain' is not null. | |
| ResourceLimitsLocationLimit | Int | The maximum number of locations allowed for the shop. | |
| ResourceLimitsMaxProductOptions | Int | The maximum number of product options allowed per product. | |
| ResourceLimitsMaxProductVariants | Int | The maximum number of variants allowed per product. | |
| ResourceLimitsRedirectLimitReached | Bool | Indicates whether the shop has reached its redirect limit for resources. |