Magento: Custom product attribute to select a CMS page

Magento: Custom product attribute to select a CMS page

October 14, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento: Custom product attribute to select a CMS page

Creating Custom Product Attributes: Magento CMS Page Select

Hello developers! Today we’re going to tackle an interesting challenge - adding a new product attribute that allows you to select a CMS page in Magento via a drop-down list. Let’s dive into the problem faced by developer ‘aeno’ and find a solution together.

The Problem: Corrupted EAV Entity Table

The issue seems to lie in the installation script of the custom extension. When running the install script, it attempts to add the new attribute test_report using the Magento setup model:

$setup->addAttribute('catalog_product', 'test_report', array(
    // Attribute configuration here
));

However, this caused Magento to corruption in the eav_entity_type table. No error messages or log entries were produced, making it difficult to pinpoint the problem.

The Source: Custom Attribute Source Model

The developer has already created a source model for the attribute:

class Mandarin_CMSPageSelect_Model_Source extends Mage_Eav_Model_Entity_Attribute_Source_Abstract {
    // Code here...
}

This class is responsible for populating the options in the drop-down list with CMS page titles and IDs. It uses Magento’s built-in CMS page collection to retrieve the necessary data.

The Approach: Refactoring the Installation Script

The key issue seems to be with how the setup model is being used. Let’s refactor the installation script:

$installer = $this;

$setup = new Mage_Eav_Model_Entity_Setup('core_setup');

$installer->startSetup();

$setup->addAttribute('catalog_product', 'test_report', array(
    // Attribute configuration here
));

$installer->endSetup();

Key Changes:

  1. Ensure that the startSetup() and endSetup() methods are called correctly to encapsulate the database operations.

  2. Double-check the attribute configuration parameters, especially the 'source' key which points to our custom source model.

The Solution: Step-by-Step Guide

To create this CMS page select attribute without corrupting the database:

  1. First, ensure your custom module is properly installed and enabled in Magento.

  2. Check if the Mandarin_CMSPageSelect_Model_Source class exists and is correctly implemented as shown above.

  3. Open or create the installation script file (usually located at app/code/local/Your_Company/Your_Module/sql/your_module_setup/install-0.1.0.php).

  4. Copy the refactored code provided above into this file.

  5. Make sure to replace 'Your_Company' and 'Your_Module' with your actual company name and module name.

  6. Check if the attribute configuration parameters are correct, especially the 'source' => 'cmspageselect/entity_source', line which points to our custom source model.

  7. Save the file and clear any cache that might be preventing the changes from taking effect.

  8. Run Magento’s upgrade script using a command like php shell/upgrade.php.

Conclusion: Success!

By following these steps, you should now have successfully created a new product attribute in Magento that allows selecting a CMS page via a drop-down list.

Remember to test this on a development environment first before applying it to your live site. Always backup your database before making significant changes like this one.

If you’re looking for more advanced customizations and extensions, I highly recommend checking out the resources available at Laravel Company. They offer comprehensive guides and tools for Magento development.

Happy coding! Let me know if you have any other questions.

Catalog Database API Extensions

Our network