In which database table Magento Category page Meta Title is saved

In which database table Magento Category page Meta Title is saved

August 21, 2026 · Illustrated author avatarBy Stefan Bogdanescu
In which database table Magento Category page Meta Title is saved

Title: Updating Magento Category Page Meta Title: A Comprehensive Guide

Introduction

As an eCommerce developer, you might find yourself needing to update the meta title for category pages in your Magento storefront. While Magento handles meta descriptions and keywords well, finding the correct table and attribute for changing these titles can be a bit tricky if you’re not familiar with the database schema.

In this post, we’ll provide a step-by-step guide on how to locate and modify the category page meta title in Magento 2.

Understanding Magento’s Database Schema

Magento uses a relational database management system (MySQL or PostgreSQL) to store all its data. The key tables you need to know for category pages are:

  1. catalog_category_entity: This is the main table that stores basic information about each category.
  2. catalog_category_entity_varchar: This table contains additional text-based attributes for each category, including the meta title.

Locating the Category Page Meta Title

Step 1: Identifying the Attribute Code

The first step is to find the attribute code that corresponds to the category page’s meta title. In Magento 2, meta titles are stored in the catalog_category_entity_varchar table under an attribute called meta_title.

You can verify this by checking your database or using a tool like phpMyAdmin.

Step 2: Locating the Database Record

To find the specific record for a category’s meta title, you’ll need to join two tables:

SELECT cce.entity_id, ccev.value AS meta_title
FROM catalog_category_entity AS cce
JOIN catalog_category_entity_varchar AS ccev ON (cce.entity_id = ccev.entity_id)
WHERE cce.parent_id = <your-category-id>;

Replace <your-category-id> with the actual ID of the category you want to update. This query will return a table with two columns: entity_id (the primary key for the category) and meta_title.

Updating the Category Page Meta Title

Once you’ve located the correct record, you can update it directly in the database or through Magento’s admin interface.

Method 1: Direct Database Update

To update the meta title via a direct SQL query:

UPDATE catalog_category_entity_varchar
SET value = '<your-new-title>'
WHERE entity_id = <category-id> AND attribute_id = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'meta_title');

Replace <your-new-title> with your desired meta title and <category-id> with the actual category ID.

Method 2: Using Magento’s Admin Interface

  1. Log in to your Magento admin panel.
  2. Navigate to Catalog > Categories.
  3. Find the specific category you want to update, then click “Edit” in the actions column.
  4. Scroll down to the “Search Engine Optimization” section and find the field labeled “Meta Title.”
  5. Enter your new meta title or make any necessary changes.
  6. Click “Save Category.”

Best Practices for Meta Titles

When updating your category page meta titles, remember these best practices:

  1. Use concise, descriptive language that accurately reflects the content of the category.
  2. Include your primary keywords near the beginning of the title tag.
  3. Keep it under 50-60 characters to avoid truncation in search engine results.

Conclusion

Updating Magento category page meta titles is a straightforward process once you understand the database schema and attribute codes. By following this guide, you should be able to modify your meta titles efficiently without resorting to core file hacks or third-party extensions.

Remember that proper SEO requires a holistic approach, and meta titles are just one part of an effective strategy. For more advanced Magento development techniques, consider exploring the resources available at Laravel Company.

Happy coding!

Magento 2 Catalog Database Admin

Our network