For my stores I use Translate and Adapt app. I exported Swedish language translations to CSV from one store so I can import same translations to another store for same content, but when I import CSV to another store it skips all the translations and giving error “could not find resource associated with given identification” for all instances. How can I overcome this issue, so I can use the translations to another store in an easy way instead of rewriting them all the way for around 5000 translations?
Topic summary
A user is attempting to transfer Swedish language translations (approximately 5,000 entries) between two Shopify stores using the Translate and Adapt app. After exporting translations to CSV from the first store and importing to the second, all translations are being skipped with the error “could not find resource associated with given identification.”
Proposed Solutions:
-
For products: Use product handles as a matching key instead of product IDs, since handles remain consistent across stores while IDs differ. This requires performing a VLOOKUP operation in Google Sheets or Excel between export and import steps.
-
For page content and collections: No definitive solution provided. Suggestions include creating custom metafields to establish matching keys, or using Airtable as middleware combined with an app like Syncbase connected to translation APIs.
Status: The issue remains unresolved with only partial workarounds suggested for product translations.
1 Like
FOR PRODUCTS: If you use the exact same product handle for both stores then you could probably use that as a “key” since the product id:s will not be the same for both stores - but the handles would be identical.
Of course you need to do a vlookup in gsheets/excel in between export from old store and import to new store.
FOR PAGE CONTENT, COLLECTIONS etc. I have no really good answer. Perhaps creating a metafield for each instance to create a key that way.
OR try using Airtable as middleware, and using an app like syncbase. That might work for translations - if connected through the right translation api:s