Language check of Magento Products

to check that the translation of the Short Description (SD), long description (LD) and System Requirements (SR) is in the correct language in the shop, follow these steps:

1. Export product catalog from Magento backend. (System > Export > Products)
2. Import as UTF-8, format and save as Excel file
   Excel new sheet > Data > Import CSV > Format UTF-8
3. Add a new column with language name
4. remove not needed columns. SAVE
5. remove HTML tags on the LD and SD columns

Strip HTML tags: The “Find and Replace” Trick (Easiest) #

If your tags are simple, you can use wildcards to delete them in bulk.

1. Select the column with your HTML.
2. Press Ctrl + H (Find and Replace).
3. In Find what, type: <*>
4. Leave Replace with empty.
5. Click Replace All.