WPML – How to Delete Duplicate Translations in Bulk

Sometimes we can have thousands of duplicate WPML translations for various reasons. For example, when we import translations or ask an assistant to create new translations, we can end up with many unintentionally translated and duplicated posts.

This can cause certain problems like overloading your database or server errors by having to load too much unnecessary content.

That’s why in this tutorial we want to show you how to remove all the duplicate translations at once.

We’ll do this with the WP Sheet Editor plugin, which allows you to make massive changes, filter posts by keyword, category or author; export/import thousands of translations using CSV files, etc.

We will use the spreadsheet editor for Posts for this tutorial. But the same steps apply to the products spreadsheet or any other of our plugins.

Once installed and activated, follow these steps to delete all duplicate WPML translations in seconds.

Step 1. Open the posts spreadsheet in the language you’ll edit

To open the post spreadsheet, go to WP Sheet Editor > Edit Posts.

When we open the spreadsheet in English, the spreadsheet will display the posts in the selected language.

And when we open the spreadsheet in Spanish, it will display all the posts in the selected language.

Also, if we select the Italian language, we’ll see all the Italian translations.

In this example, we’ll delete all duplicate Italian translations, so we need to select that language and go on to the next steps.

Step 2. Bulk Edit the WPML Translations

This tool allows you to bulk edit thousands of posts in seconds. You need to click on Bulk Edit to open it. It’s on the toolbar, so just click on it.

Step 3. Delete all duplicate WPML translations

After opening the Bulk Edit tool, you need to select these values to delete all the duplicate translations in the selected language.

  • Select the rows that you want to update: Edit all the rows from my current search (include non-visible rows)
  • What field do you want to edit: Title
  • Select type of edit: Remove duplicates
  • Which duplicates do you want to delete: You can delete the oldest or the newest duplicates.
  • Click on Execute now to delete all the duplicate translations in the selected language.

Now the spreadsheet editor will remove thousands of duplicates in the selected language.

Important

If you want to delete duplicates in multiple languages, you can repeat this same process. Just select the language in the WPML toolbar and repeat the process.

That was really simple!

With WP Sheet Editor, you can manage thousands of translations completely from the spreadsheet.

It’s so intuitive and allows you to apply thousands of changes at once, do advanced searches, export translations to Excel, import translations from Excel, etc.

Your WPML translations management will be completely transformed and simplified. You can enjoy all the benefits from spreadsheets as you manage your translations in several languages.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu