See what each field/column from our “Shop” template means including possible allowed values and examples.
In “Shop” sheet you can only import shop level Metafields. All other Shop fields are exported only.
Excel Sheet Name
Shop
To tell the app that you are importing Shop detail metafields you need:
- If using CSV file then the file name needs to contain the word “Shop”, for example, “my-shopify-shop-data.csv”
- If using XLSX file then the sheet/tab name in the file needs to be “Shop”. The file name for the XLSX file does not matter.
Columns Available For Export
Basic Columns – Only Export
Column | Description / Example Value |
---|---|
Shopify Domain
Exported only |
The shop’s myshopify.com domain.
excelify.myshopify.com |
Name
Exported only |
The name of the shop.
Excelify Store |
Created At
Exported only |
The date and time when the shop was created.
2017-10-06 23:03:00 UTC |
Updated At
Exported only |
The date and time when the shop was last updated.
2019-05-15 14:23:00 UTC |
Other Details – Only Export
<tr”>
Exported only
A string representing the way currency is formatted when the currency isn’t specified.
€{{amount_with_comma_separator}}
Column | Description / Example Value |
---|---|
Domain
Exported only |
The shop’s domain.
Excelify.io
|
Owner
Exported only |
The username of the shop owner.
John Rock
|
Email
Exported only |
The contact email used for communication between Shopify and the shop owner.
[email protected]
|
Customer Email
Exported only |
The contact email used for communication between the shop owner and the customer.
[email protected]
|
Phone
Exported only |
The contact phone number for the shop.
12387645
|
Address1
Exported only |
The shop’s street address.
1 Infinite Loop
|
Address2
Exported only |
The optional second line of the shop’s street address.
Suite 100
|
City
Exported only |
The shop’s city.
Riga
|
Province
Exported only |
The shop’s normalized province or state name.
California
|
Province Code
Exported only |
The two-letter code for the shop’s province or state.
CA
|
Country
Exported only |
The shop’s country.
Latvia
|
Country Code
Exported only |
The two-letter country code corresponding to the shop’s country.
View a list of Shopify Country and Province codes here. LV
|
Zip
Exported only |
The shop’s zip or postal code.
LV4101
|
Time Zone
Exported only |
The name of the timezone the shop is in.
(GMT+02:00) Europe/Riga"
|
Latitude
Exported only |
The latitude of the shop’s location.
45.427408
|
Longitude
Exported only |
The longitude of the shop’s location.
-75.68903
|
Primary Locale
Exported only |
The shop’s primary locale, as configured in the language settings of the shop’s theme.
en
|
Currency
Exported only |
The three-letter code (ISO 4217 format) for the shop’s default currency.
EUR
|
Enabled Presentment Currencies
Exported only |
A list of enabled currencies (ISO 4217 format) that the shop accepts. Merchants can enable currencies from their Shopify Payments settings in the Shopify admin.
EUR, USD
|
Taxes Included
Exported only |
Whether applicable taxes are included in product prices.
TRUE
|
Tax Shipping
Exported only |
Whether taxes are charged for shipping.
FALSE
|
County Taxes
Exported only |
Whether the shop is applying taxes on a per-county basis. Only applicable to shops based in the US.
FALSE
|
Money Email Format
Exported only |
A string representing the way currency is formatted in email notifications when the currency isn’t specified.
€{{amount_with_comma_separator}}
|
Money With Currency Format
Exported only |
A string representing the way currency is formatted when the currency is specified.
€{{amount_with_comma_separator}} EUR
|
Money With Currency Email Format
Exported only |
A string representing the way currency is formatted in email notifications when the currency is specified.
€{{amount_with_comma_separator}} EUR
|
Checkout API Supported
Exported only |
Whether the shop is capable of accepting payments directly through the Checkout API.
TRUE
|
Shopify Plan
Exported only |
The display name of the Shopify plan the shop is on.
trial
|
Force SSL
Exported only |
Whether the shop forces requests made to its resources to be made over SSL using the HTTPS protocol.
TRUE
|
Eligible For Card Reader Giveaway
Exported only |
Whether the shop is eligible to receive a free credit card reader from Shopify.
FALSE
|
Eligible For Payments
Exported only |
Whether the shop is eligible to use Shopify Payments.
TRUE
|
Requires Extra Payments Agreement
Exported only |
Whether the shop requires an extra Shopify Payments agreement.
FALSE
|
Setup Required
Exported only |
Whether the shop has any outstanding setup steps or not.
FALSE
|
Has Discounts
Exported only |
Whether any active discounts exist for the shop.
TRUE
|
Has Gift Cards
Exported only |
Whether any active gift cards exist for the shop.
FALSE
|
Has StoreFront
Exported only |
Whether the shop has an online storefront.
TRUE
|
MultiLocation Enabled
Exported only |
Whether the shop has enabled multiple locations.
TRUE
|
Password Enabled
Exported only |
Whether the password protection page is enabled on the online storefront.
FALSE
|
Pre-Launch Enabled
Exported only |
Whether the pre-launch page is enabled on the online storefront.
FALSE
|
Google Apps Domain
Exported only |
The GSuite URL for the store, if applicable.
|
Google Apps Login Enabled
Exported only |
Whether the GSuite login is enabled. Shops with this feature will be able to log in through the GSuite login page.
FALSE
|
Source
Exported only |
The handle of the partner account that referred the merchant to Shopify, if applicable.
excelify
|
Weight Unit
Exported only |
The default unit of weight measurement for the shop.
lb
|
Metafields
The column name for metafield starts with “ Metafield: “, followed by the namespace.name
For example:
- The metafield with name “information” in the global namespace should be called “Metafield: information”.
- The metafield with name “description” in the “details” namespace should be called “Metafield: details.description”.
Read the more detailed documentation on Metafields page or look into our tutorial on how to manage shop Metafields.