Shop

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. Example excelify.myshopify.com
Name *Exported only*	The name of the shop. Example Excelify Store
Created At *Exported only*	The date and time when the shop was created. Example 2017-10-06 23:03:00 UTC
Updated At *Exported only*	The date and time when the shop was last updated. Example 2019-05-15 14:23:00 UTC

Column

Description / Example Value

Shopify Domain

Exported only

The shop’s myshopify.com domain.

Example

excelify.myshopify.com

Name

Exported only

The name of the shop.

Example

Excelify Store

Created At

Exported only

The date and time when the shop was created.

Example

2017-10-06 23:03:00 UTC

Updated At

Exported only

The date and time when the shop was last updated.

Example

2019-05-15 14:23:00 UTC

Other Details – Only Export

<tr”>

Money Format

Exported only

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

Example

€{{amount_with_comma_separator}}

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

Column

Description / Example Value

Domain

Exported only

The shop’s domain.

Example

Excelify.io

Owner

Exported only

The username of the shop owner.

Example

John Rock

Email

Exported only

The contact email used for communication between Shopify and the shop owner.

Example

[email protected]

Customer Email

Exported only

The contact email used for communication between the shop owner and the customer.

Example

[email protected]

Phone

Exported only

The contact phone number for the shop.

Example

12387645

Address1

Exported only

The shop’s street address.

Example

1 Infinite Loop

Address2

Exported only

The optional second line of the shop’s street address.

Example

Suite 100

City

Exported only

The shop’s city.

Example

Riga

Province

Exported only

The shop’s normalized province or state name.

Example

California

Province Code

Exported only

The two-letter code for the shop’s province or state.

Example

CA

Country

Exported only

The shop’s country.

Example

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.

Example

LV

Zip

Exported only

The shop’s zip or postal code.

Example

LV4101

Time Zone

Exported only

The name of the timezone the shop is in.

Example

(GMT+02:00) Europe/Riga"

Latitude

Exported only

The latitude of the shop’s location.

Example

45.427408

Longitude

Exported only

The longitude of the shop’s location.

Example

-75.68903

Primary Locale

Exported only

The shop’s primary locale, as configured in the language settings of the shop’s theme.

Example

en

Currency

Exported only

The three-letter code (ISO 4217 format) for the shop’s default currency.

Example

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.

Example

EUR, USD

Taxes Included

Exported only

Whether applicable taxes are included in product prices.

Example

TRUE

Tax Shipping

Exported only

Whether taxes are charged for shipping.

Example

FALSE

County Taxes

Exported only

Whether the shop is applying taxes on a per-county basis. Only applicable to shops based in the US.

Example

FALSE

Money Email Format

Exported only

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

Example

€{{amount_with_comma_separator}}

Money With Currency Format

Exported only

A string representing the way currency is formatted when the currency is specified.

Example

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

Example

€{{amount_with_comma_separator}} EUR

Checkout API Supported

Exported only

Whether the shop is capable of accepting payments directly through the Checkout API.

Example

TRUE

Shopify Plan

Exported only

The display name of the Shopify plan the shop is on.

Example

trial

Force SSL

Exported only

Whether the shop forces requests made to its resources to be made over SSL using the HTTPS protocol.

Example

TRUE

Eligible For Card Reader Giveaway

Exported only

Whether the shop is eligible to receive a free credit card reader from Shopify.

Example

FALSE

Eligible For Payments

Exported only

Whether the shop is eligible to use Shopify Payments.

Example

TRUE

Requires Extra Payments Agreement

Exported only

Whether the shop requires an extra Shopify Payments agreement.

Example

FALSE

Setup Required

Exported only

Whether the shop has any outstanding setup steps or not.

Example

FALSE

Has Discounts

Exported only

Whether any active discounts exist for the shop.

Example

TRUE

Has Gift Cards

Exported only

Whether any active gift cards exist for the shop.

Example

FALSE

Has StoreFront

Exported only

Whether the shop has an online storefront.

Example

TRUE

MultiLocation Enabled

Exported only

Whether the shop has enabled multiple locations.

Example

TRUE

Password Enabled

Exported only

Whether the password protection page is enabled on the online storefront.

Example

FALSE

Pre-Launch Enabled

Exported only

Whether the pre-launch page is enabled on the online storefront.

Example

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.

Example

FALSE

Source

Exported only

The handle of the partner account that referred the merchant to Shopify, if applicable.

Example

excelify

Weight Unit

Exported only

The default unit of weight measurement for the shop.

Example

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.

Excel Sheet Name

Columns Available For Export

Basic Columns – Only Export

Other Details – Only Export

Metafields

Start managing your Shopify data today!