· DataEase · Tutorials  · 2 min read

Translations in Shopify

Managing storefront text (product titles, menu names, policy pages, etc.) across languages manually can be extremely time-consuming. DataEase makes it easy: export translations, edit language columns, validate with origin digests, and import updates or deletions safely—all in bulk.

🎯 Goal

Manage storefront text (product titles, menu names, policy pages, etc.) across languages in bulk: export, edit, and import translations safely.

📋 Step-by-Step Instructions

1. Export Translations

In DataEase, go to New Export → Translation. Select fields such as:

  • resourceId
  • value
  • locale

Note: Outdated entries (source changed) are highlighted so you can spot them quickly.

2. Edit the File

Open the exported file in Excel or Google Sheets. For each row you want to update:

  • Keep resourceId and originDigest
  • Enter translations in language columns like [es] value or market-specific [fr/France] value
  • Use command = UPDATE to change text or DELETE to remove values

When done, save the file as .xlsx or .csv.

3. Import & Validate

  1. In DataEase, start New Import
  2. Upload your edited file
  3. Map fields
  4. Run Validation

Important: For UPDATE, originDigest must match the current source so you don’t overwrite against stale content. Empty cells keep existing values; DELETE with an empty language cell removes only that language.

📝 Field Reference (Key Items)

  • resourceId — ID of the item being translated (product, page, menu)
  • command — UPDATE, DELETE (default is IGNORE)
  • key — exact field (e.g., title, body_html)
  • value / [lang] value / [lang/Market] value — translated text, per language/market
  • locale — language code (e.g., en, fr)
  • originDigest — hash of the source text; required for UPDATE

🔍 Filters

  • ResourceType (PRODUCT, PAGE, MENU, etc.)
  • Language (e.g., de)
  • IncludeMarketTranslations (adds [lang/Market] columns when enabled)

💡 Minimal CSV Examples

Update German product title:

resourceId,originDigest,command,[de] value
gid://shopify/Product/123,5a9e...,UPDATE,"Bio-Baumwoll-T-Shirt"

Remove only French value (keep others):

resourceId,command,[fr] value
gid://shopify/Product/123,DELETE,

🎉 That’s it!

Your translations are now managed in bulk.
If you run into any issues or have questions, feel free to contact our support team.

Share: