How can I export inline translations to another Magento store?

How can I export inline translations to another Magento store?

August 11, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How can I export inline translations to another Magento store?

Exporting Inline Translations Between Magento Stores: A Comprehensive Guide

As an e-commerce developer, you often find yourself managing multiple Magento stores for clients who share similar product catalogs or content. However, translating these stores manually can be a time-consuming and error-prone process. This guide will walk you through the efficient export of inline translations from one Magento store to another.

Understanding Inline Translations in Magento

Magento allows you to translate various elements within your storefront, including product names, descriptions, and attribute labels. These are known as inline translations, which are stored in the catalog_product_entity_varchar and eav_attribute tables for products and attributes respectively.

Before we proceed with the export process, let’s ensure that your Magento installation is properly configured for multi-store setup. You can refer to our previous blog post on configuring multiple stores in Magento for a detailed walkthrough of the necessary settings.

Exporting Inline Translations with MySQL

The most straightforward method to export inline translations involves using MySQL queries to extract the required data from your database. Here’s a step-by-step process:

  1. First, ensure you have access to your Magento database through a MySQL client like phpMyAdmin or any other preferred tool.

  2. Create a backup of both your source and target databases before proceeding with any modifications.

  3. Identify the store views for which you want to export translations by checking the store_id column in the core_store table.

  4. Run the following MySQL query to extract inline product translations from the catalog_product_entity_varchar table:

SELECT * FROM catalog_product_entity_varchar WHERE attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE store_id = <source_store_id> AND entity_type_id = 4);

Replace <source_store_id> with the ID of your source store.

  1. Extract the corresponding inline translations from the target store using a similar query, replacing catalog_product_entity_varchar and store_id accordingly:
SELECT * FROM catalog_product_entity_varchar WHERE attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE store_id = <target_store_id> AND entity_type_id = 4);
  1. Compare the two result sets, focusing on rows with different values in the value column for each product.

  2. Update the target store’s inline translations by executing an UPDATE query based on the differences identified:

UPDATE catalog_product_entity_varchar AS t2
JOIN (
    SELECT * FROM catalog_product_entity_varchar WHERE attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE store_id = <source_store_id> AND entity_type_id = 4)
) AS t1 ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id
SET t2.value = COALESCE(t1.value, t2.value);

This query will update the value column in the target store’s catalog_product_entity_varchar table with the corresponding values from the source store.

Exporting Inline Translations with Magento Dataflow

An alternative approach involves using Magento’s built-in dataflow functionality to export and import translations more efficiently. Here are the steps:

  1. Access the Magento admin panel and navigate to Systems > Import/Export > Export.

  2. Select “Translations” as the Entity Type and choose your source store view from the Store View dropdown.

  3. Click on the “Continue” button, then select “All Stores” or the specific target stores you want to export translations for.

  4. Choose a filename for your export file and click on the “Download CSV/RSS” button.

  5. Once the export is complete, navigate back to the Import/Export section in the admin panel.

  6. Click on the “Import” button and select “Translations” as the Entity Type again.

  7. Choose the file you just exported and provide any required values for the store view and behavior settings.

  8. Click on the “Continue” button, then review the data mapping if necessary, and finally click on the “Import All Records” button to import the translations into your target stores.

Conclusion

Exporting inline translations between Magento stores is a critical task when managing multiple stores with shared content. By using either MySQL queries directly or leveraging Magento’s built-in dataflow functionality, you can efficiently transfer translations from one store to another without manual intervention.

Remember to always backup your databases before performing any modifications and thoroughly test the exported translations in your target stores.

For further assistance with Magento development, don’t hesitate to contact our team of experts at Laravel Company for professional support and consultation on all your e-commerce needs.

Catalog Database Configuration Import/Export

Our network