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

When importing a file, to tell the app that you are importing Shop entity, you need to ensure that the sheet/tab name is set to “Shop” or “Shops”.

For example:

If using a CSV file then the file name can be “my-shopify-shop.csv”
If using an XLSX file then the sheet/tab name would be set to “Shop”. The file name for the XLSX file does not matter.

Even if the sheet/tab name is not set correctly, you will be able to manually change and set the entity you are importing after uploading file in the app.

See more on the Matrixify app import process and import user interface.

Need a quick start?

Download Shop Metafields Demo file

See Tutorials about Shop

Columns Available For Export

Basic Columns – Only Export

Column	Description / Example Value
Shopify Domain *Export only*	The shop’s myshopify.com domain. Example cool-store.myshopify.com
Name *Export only*	The name of the shop. Example CoolStore
Created At *Export only*	The date and time when the shop was created. Example 2018-12-17 18:20:07 +0200
Updated At *Export only*	The date and time when the shop was last updated. Example 2018-12-17 18:20:07 +0200

Column

Description / Example Value

Shopify Domain

Export only

The shop’s myshopify.com domain.

Example

cool-store.myshopify.com

Name

Export only

The name of the shop.

Example

CoolStore

Created At

Export only

The date and time when the shop was created.

Example

2018-12-17 18:20:07 +0200

Updated At

Export only

The date and time when the shop was last updated.

Example

2018-12-17 18:20:07 +0200

Other Details – Only Export

Column	Description / Example Value
Domain *Export only*	The shop’s domain. Example Coolstore.io
Owner *Export only*	The username of the shop owner. Example John Rock
Email *Export only*	The contact email used for communication between Shopify and the shop owner. Example [email protected]
Customer Email *Export only*	The contact email used for communication between the shop owner and the customer. Example [email protected]
Phone *Export only*	The contact phone number for the shop. Example 12387645
Address1 *Export only*	The shop’s street address. Example 1 Infinite Loop
Address2 *Export only*	The optional second line of the shop’s street address. Example Suite 100
City *Export only*	The shop’s city. Example Riga
Province *Export only*	The shop’s normalized province or state name. Example California
Province Code *Export only*	The two-letter code for the shop’s province or state. Example CA
Country *Export only*	The shop’s country. Example Latvia
Country Code *Export 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 *Export only*	The shop’s zip or postal code. Example LV4101
Time Zone *Export only*	The name of the timezone the shop is in. Example (GMT+02:00) Europe/Riga"
Latitude *Export only*	The latitude of the shop’s location. Example 45.427408
Longitude *Export only*	The longitude of the shop’s location. Example -75.68903
Currency *Export only*	The three-letter code (ISO 4217 format) for the shop’s default currency. Example EUR
Enabled Presentment Currencies *Export 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 *Export only*	Whether applicable taxes are included in product prices. Example TRUE
Tax Shipping *Export only*	Whether taxes are charged for shipping. Example FALSE
Money Format *Exported only*	A string representing the way currency is formatted when the currency isn’t specified. Example €{{amount_with_comma_separator}}
Money Email Format *Export 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 *Export 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 *Export 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 *Export only*	Whether the shop is capable of accepting payments directly through the Checkout API. Example TRUE
Shopify Plan *Export only*	The display name of the Shopify plan the shop is on. Example trial
Setup Required *Export only*	Whether the shop has any outstanding setup steps or not. Example FALSE
Weight Unit *Export only*	The default unit of weight measurement for the shop. Example lb

Column

Description / Example Value

Domain

Export only

The shop’s domain.

Example

Coolstore.io

Owner

Export only

The username of the shop owner.

Example

John Rock

Email

Export only

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

Example

[email protected]

Customer Email

Export only

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

Example

[email protected]

Phone

Export only

The contact phone number for the shop.

Example

12387645

Address1

Export only

The shop’s street address.

Example

1 Infinite Loop

Address2

Export only

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

Example

Suite 100

City

Export only

The shop’s city.

Example

Riga

Province

Export only

The shop’s normalized province or state name.

Example

California

Province Code

Export only

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

Example

CA

Country

Export only

The shop’s country.

Example

Latvia

Country Code

Export 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

Export only

The shop’s zip or postal code.

Example

LV4101

Time Zone

Export only

The name of the timezone the shop is in.

Example

(GMT+02:00) Europe/Riga"

Latitude

Export only

The latitude of the shop’s location.

Example

45.427408

Longitude

Export only

The longitude of the shop’s location.

Example

-75.68903

Currency

Export only

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

Example

EUR

Enabled Presentment Currencies

Export 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

Export only

Whether applicable taxes are included in product prices.

Example

TRUE

Tax Shipping

Export only

Whether taxes are charged for shipping.

Example

FALSE

Money Format

Exported only

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

Example

€{{amount_with_comma_separator}}

Money Email Format

Export 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

Export 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

Export 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

Export only

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

Example

TRUE

Shopify Plan

Export only

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

Example

trial

Setup Required

Export only

Whether the shop has any outstanding setup steps or not.

Example

FALSE

Weight Unit

Export 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

Need a quick start?

Columns Available For Export

Basic Columns – Only Export

Example

Example

Example

Example

Other Details – Only Export

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Metafields

Start managing your Shopify data today!