Shop
Contains general settings and information about the shop.
View-Specific Information
Select
The adapter processes the WHERE clause client-side within the adapter 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 | Long | A unique numeric identifier for the shop. | |
| Name | String | The name of the shop. | |
| 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 | Boolean | Indicates if any active discounts exist for the shop. | |
| HasGiftCards | Boolean | Indicates if any active gift cards exist for the shop. | |
| PlanDisplayName | String | The display name of the Shopify plan the shop is on. | |
| PasswordEnabled | Boolean | 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 | ||
| ForceSSL | Boolean | Indicates whether the shop forces requests made to its resources to be made over SSL. | |
| TaxShipping | Boolean | Specifies whether or not taxes were charged for shipping. | |
| TaxesIncluding | Boolean | The setting for whether applicable taxes are included in product prices. | |
| CountryTaxes | Boolean | 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 | Boolean | 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 | Boolean | Indicates whether the shop has any outstanding setup steps or not. |