Install
Install
Documentation

Translations

Translations

Bulk Import and Export Shopify multi-language data Translations from Shopify Admin -> Settings -> Languages section.

See what each field/column from our “Translations” template means, including possible allowed values and examples.

Columns marked as “Export Only” cannot be imported/set in Shopify, but can be exported with Matrixify Export.

Excel Sheet Name

Translations

Need a quick start?

Download Translations Demo import file

Columns Available For Export And Import

Basic Columns

Column Description / Example Value
Entity The Shopify resource type that the Translation row belongs to.

Each row in the Translations sheet describes a single translatable field of a single entity. This column tells Matrixify what type of item is being translated.

Mandatory column when importing so that the app can find the correct entity in your Shopify store.

Allowed Values
Product
Collection
Page
Blog
Blog Post
Metaobject
Menu
Shop
Example
Product
Entity ID The Shopify internal ID of the Entity that this Translation row belongs to.

When the Entity is Shop, this column can be left empty – your shop is identified automatically.

Allowed Values

Shopify internal ID

Example
51920047631
Entity Handle The Handle of the entity that this Translation row belongs to. Mandatory when importing Translations.

Allowed Values

Different structure depending on the Entity and Field the Translations belong to:

  • Product:
    • for Variant Metafield: ... Field, the Entity Handle is a combination of Products Handle and Variant Title (Option Values separated by /) as <product_handle>.<variant title> to identify the full variant the metafield belongs to, e.g. natural-honey.250g / Wild raspberry,
    • for Option1 Value Field, the Entity Handle is a combination of Products Handle and Option Value as <product_handle>.<option value>, for example, natural-honey.Wild raspberry,
    • for all other Product Fields, only a Product Handle, e.g. natural-honey.
  • Collection – for all Collection Fields, the Entity Handle is the Collection’s Handle, e.g. cool-looking-tshirts.
  • Page – for all Page Fields, the Entity Handle is the Page Handle, e.g. contact-us.
  • Blog – for all Blog Fields, the Entity Handle is the Blog Handle, e.g. summer-blog.
  • Blog Post – for all Blog Post Fields, the Entity Handle is a combination of Blog Handle and Blog Post Handle as <blog_handle>.<blog_post_handle>, for example, summer-blog.best_shirts_for_summer.
  • Metaobject – for all Metaobject Fields, a combination of Metobject Definition Handle and Metaobject Entry Handle as <definition_handle>.<entry_handle>, e.g., manufacturer.Robert-Jones.
  • Menu:
    • for Title Field, the Entity Handle is the Menu Handle, for example, main-menu.
    • for Menu Item Title Field, the Entity Handle is a dot-separated Menu Item hierarchy as <menu_handle>.<Menu Item Title>, for example, main-menu.Compliance.Refund Policy.
  • Shop: – Entity Handle is empty for all Shop Fields.
Field The specific translatable field of the Entity that the row applies to.
The available Field values depend on the entity type. Mandatory when importing Translations.

Allowed Values

Different possible values depending on the Entity being translated:

  • Product:
    • Title
    • Handle
    • Body HTML
    • Type
    • Option1 Name
    • Option1 Value
    • SEO Title
    • SEO Description
    • Metafield: <namespace.key>
    • Variant Metafield: <namespace.key>
  • Collection:
    • Title
    • Handle
    • Body HTML
    • Image Alt Text
    • SEO Description
    • SEO Title
    • Metafield: <namespace.key>
  • Page:
    • Title
    • Handle
    • Body HTML
    • SEO Description
    • SEO Title
    • Metafield: <namespace.key>
  • Blog:
    • Title
    • Handle
    • SEO Description
    • SEO Title
    • Metafield: <namespace.key>
  • Blog Post:
    • Title
    • Handle
    • Body HTML
    • Summary HTML
    • Image Alt Text
    • SEO Description
    • SEO Title
    • Metafield: <namespace.key>
  • Metaobject:
  • Menu:
    • Title
    • Menu Item Title
  • Shop
    • SEO Description
    • SEO Title
    • Metafield: <namespace.key>
Example
Body HTML
Original Value

Export Only

 The current value of the Field in your store’s base language.
This column is provided as a reference so that you (or your translators) can see the source text side-by-side with each translation. It is ignored on Import – to change the base-language value of an entity, use the corresponding entity sheet (Products, Pages, etc.) instead of the Translations sheet.

