JDBC Driver for Shopify

Build 23.0.8839

Shop

Contains general settings and information about the shop.

View-Specific Information

Select

The driver processes the WHERE clause client-side within the driver for all queries to this table. For example, the following query is the only query processed server-side:
SELECT * FROM Shop

Columns

Name Type References Description
Id [KEY] Long A unique numeric identifier for the shop.
Name String The name of the shop.
Email String The contact email address for the shop.
Address1 String The shop's street address.
Address2 String The shop's additional street address (apt, suite, etc.).
City String The city in which the shop is located.
Country String The shop's country (by default equal to the two-letter country code).
CountryCode String The two-letter country code corresponding to the shop's country.
CountryName String The shop's normalized country name.
CustomerEmail String The customer's email.
Currency String The three-letter code for the currency that the shop accepts.
Domain String The shop's domain.
GoogleAppsDomain String The URL of the domain if the shop has a google apps domain.
GoogleAppsLoginEnabled String Indicated whether the shop has google apps login enabled.
Latitude Double Geographic coordinate specifying the north/south location of a shop.
Longitude Double Geographic coordinate specifying the east/west location of a shop.
MoneyFormat String A string representing the way currency is formatted when the currency isn't specified.
MoneyWithCurrencyFormat String A string representing the way currency is formatted when the currency is specified.
WeightUnit String A string representing the default unit of weight measurement for the shop.
MyshopifyDomain String The shop's 'myshopify.com' domain.
PlanName String The name of the Shopify plan the shop is on.
HasDiscounts Bool Indicates if any active discounts exist for the shop.
HasGiftCards Bool Indicates if any active gift cards exist for the shop.
PlanDisplayName String The display name of the Shopify plan the shop is on.
PasswordEnabled Bool Indicates whether the Storefront password protection is enabled.
Phone String The contact phone number for the shop.
PrimaryLocale String The shop's primary locale.
Province String The shop's normalized province or state name.
ProvinceCode String The two-letter code for the shop's province or state.
ShopOwner String The username of the shop owner.
Source String Source
TaxShipping Bool Specifies whether or not taxes were charged for shipping.
TaxesIncluding Bool The setting for whether applicable taxes are included in product prices.
CountryTaxes Bool The setting for whether the shop is applying taxes on a per-county basis or not (US-only).
Timezone String The name of the timezone the shop is in.
IANATimezone String The named timezone assigned by the IANA.
Zip String The zip or postal code of the shop's address.
HasStorefront Bool Indicates whether the shop has web-based storefront or not.
CreatedAt Datetime The date and time when the shop was created.
UpdatedAt Datetime The date and time when the shop was last updated.
SetupRequired Bool Indicates whether the shop has any outstanding setup steps or not.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839