Get Excelify now
Get Excelify now

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

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

Example

[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

Example

CA
Country

Exported only

The shop’s country.

Latvia
Country Code

Exported only

The two-letter country code corresponding to the shop’s country.

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 Format

Exported only

A string representing the way currency is formatted when the currency isn’t specified.

€{{amount_with_comma_separator}}
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.