JDBC Driver for Shopify

Build 25.0.9434

Shop

Returns the shop resource for the current token, including business and management settings.

View-Specific Information

Select

The driver processes all filters client-side within the driver. 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.
Email 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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434