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
Base Columns – Only Export
| Column | Allowed Values | Description / Example Value |
|---|---|---|
| Shopify Domain | Text | The shop’s myshopify.com domain.
excelify.myshopify.com |
| Name | Text | The name of the shop.
Excelify Store |
| Created At | Time | The date and time when the shop was created.
2017-10-06 23:03:00 UTC |
| Updated At | Time | The date and time when the shop was last updated.
2019-05-15 14:23:00 UTC |
Other Details – Only Export
| Column | Allowed Values | Description / Example Value |
|---|---|---|
| Domain | Text | The shop’s domain.
Excelify.io
|
| Owner | Text | The username of the shop owner.
John Rock
|
The contact email used for communication between Shopify and the shop owner.
[email protected]
|
||
| Customer Email | The contact email used for communication between the shop owner and the customer.
[email protected]
|
|
| Phone | Phone Number | The contact phone number for the shop.
12387645
|
| Address1 | Text | The shop’s street address.
1 Infinite Loop
|
| Address2 | Text | The optional second line of the shop’s street address.
Suite 100
|
| City | Text | The shop’s city.
Riga
|
| Province | Province Name | The shop’s normalized province or state name.
California
|
| Province Code | Province Code | The two-letter code for the shop’s province or state.
CA
|
| Country | Country Name | The shop’s country.
Latvia
|
| Country Code | Country Code | The two-letter country code corresponding to the shop’s country.
LV
|
| Zip | Zip | The shop’s zip or postal code.
LV4101
|
| Time Zone | Text | The name of the timezone the shop is in.
(GMT+02:00) Europe/Riga"
|
| Latitude | Number | The latitude of the shop’s location.
45.427408
|
| Longitude | Number | The longitude of the shop’s location.
-75.68903
|
| Primary Locale | Text | The shop’s primary locale, as configured in the language settings of the shop’s theme.
en
|
| Currency | Currency | The three-letter code (ISO 4217 format) for the shop’s default currency.
EUR
|
| Enabled Presentment Currencies | Currency | 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 |
|
Whether applicable taxes are included in product prices.
TRUE
|
| Tax Shipping |
|
Whether taxes are charged for shipping.
FALSE
|
| County Taxes |
|
Whether the shop is applying taxes on a per-county basis. Only applicable to shops based in the US.
FALSE
|
| Money Format | Money Format | A string representing the way currency is formatted when the currency isn’t specified.
€{{amount_with_comma_separator}}
|
| Money Email Format | Money Format | 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 | Money Format | A string representing the way currency is formatted when the currency is specified.
€{{amount_with_comma_separator}} EUR
|
| Money With Currency Email Format | Money Format | A string representing the way currency is formatted in email notifications when the currency is specified.
€{{amount_with_comma_separator}} EUR
|
| Checkout API Supported |
|
Whether the shop is capable of accepting payments directly through the Checkout API.
TRUE
|
| Shopify Plan | Shopify Plan Name | The display name of the Shopify plan the shop is on.
trial
|
| Force SSL |
|
Whether the shop forces requests made to its resources to be made over SSL using the HTTPS protocol.
TRUE
|
| Eligible For Card Reader Giveaway |
|
Whether the shop is eligible to receive a free credit card reader from Shopify.
FALSE
|
| Eligible For Payments |
|
Whether the shop is eligible to use Shopify Payments.
TRUE
|
| Requires Extra Payments Agreement |
|
Whether the shop requires an extra Shopify Payments agreement.
FALSE
|
| Setup Required |
|
Whether the shop has any outstanding setup steps or not.
FALSE
|
| Has Discounts |
|
Whether any active discounts exist for the shop.
TRUE
|
| Has Gift Cards |
|
Whether any active gift cards exist for the shop.
FALSE
|
| Has StoreFront |
|
Whether the shop has an online storefront.
TRUE
|
| MultiLocation Enabled |
|
Whether the shop has enabled multiple locations.
TRUE
|
| Password Enabled |
|
Whether the password protection page is enabled on the online storefront.
FALSE
|
| Pre-Launch Enabled |
|
Whether the pre-launch page is enabled on the online storefront.
FALSE
|
| Google Apps Domain | Text | The GSuite URL for the store, if applicable.
|
| Google Apps Login Enabled |
|
Whether the GSuite login is enabled. Shops with this feature will be able to log in through the GSuite login page.
FALSE
|
| Source | Text | The handle of the partner account that referred the merchant to Shopify, if applicable.
excelify
|
| Weight Unit | Weight Unit | 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.
