What tables in Magento Database are Transactional emails save to?

What tables in Magento Database are Transactional emails save to?

July 20, 2026 · Illustrated author avatarBy Stefan Bogdanescu
What tables in Magento Database are Transactional emails save to?

Retrieving Transactional Emails from Magento Database

If you’re looking to migrate transactional emails from one Magento instance to another, it’s crucial to understand where these emails are stored in the database. Let me guide you through this process.

Understanding Magento’s Email Storage Structure

Magento uses multiple tables to store email templates and their respective content. The main tables involved are:

  • core_email_template
  • core_email_template_varchar
  • core_email_template_text

The core_email_template table stores the metadata for each template, including its name, subject, sender details, etc. The other two tables (varchar and text) store the actual textual content of the email templates.

Locating Your Transactional Emails

To find your transactional emails, you can query these tables directly using SQL or use Magento’s built-in API. Here’s a simple SQL query to retrieve all transactional email templates:

SELECT *
FROM core_email_template
WHERE (email_template_type = 'transactional' OR event_id LIKE '%transaction%')

This query will return all email templates that are either explicitly marked as transactional or associated with an event name containing the word “transaction”. This should cover most common Magento transactional emails like order confirmations, invoices, and shipment notifications.

Exporting Email Templates for Migration

To migrate these templates, you’ll want to export them into a format that can be easily imported into your new database. You can achieve this using Magento’s built-in import/export functionality or by writing a custom script.

For the built-in method:

  1. Log in to your Magento admin panel.
  2. Navigate to System > Import/Export > Export.
  3. Choose Email Templates from the Entity Type dropdown.
  4. Select the file format (CSV is recommended for most users).
  5. Click on Continue.

This will export all your email templates into the chosen file format, which you can then import into your new Magento installation.

Conclusion

Retrieving transactional emails from a Magento database involves understanding the structure of the core_email_template and related tables. By using SQL queries or the built-in import/export functionality, you can efficiently migrate these critical assets to your new environment without losing any customizations.

If you’re looking for more advanced techniques on managing Magento data migrations or need assistance with other e-commerce challenges, feel free to explore our resources at Laravel Company. We offer a range of services from development and consulting to performance optimization for Laravel and Magento projects.

Database API Themes Email

Our network