Alter Magento Index Fulltext Search?

Alter Magento Index Fulltext Search?

October 2, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Alter Magento Index Fulltext Search?

Enhancing Magento Fulltext Search: A Comprehensive Guide

Hello developers! Today, I want to tackle a common challenge we often face - customizing Magento’s fulltext search engine for enhanced functionality. Specifically, let me guide you through a specific task: altering the indexer process to insert weighted tags into the fulltext1_en field during reindexing.

Understanding the Current Setup

First, let’s clarify your current environment and requirements:

  • You’re running a Magento site integrated with a custom SOLR search page.
  • The phpSolrClient is used to parse Solr XML and build search results.
  • An attribute called “search_tags” has been created in the backend for weighted tags.

Your goal is to insert these weighted tags into the fulltext1_en field during reindexing to improve search relevance. For example, if you enter sight^2,hearing^1,smell^3, Magento should add “sight” twice, “hearing” once, and “smell” three times to the fulltext1_en field.

Identifying the Key Files

Before we dive into the code, let’s identify the key files involved:

  • Indexer.php: This is where most of the index management happens. However, as you mentioned, it can be quite complex and ambiguous at first glance.
  • Mage_Catalog_Model_Resource_Eav_Mysql4_Fulltext: This model handles the full-text indexing process.

Modifying the Indexing Process

Now let’s modify the indexing process to accommodate your weighted tags:

  1. Open app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Fulltext.php.
  2. Locate the reindexEverything function.
  3. Inside this function, find the loop that iterates through each product.
foreach ($products as $productId) {
    // Your existing code here...
}
  1. Before the Zend_Db_Select query is built for fetching the attributes, add your custom logic:
$searchTags = Mage::getModel('catalog/product')->load($productId)->getData('search_tags');
if ($searchTags) {
    $tagsArray = explode(',', $searchTags);
    foreach ($tagsArray as $tagWithWeight) {
        list($tag, $weight) = explode('^', $tagWithWeight);
        for ($i = 0; $i < $weight; $i++) {
            // Append the tag to a temporary array
            $additionalFields[] = $tag;
        }
    }
}
  1. Now, when building the Zend_Db_Select query, include your additional fields:
$select->from($tableName)
       ->columns('e.entity_id AS entity_id')
       ->joinLeft(
           array('additional' => $this->getTable('catalog_product_entity_text')),
           'additional.entity_id = e.entity_id AND additional.attribute_id IN ('.implode(',', $additionalAttributes).') AND additional.store_id = 0',
           array_merge(array('additional.value AS value'), $additionalFields)
       );
  1. Finally, when inserting the values into the fulltext1_en field, include your additional fields:
$select->setIntegrityCheck(false)
       ->columns(
           $this->_getSelectColumns($tableName),
           array('IF(value IS NULL OR value = \'\', \'\', CONCAT(IFNULL(e.value, \'\'), IFNULL(e2.value, \'\'), IFNULL(e3.value, \'\'))) AS text')
       )
       ->joinLeft(
           array('e' => $this->getTable('catalog_product_entity_text')),
           'e.entity_id = e1.entity_id AND e.attribute_id IN ('.implode(',', $additionalAttributes).') AND e.store_id = 0',
           array()
       )
       ->joinLeft(
           array('e2' => $this->getTable('catalog_product_entity_text')),
           'e2.entity_id = e1.entity_id AND e2.attribute_id IN ('.implode(',', $additionalAttributes).') AND e2.store_id = 0',
           array()
       )
       ->joinLeft(
           array('e3' => $this->getTable('catalog_product_entity_text')),
           'e3.entity_id = e1.entity_id AND e3.attribute_id IN ('.implode(',', $additionalAttributes).') AND e3.store_id = 0',
           array()
       );

Conclusion

And there you have it! By following these steps, you should be able to successfully alter Magento’s full-text indexer process to include your weighted tags in the fulltext1_en field.

Remember, this is a complex task that requires careful testing and monitoring. Always ensure you have a backup before making significant changes to your core files.

For more detailed guides on Magento customization and best practices, I highly recommend checking out Laravel Company’s blog. They provide comprehensive tutorials and tips from experienced developers.

Happy coding!

Catalog Indexing Database Admin

Our network