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.
