Excel Sheet Name

Shop

Columns Available For Export

Base Columns – Only Export

ColumnAllowed ValuesDescription / Example Value
Shopify DomainTextThe shop’s myshopify.com domain.

excelify.myshopify.com
NameTextThe name of the shop.

Excelify Store
Created AtTimeThe date and time when the shop was created.

2017-10-06 23:03:00 UTC
Updated AtTimeThe date and time when the shop was last updated.

2019-05-15 14:23:00 UTC

Other Details – Only Export

ColumnAllowed ValuesDescription / Example Value
DomainTextThe shop’s domain.

Excelify.io
OwnerTextThe username of the shop owner.

John Rock
EmailEmailThe contact email used for communication between Shopify and the shop owner.

[email protected]
Customer EmailEmailThe contact email used for communication between the shop owner and the customer.

[email protected]
PhonePhone NumberThe contact phone number for the shop.

12387645
Address1TextThe shop’s street address.

1 Infinite Loop
Address2TextThe optional second line of the shop’s street address.

Suite 100
CityTextThe shop’s city.

Riga
ProvinceProvince NameThe shop’s normalized province or state name.

California
Province CodeProvince CodeThe two-letter code for the shop’s province or state.

CA
CountryCountry NameThe shop’s country.

Latvia
Country CodeCountry CodeThe two-letter country code corresponding to the shop’s country.

LV
ZipZipThe shop’s zip or postal code.

LV4101
Time ZoneTextThe name of the timezone the shop is in.

(GMT+02:00) Europe/Riga"
LatitudeNumberThe latitude of the shop’s location.

45.427408
LongitudeNumberThe longitude of the shop’s location.

-75.68903
Primary LocaleTextThe shop’s primary locale, as configured in the language settings of the shop’s theme.

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

EUR
Enabled Presentment CurrenciesCurrencyA 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
  • TRUE
  • FALSE
Whether applicable taxes are included in product prices.

TRUE
Tax Shipping
  • TRUE
  • FALSE
Whether taxes are charged for shipping.

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

FALSE
Money FormatMoney FormatA string representing the way currency is formatted when the currency isn’t specified.

€{{amount_with_comma_separator}}
Money Email FormatMoney FormatA string representing the way currency is formatted in email notifications when the currency isn’t specified.

€{{amount_with_comma_separator}}
Money With Currency FormatMoney FormatA string representing the way currency is formatted when the currency is specified.

€{{amount_with_comma_separator}} EUR
Money With Currency Email FormatMoney FormatA string representing the way currency is formatted in email notifications when the currency is specified.

€{{amount_with_comma_separator}} EUR
Checkout API Supported
  • TRUE
  • FALSE
Whether the shop is capable of accepting payments directly through the Checkout API.

TRUE
Shopify PlanShopify Plan NameThe display name of the Shopify plan the shop is on.

trial
Force SSL
  • TRUE
  • FALSE
Whether the shop forces requests made to its resources to be made over SSL using the HTTPS protocol.

TRUE
Eligible For Card Reader Giveaway
  • TRUE
  • FALSE
Whether the shop is eligible to receive a free credit card reader from Shopify.

FALSE
Eligible For Payments
  • TRUE
  • FALSE
Whether the shop is eligible to use Shopify Payments.

TRUE
Requires Extra Payments Agreement
  • TRUE
  • FALSE
Whether the shop requires an extra Shopify Payments agreement.

FALSE
Setup Required
  • TRUE
  • FALSE
Whether the shop has any outstanding setup steps or not.

FALSE
Has Discounts
  • TRUE
  • FALSE
Whether any active discounts exist for the shop.

TRUE
Has Gift Cards
  • TRUE
  • FALSE
Whether any active gift cards exist for the shop.

FALSE
Has StoreFront
  • TRUE
  • FALSE
Whether the shop has an online storefront.

TRUE
MultiLocation Enabled
  • TRUE
  • FALSE
Whether the shop has enabled multiple locations.

TRUE
Password Enabled
  • TRUE
  • FALSE
Whether the password protection page is enabled on the online storefront.

FALSE
Pre-Launch Enabled
  • TRUE
  • FALSE
Whether the pre-launch page is enabled on the online storefront.

FALSE
Google Apps DomainTextThe GSuite URL for the store, if applicable.

 
Google Apps Login Enabled
  • TRUE
  • FALSE
Whether the GSuite login is enabled. Shops with this feature will be able to log in through the GSuite login page.

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

excelify
Weight UnitWeight UnitThe 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.