How to export Translate & Adapt translations to CSV?

[mark_macrae_]

After installing the Translate & Adapt app and running the free translation on our store, I kindof expected all the translated product fields to show up in my CSV/Excel export of my products.

We have 50,000+ variants with a lot of similar terms that were not translated accurately.  Having to click on thousands of products online to change the same words over and over is not practical. 

How can I export all the translation data in order to quickly search & replace?

[richbrown_staff · Accepted solution]

Hi @mark_macrae_ , you go to Settings > Languages > Export. Out of interest, did this not work as you expect / did you find our help docs unclear? Feedback helps. Please let us know other challenges you come across, that's a lot of products and it can be unwieldy as the CSV splits into multiple files when it gets bigger than 10mb.

[mark_macrae_]

Thanks pointing me in the right direction.  I guess I had gone a step too far: I was already into the French language and there was no export option there.  The other way I was trying to get to it was via the product export, which we use extensively for bulk updates.

With CSVs we can do mass search/replace or write scripts to manipulate mass amounts of data.  So much easier than trying to edit online one by one.

[mark_macrae_]

Of course I am immediately running into a issue with the CSV export.  There is no relation to the products.  There is an "identification" which I would guess is a back-end ID of the data, but which doesn't appear on a product export.

This is a problem for all of the proper nouns that should not have been translated in the product titles.... So I'm back to wishing the "fr" fields were included on the product export CSV.

Anyway, this is a good start.

[snackonnuts]

Hello,  I am running into an issue doing the export - import.  I am using Seal Subscriptions app and would like to translate in French some text found in the auto-charge section of the widget.  I have exported into CSV and located the fields (as they don't show up on the Translate and adapt app fields).  I have populate the French wording and saved the file.  I imported the file.   When I switch the store to French, that section is still not translated.

[Younis-Vitrine]

Hello, I have more than 2000 Products and i need to translate them along with their metafields, how would i map the product data to the exported translation file which includes only an unknown id to me ? what i wanted is the file to contain anything unique in the product that is included in the product export file, any clue ?

[richbrown_staff]

Hi @Younis-Vitrine , there is not a way to do this via the CSV I'm afraid - metafields and product content are stored separately and there is not a common id between them. Partly this is because product metafields can be used across products. Other than the identification column, all that's unique to a product is its content. We'd be happy to talk further about your use case if you would like.

[Transcy]

Hello @mark_macrae_ ,

You can export all the translation data by following these steps:

• Go to Translate & Adapt app -> click Export
• Select the type of translation data (Products, Collections, Pages,...)
• Choose the source language
• Select the export format is CSV
• Export and download

Now you can open the file and search for the terms you want to replace, then make the changes in bulk using the search and replace function. After making the changes, you can import the updated translation data file back into your store

To import, you can try these steps:

• Go to Translate and Adapt app -> Import 
• Select the type of translation data (Products, Collections, Pages,...)
• Choose the source language
  Select the export format is CSV
• Import

Hope this can help. Let we know if you need any further support.

Transcy team.

[MMMugg]

For the life of me I can't seem to find where the Export and Import buttons are for this, are you able to help as I def can't see anything here!

[richbrown_staff]

Hi @MMMugg , they appear at the top of the page if you've added a language. If you haven't added a language they won't be there!