@elenalauder @Ogenstad I think I might have a short term fix for you to help copy the translations from the old theme to the new theme, based on the translations CSV. You’ll need the CSV for both the old theme, with its translations in place, and the new one, without translations. Languages > Settings > Export gives you whichever theme is live at the time, so you’ll need to make a theme temporarily live to do the export. Only do this for one language at a time.
Column G = Source content (i.e. English, if your default language is set to English)
Column H = Translations
-
Put both CSV exports in one Google Sheets file as separate sheets, and rename the old theme’s export Sheet2 and the new one Sheet1.
-
For both sheets, delete all rows that don’t have ONLINE_STORE_THEME in column A. We only want to work with theme content here. Column H in Sheet1 will be empty, column H in Sheet2 will be full (of the old translations)
-
On Sheet 1 in cell H2 (which should be the first of an empty column), paste this formula:
=IFERROR(VLOOKUP(G2, SORT({Sheet2!G:H, LEN(Sheet2!H:H)}, 3, FALSE), 2, FALSE), "") -
Then auto-fill all the way down. This formula is matching based on column G default content. Where it finds a match between column G in Sheet1 and column G in Sheet2 it copies over what it finds in column H in Sheet2 to column H in Sheet1.
-
Export Sheet1 as a CSV.
-
Ensuring that the ‘new’ theme is live, i.e. without the translations in it, import this CSV.
This should port old theme translations to your new theme, without the need to manually copy and paste. These translations will be visible and editable in Translate & Adapt, and other Translations API compliant apps.
Hope that helps!
Rich