Shop
Displays overall shop metadata, such as store name, plan type, contact info, and settings.
View-Specific Information
Select
The connector processes all filters client-side within the connector. The following query is the only one processed server-side:
SELECT * FROM Shop
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the shop. | |
| Name | String | The display name of the shop as defined by the merchant. | |
| OwnerName | String | The name of the shop owner registered with Shopify. | |
| RichTextEditorUrl | String | The URL for the rich text editor used to edit content, optimized for mobile compatibility. | |
| Description | String | The shop's meta description, displayed in search engine results for SEO visibility. | |
| String | The shop owner's private contact email address used by Shopify for administrative communication. | ||
| Url | String | The main URL of the shop's online storefront. | |
| ContactEmail | String | The public-facing customer contact email used for general inquiries or support. | |
| CurrencyCode | String | The three-letter ISO currency code representing the shop's default selling currency (for example, USD or CAD). | |
| CustomerAccounts | String | Specifies whether customer accounts are required, optional, or disabled in the store settings. | |
| IanaTimezone | String | The shop's time zone, formatted according to the IANA standard (for example, America/New_York). | |
| MyshopifyDomain | String | The default '.myshopify.com' domain assigned to the shop by Shopify. | |
| PublicationsCount | Int | The total number of active publications available for the shop. | |
| PublicationsCountPrecision | String | Indicates whether the publications count value is exact or estimated. | |
| SetupRequired | Bool | Indicates whether the shop has pending setup or configuration steps to complete. | |
| TaxShipping | Bool | Specifies whether shipping charges are taxable for the shop's orders. | |
| TaxesIncluded | Bool | Indicates whether product prices displayed in the shop include applicable taxes. | |
| TimezoneAbbreviation | String | A short abbreviation for the shop's local time zone (for example, EST or PST). | |
| TimezoneOffset | String | The shop's time zone offset relative to UTC, expressed as a string (for example, -05:00). | |
| UnitSystem | String | Specifies whether the shop uses the metric or imperial system for measurements. | |
| WeightUnit | String | The unit of weight used for product listings and shipping calculations (for example, g or lb). | |
| CheckoutApiSupported | Bool | Indicates whether the shop supports checkout operations via the Checkout API. | |
| EnabledPresentmentCurrencies | String | A list of enabled currencies for displaying localized prices in different regions. | |
| ShipsToCountries | String | A list of countries where the shop can fulfill and ship orders. | |
| TimezoneOffsetMinutes | Int | The shop's UTC offset value expressed in minutes. | |
| TransactionalSmsDisabled | Bool | Indicates whether Shopify transactional SMS notifications are disabled for this shop. | |
| OrderNumberFormatPrefix | String | A custom prefix applied to all order numbers, useful for branding or identification. | |
| OrderNumberFormatSuffix | String | A custom suffix applied to all order numbers, useful for internal tracking or formatting. | |
| BillingAddressId | String | The unique identifier for the shop's billing address record. | |
| BillingAddressCoordinatesValidated | Bool | Indicates whether the latitude and longitude coordinates of the billing address are verified. | |
| BillingAddressAddress1 | String | The first line of the shop's billing address, typically the street address or PO Box. | |
| BillingAddressAddress2 | String | The second line of the shop's billing address, often an apartment, suite, or unit number. | |
| BillingAddressCity | String | The city, district, or town associated with the billing address. | |
| BillingAddressCompany | String | The company or organization name associated with the billing address. | |
| BillingAddressCountry | String | The full country name of the billing address. | |
| BillingAddressLatitude | Double | The latitude coordinate for the billing address. | |
| BillingAddressLongitude | Double | The longitude coordinate for the billing address. | |
| BillingAddressPhone | String | The phone number associated with the billing address, formatted in E.164 standard (for example, +16135551111). | |
| BillingAddressProvince | String | The province, state, or region associated with the billing address. | |
| BillingAddressZip | String | The postal or ZIP code of the billing address. | |
| BillingAddressFormattedArea | String | A comma-separated list combining city, province, and country for display formatting. | |
| BillingAddressProvinceCode | String | The two-letter code representing the province or state (for example, ON). | |
| BillingAddressCountryCodeV2 | String | The two-letter ISO code for the billing country (for example, US). | |
| CountriesInShippingZonesCountryCodes | String | A list of all country codes included across all shipping zones configured for the shop. | |
| CountriesInShippingZonesIncludeRestOfWorld | Bool | Indicates whether a 'Rest of World' zone has been defined in shipping settings. | |
| CurrencyFormatsMoneyFormat | String | HTML display format for money values without a currency symbol. | |
| CurrencyFormatsMoneyInEmailsFormat | String | Email display format for money values without a currency symbol. | |
| CurrencyFormatsMoneyWithCurrencyFormat | String | HTML display format for money values with the currency symbol included. | |
| CurrencyFormatsMoneyWithCurrencyInEmailsFormat | String | Email display format for money values with the currency symbol included. | |
| FeaturesInternationalPriceOverrides | Bool | Indicates whether international price overrides can be configured for products. | |
| FeaturesStorefront | Bool | Specifies whether the shop has an active online storefront. | |
| FeaturesGiftCards | Bool | Indicates whether the shop can issue and manage gift cards. | |
| FeaturesSellsSubscriptions | Bool | Indicates whether the shop currently sells products through subscription plans. | |
| FeaturesEligibleForSubscriptions | Bool | Indicates whether the shop's configuration supports subscription product sales. | |
| FeaturesInternationalPriceRules | Bool | Specifies whether international pricing rules are available for use in this shop. | |
| FeaturesEligibleForSubscriptionMigration | Bool | Indicates whether the shop can migrate to Shopify's subscription management framework. | |
| FeaturesLegacySubscriptionGatewayEnabled | Bool | Specifies whether an older legacy gateway is active for processing subscription payments. | |
| FeaturesPaypalExpressSubscriptionGatewayStatus | String | Describes the configuration status of PayPal Express for handling subscriptions. | |
| PendingOrdersCount | Int | The total number of pending orders awaiting fulfillment or processing. | |
| PendingOrdersPrecision | String | Indicates the accuracy level of the pending order count. | |
| PaymentSettingsSupportedDigitalWallets | String | Lists supported digital wallet options for customer checkout (for example, Apple Pay, Google Pay). | |
| PlanDisplayName | String | The display name of the shop's current billing or subscription plan. | |
| PlanPartnerDevelopment | Bool | Indicates whether the shop is a development store used for testing under a partner account. | |
| PlanShopifyPlus | Bool | Indicates whether the shop is subscribed to the Shopify Plus enterprise plan. | |
| PrimaryDomainId | String | A globally unique identifier for the shop's primary domain. | |
| PrimaryDomainHost | String | The host name portion of the primary domain (for example, example.com). | |
| PrimaryDomainUrl | String | The full HTTPS URL for the shop's primary domain (for example, https://example.com). | |
| PrimaryDomainSslEnabled | Bool | Indicates whether SSL is enabled and active 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 | A list of alternate locale ISO codes associated with the domain (for example, ['en']). | |
| PrimaryDomainLocalizationDefaultLocale | String | The default locale code (for example, 'en') used for the shop's main domain. | |
| PrimaryDomainMarketWebPresenceId | String | The unique identifier for the web presence configuration associated with the primary domain. | |
| PrimaryDomainMarketWebPresenceAlternateLocales | String | A list of alternate locale ISO codes that define language-specific subfolders under the primary domain. | |
| PrimaryDomainMarketWebPresenceDefaultLocale | String | The locale ISO code used as the default for the web presence. | |
| PrimaryDomainMarketWebPresenceDefaultLocaleMarketWebPresencesId | String | The unique identifier linking the default locale to its market web presence configuration. | |
| PrimaryDomainMarketWebPresenceDefaultLocaleName | String | The human-readable name of the default locale (for example, English). | |
| PrimaryDomainMarketWebPresenceDefaultLocalePrimary | Bool | Indicates whether this locale is the primary one for the shop's online store. | |
| PrimaryDomainMarketWebPresenceDefaultLocalePublished | Bool | Indicates whether the default locale is published and visible to customers. | |
| PrimaryDomainMarketWebPresenceSubfolderSuffix | String | The suffix used for language-specific subfolders under the market domain (for example, 'us' in '/en-us'). | |
| ResourceLimitsLocationLimit | Int | The maximum number of physical locations allowed for the shop. | |
| ResourceLimitsMaxProductOptions | Int | The maximum number of product options that can be defined per product. | |
| ResourceLimitsMaxProductVariants | Int | The maximum number of product variants allowed per product. | |
| ResourceLimitsRedirectLimitReached | Bool | Indicates whether the shop has reached the maximum limit of URL redirects allowed by Shopify. |