How to rewrite Collection?

How to rewrite Collection?

September 6, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to rewrite Collection?

Rewriting Magento Sales Order Collections: A Step-by-Step Guide

As an experienced Magento developer, you may find yourself needing to rewrite collections for specific purposes such as filtering by store or applying custom business logic. In this post, we’ll guide you through the process of rewriting the Mage::getResourceModel('sales/order_collection') collection.

Understanding Magento’s Resource Model and Collections

Before diving into the solution, let’s first clarify some key concepts:

  • Resource Models: These are responsible for database operations. They handle data access layers (DAL) and map between the database tables and models.
  • Collections: A collection is a group of objects that share similar attributes or behaviors. In Magento, collections represent groups of related records from the database.

The Challenge: Rewriting the Sales Order Collection

Your goal is to rewrite the Mage::getResourceModel('sales/order_collection') collection to filter orders by store. However, you’re facing a fatal error when trying to call getCollection() on the resource model:

Fatal error: Call to undefined method Mage_Sales_Model_Mysql4_Order::getCollection()

The Solution: Using Event Observers and Overriding the Collection

To achieve this, we’ll use an event observer and override the collection’s _afterLoad method. Here’s a step-by-step guide:

1. Create your module

First, create a new Magento module using the following structure:

app/code/local/YourCompany/SalesRewrite/etc/config.xml

In config.xml, define the following necessary information:

<?xml version="1.0"?>
<config>
    <modules>
        <YourCompany_SalesRewrite>
            <version>1.0.0</version>
        </YourCompany_SalesRewrite>
    </modules>

    <global>
        <resources>
            <salesrewrite_setup>
                <setup>
                    <module>YourCompany_SalesRewrite</module>
                </setup>
            </salesrewrite_setup>
        </resources>
    </global>
</config>

2. Create the event observer

Create an event observer file at:

app/code/local/YourCompany/SalesRewrite/etc/events.xml

Here, you’ll define your observer for the core_resource_load_after event:

<?xml version="1.0"?>
<events>
    <core_resource_load_after>
        <observers>
            <yourcompany_salesrewrite_observer>
                <type>singleton</type>
                <class>YourCompany_SalesRewrite_Model_Observer</class>
                <method>observeCoreResourceLoadAfter</method>
            </yourcompany_salesrewrite_observer>
        </observers>
    </core_resource_load_after>
</events>

3. Create the observer class

Now, create the observer file:

app/code/local/YourCompany/SalesRewrite/Model/Observer.php

In this class, you’ll override the _afterLoad method of the sales_order collection to filter by store:

class YourCompany_SalesRewrite_Model_Observer
{
    public function observeCoreResourceLoadAfter($observer)
    {
        $collection = $observer->getEvent()->getCollection();
        if ($collection instanceof Mage_Sales_Model_Mysql4_Order_Collection) {
            $storeId = Mage::app()->getStore()->getId();
            $collection->addFieldToFilter('store_id', $storeId);
        }
    }
}

Conclusion

By following this approach, you’ve successfully rewritten the Mage_Sales_Model_Mysql4_Order resource model’s collection to filter orders by store. This technique allows for a clean separation of concerns and avoids directly modifying core files.

For more advanced customizations or to learn how to apply similar techniques to other collections, we recommend exploring our comprehensive guide on Magento Collection Rewrites at Laravel Company.

Database Extensions Orders Errors

Our network