Can I export and import with this app and how can I translate metafields?

Solved

Can I export and import with this app and how can I translate metafields?

BobbyMacCheese
Shopify Partner
18 1 5

Hi, I'm working on a new (our first) Shopify store and have 2 questions about this app and translation process in general.

 

1 - I can export and import csv of language strings via settings > language, but it's a massive cumbersome file I have to spend a few hours cleaning before I can send it to translation team. After my cleaning I don't know if it's even going to import without issues. Can I export translations by categories or by products or something? And then import it back with Translate & Adapt?

 

2 - Each of my products has 20 metafields. How can I translate them and repeating values? The only way I found so far is by going through each product translation and doing the same thing over and over again which is ridiculous. If I have 5000 products with 1 metafield Color: Blue, I should be able to translate it once, not do it 5000 times.

 

Please advise.

Accepted Solution (1)

richbrown_staff
Shopify Staff
651 95 160

This is an accepted solution.

Hi @BobbyMacCheese , thanks for this. There's definite scope for improvement here. The Settings > Languages CSV is the right way to export - there is not an additional export with the ability to select specific resource types within Translate & Adapt. Some tips to make managing the CSV a little easier: 1) If yours gets split into multiple CSVs (there's a 10mb per file max) then you can merge them to make it easier to work in one place. E.g. here: https://merge-csv.com/. 2) You only need to keep in the CSV what you're working on. The CSV functionality only makes changes to things that have been changed in column H. So you can filter and delete rows that that you're not changing, making the upload smaller and more manageable. But noted on the desire to export by resource type, it's on the roadmap.

 

For point 2, currently there is not a concept of shared values. This requires a feature like translation memory, which is not part of the app's current scope - but again on the roadmap. The best way to do this in bulk is to auto-translate, or via the CSV. Note that, for example if you open the CSV in Google Sheets, you can use the =GOOGLETRANSLATE function, and find and replace etc.

To learn more visit the Shopify Help Center or the Community Blog.

View solution in original post

Reply 1 (1)

richbrown_staff
Shopify Staff
651 95 160

This is an accepted solution.

Hi @BobbyMacCheese , thanks for this. There's definite scope for improvement here. The Settings > Languages CSV is the right way to export - there is not an additional export with the ability to select specific resource types within Translate & Adapt. Some tips to make managing the CSV a little easier: 1) If yours gets split into multiple CSVs (there's a 10mb per file max) then you can merge them to make it easier to work in one place. E.g. here: https://merge-csv.com/. 2) You only need to keep in the CSV what you're working on. The CSV functionality only makes changes to things that have been changed in column H. So you can filter and delete rows that that you're not changing, making the upload smaller and more manageable. But noted on the desire to export by resource type, it's on the roadmap.

 

For point 2, currently there is not a concept of shared values. This requires a feature like translation memory, which is not part of the app's current scope - but again on the roadmap. The best way to do this in bulk is to auto-translate, or via the CSV. Note that, for example if you open the CSV in Google Sheets, you can use the =GOOGLETRANSLATE function, and find and replace etc.

To learn more visit the Shopify Help Center or the Community Blog.