How to get all last order status in magento?

How to get all last order status in magento?

August 31, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to get all last order status in magento?

Getting the Last Order Status in Magento

In Magento, an order can have multiple statuses as it moves through the fulfillment pipeline. However, you may often need to retrieve the latest or final status of an order for various purposes like reporting, analytics, or frontend display. Here’s a step-by-step guide on how to achieve this.

Understanding Order Status in Magento

Magento uses a status field in the sales_flat_order table to store the current state of each order. This field can have values like ‘pending’, ‘processing’, ‘complete’, etc., indicating where an order stands in the workflow.

However, an order’s history doesn’t always reflect its most recent status. To get the last status, you need to work around Magento’s default collection methods.

Retrieving Orders with a Specific Status

Before we dive into getting the last status, let’s first look at how to retrieve orders with specific statuses:

$orders = Mage::getModel('sales/order')
          ->getCollection()
          ->addFieldToFilter('status', array('in' => array('processing', 'processed', 'pending fullfilment')));

$orders->addFieldToFilter('store_id', array("in" => array('8', '9')));

$orders->addAttributeToSort('created_at', 'asc');

$allIds = $orders->getAllIds();

In this example, we’re filtering orders by status and store ID, then sorting them by creation date in ascending order. The getAllIds() method returns an array of all order IDs matching the filter.

Getting the Last Status for Each Order

Now let’s modify this approach to retrieve the last status for each order:

$orders = Mage::getModel('sales/order')
          ->getCollection()
          ->addFieldToFilter('status', array('in' => array('processing', 'processed', 'pending fullfilment')));

$orders->addFieldToFilter('store_id', array("in" => array('8', '9')));

$allIds = $orders->getAllIds();

foreach ($allIds as $thisId) {
    $order = Mage::getModel('sales/order')->load($thisId);
    echo "Order ID: {$order->getIncrementId()}, Last Status: {$order->getStatusLabel()}";
}

In this updated code, we’re loading each order by its ID using Mage::getModel('sales/order')->load($thisId). The getStatusLabel() method returns the human-readable version of the status.

Conclusion

Retrieving the last or final status of an order in Magento requires a bit of extra work beyond the standard collection methods. By filtering orders by status, sorting them by creation date, and then loading each one individually, you can get the most recent status for all relevant orders.

Remember to adjust the status arrays and filter conditions according to your specific needs.

For more advanced order management techniques in Magento, I recommend checking out the tutorials and guides at Laravel Company, which offer practical insights from experienced developers.

Database Orders

Our network