Translations

The Translations column group contains a set of three columns for each Language enabled in your Shopify store, except the default Language. The Language code is appended to the end of each column header, for example, Translation Value: lv.

On Import, the Language in the column header can also be written by its name, for example, Translation Value: French.

By default, the Export includes all Languages. To Export only some of them, use the Select ... button under the column group and pick the Languages.

Column Description / Example Value
Translation Value: <Language Code> The translated text for the Language specified in the column header. It applies to all Markets – a translation for a single Market goes in the Market Translations columns.

This is the column you actually edit to translate your store. Leave it empty to remove an existing translation for that Language and Field.

A column for the store’s default Language is ignored on Import. A column with a Language that Shopify does not support fails the Import.

Allowed Values

Text

Example
Naturhonig
Translation Is Outdated: <Language Code>

Export Only

 Shopify flags a Translation as outdated when the base-language value of the Field has changed after the Translation was last saved. The Translation still shows in the storefront, but Shopify warns merchants that it may no longer match the source text.
On export, this column shows TRUE for Translations that Shopify has flagged as outdated, and empty for others – useful for filtering your file down to just the Translations that need a refresh.It cannot be set or imported by a user; Shopify adjusts it automatically.

Possible Values
TRUE
FALSE
Example
TRUE
Translation Updated At: <Language Code>

Export Only

 The date and time when the Translation for this Field and language was last updated in Shopify.
Useful for sorting and auditing – for example, to find all translations that haven’t been touched in a year.

Possible Values

Date & Time

Example
2026-05-22 09:51:41 +0300

Market Translations

The Market Translations column group holds translations for a single Market, for example, a French Product title used only in the North America Market. They are saved in addition to the Translations columns, which apply to all Markets.

There is a set of three columns for each Market and each Language that the Market has. The Market name and the Language code are appended to the end of each column header, for example, Market Translation Value: North America / fr. The store’s default Language is included too, for the Market’s own content in it, for example, Market Translation Value: North America / en.

By default, the Export includes all Markets and Languages. To Export only some of them, use the Select ... button under the column group and pick the Languages and Markets. Do the Export first to see the exact column names for your store.

On Import, the Market is found by its name, ignoring differences in letter case, spacing and punctuation. Columns of a Market that your store does not have are ignored.

Column Description / Example Value
Market Translation Value: <Market Name> / <language code> The translated text for the Market and Language specified in the column header – that Market’s own translation.

Leave it empty to remove the existing translation for that Market, Language and Field. The translation in the Translation Value: <Language Code> column stays as it is.

The Handle and Image Alt Text Fields cannot be translated per Market – the app does not save them and shows a warning.

Allowed Values

Text

Example
Miel naturel
Market Translation Is Outdated: <Market Name> / <language code>
Export Only		 Shopify flags a Translation as outdated when the base-language value of the Field has changed after the Translation was last saved. The Translation still shows in the storefront, but Shopify warns merchants that it may no longer match the source text.
On export, this column shows TRUE for Translations that Shopify has flagged as outdated, and empty for others – useful for filtering your file down to just the Translations that need a refresh.It cannot be set or imported by a user; Shopify adjusts it automatically.

Possible Values
TRUE
FALSE
Example
TRUE
Market Translation Updated At: <Market Name> / <language code>
Export Only		 The date and time when the Translation for this Field and language/market was last updated in Shopify.
Useful for sorting and auditing – for example, to find all translations that haven’t been touched in a year.

Possible Values

Date & Time

Example
2026-05-22 09:51:41 +0300

Export Filters

In the Matrixify app, you can apply filters to export only specific items from your Shopify Store.
When creating a new export, select what you wish to export, and under that entity, click on the Filters button.

Note: the total displayed item count and estimated time won’t be affected by the filters applied.

Filter Description
Entity Limits the Export to Translations of selected Entity types only.

Possible Values
  • Product
  • Collection
  • Page
  • Blog
  • Blog Post
  • Metaobject
  • Menu
  • Shop

Start managing your Shopify data today!

Install
Excelify Facebook channel Excelify Twitter channel Excelify Youtube channel
Newsletter
Thank you for subscribing!
© 2026 Matrixify.app
Made in Latvia Latvia