Skip to content
DataEase
Try for free

Translations

A Translation record stores the text shown to shoppers in each language (product titles, menu names, policy pages, and more).
Use DataEase to fix outdated text, add new languages, or remove old translations in one upload.
Official Shopify guide.

Table of Contents

Section titled “Table of Contents”
  1. Export
  2. Import
  3. Field reference
  4. Filters

2. Export

Section titled “2. Export”
  1. Pick CSV or Excel.
  2. Choose Translation as the entity.
  3. Select the fields you need, such as resourceId, value, and locale.

Outdated translations (the original text changed) show in red so you can spot them fast.
See full steps in the Export guide.

3. Import

Section titled “3. Import”

Supported commands: UPDATE, DELETE (default is IGNORE).

  1. Download the export file.
  2. Fill the sheet: keep resourceId, originDigest, language columns like [es] value or [fr/France] value.
  3. In DataEase, match the fields, upload the file, and run the import.

Tips

  • UPDATE rows must include correct originDigest and resourceId.
  • Leave a language cell empty to keep that translation.
  • Use DELETE with an empty language cell to remove that specific language value only.

Full how-to: Import guide.

4. Field reference

Section titled “4. Field reference”

  • resourceId — Unique ID of the item you are translating (product, page, etc.). Needed for UPDATE or DELETE.

  • command — What to do with the row: UPDATE, DELETE, or IGNORE (default).

  • resource — The type of Shopify item (PRODUCT, PAGE, MENU, etc.). Export-only; not changeable.

  • key — The exact field being translated, like title or body_html. Export-only.

  • value — The translated text. Each language appears in its own column, e.g. [es] value.

  • locale — Two-letter language code such as en, fr, or es.

  • translatableLocaleMarketValueColumnRegexp — Value for a specific market (e.g., [fr/France] value). Optional.

  • originDigest — Hash of the original text. Must match Shopify to allow an UPDATE.

5. Filters

Section titled “5. Filters”

  • ResourceType — Export only translations for a certain resource type (PRODUCT, BLOG, MENU, etc.).

  • Language — Export translations in one language code, for example de.

  • IncludeMarketTranslations — Toggle to include or hide market-specific columns like [en/US].

Need help? Our support team answers within 24 hours. Happy translating!