Magento 2 Removing an inline translation from database

Magento 2 Removing an inline translation from database

July 24, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento 2 Removing an inline translation from database

Removing Inline Translations from Magento 2 Database

Inline translations are a powerful feature in Magento 2 that allow you to translate specific strings within your codebase. However, sometimes these translations can break due to issues like improper encoding of special characters.

Understanding the Problem: Broken Inline Translations & Symbols

The issue at hand is an inline translation for the string “Review & Payment” which has been broken because of the use of the ’&’ symbol instead of a regular ampersand ’&’. This causes two problems:

  1. The original string in your code won’t be translated.
  2. Any subsequent attempts to edit this translation via the Magento admin interface will fail, making it appear that nothing is happening.

Step 1: Identify the Translation ID

Before we proceed, you need to identify the unique ID of the broken inline translation. This ID can typically be found in the database table core_translate under the column translate_id. You’ll need this ID for the next step.

Step 2: Delete the Broken Inline Translation Entry

Now that you have the translation ID, it’s time to remove the problematic entry from the database. This is a straightforward process involving a direct SQL query:

DELETE FROM core_translate WHERE translate_id = <INSERT_YOUR_TRANSLATION_ID_HERE>;

Remember to replace <INSERT_YOUR_TRANSLATION_ID_HERE> with the actual ID you identified in Step 1.

Step 3: Flush the Translation Cache

After deleting the entry, it’s crucial to flush the translation cache for the changes to take effect:

bin/magento cache:flush

Or if you’re running Magento on a more recent version with improved caching infrastructure:

bin/magento c:f

Step 4: Verify the Removal

After executing these steps, try editing the same string in your admin panel again. You should now find that the inline translation is completely removed.

The original text “Review & Payment” will be used instead of any broken translations. However, keep in mind this will only work if there are no other translations for this specific string in other languages or locales.

Conclusion: Dealing with Inline Translation Issues

When you encounter issues like these, it’s often easier to simply delete the problematic translation entry and start fresh rather than trying to fix it directly. This approach ensures a clean slate and prevents further complications.

Remember, while inline translations are powerful tools for localization, they can also introduce complexity if not handled properly. Always ensure your translations are properly encoded and follow Magento’s best practices.

If you’re looking for more advanced strategies for managing your Magento 2 locale settings, consider reaching out to the experts at Laravel Company.

They specialize in providing top-tier Magento development services that can help optimize your store for international audiences and prevent issues like broken inline translations.

The key takeaway is: when dealing with translation issues, it’s often simpler to remove the problematic entry and start fresh than to try to fix a broken record. With proper database management and caching control, you can maintain a smooth multilingual experience for your customers.

Magento 2 Cache Database Admin

Our network