Magento Get SUM of order totals between set dates

Magento Get SUM of order totals between set dates

July 20, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento Get SUM of order totals between set dates

Magento: Calculating Total Revenue Between Set Dates

Magento provides powerful tools for managing eCommerce stores, including advanced querying capabilities for order data. If you’re looking to calculate the sum of order totals between specific dates “the Magento way”, here’s a step-by-step guide:

Step 1: Understanding the Magento Order Model

The sales/order model in Magento represents individual orders placed by customers. Each order has attributes like grand_total, which stores the total amount of the order.

Step 2: Creating an Order Collection

To work with multiple orders, we first need to create an order collection using Mage::getModel('sales/order')->getCollection(). This returns a collection of all orders in your database:

$orders = Mage::getModel('sales/order')->getCollection();

Step 3: Filtering Orders by Date

To filter the orders based on dates, you can use the addAttributeToFilter method. Here’s an example to get all orders from July 2012:

$orders->addAttributeToFilter('created_at', array(
    'from' => '2012-07-01',
    'to'   => '2012-07-31'
));

Replace 'created_at' with the field that contains your order date data. This can be created_at for orders created between these dates or a custom field.

Step 4: Calculating the Total Revenue

To calculate the total revenue, we need to use addExpressionAttributeToSelect. This method allows you to add an expression attribute to the select statement of your collection:

$orders->addExpressionAttributeToSelect('grand_total', 'SUM({{grand_total}})', array('grand_total'));

This adds a new column called grand_total to the result set, which is the sum of all grand_total values in the selected orders.

Step 5: Retrieving the Total Revenue

Finally, you can retrieve this calculated total using the getColumnValues method:

$totalRevenue = $orders->getColumnValues('grand_total');

This will return an array with a single value representing the sum of all order totals within the specified date range.

Conclusion

Calculating total revenue between specific dates in Magento is straightforward once you understand how to work with collections and expressions. By following this guide, you can easily create powerful queries tailored to your store’s needs.

Remember, performance optimization is crucial for large stores. Use these queries wisely during off-peak hours or consider using cron jobs for scheduled calculations.

Learn more about advanced Magento querying techniques in our Magento Development Guide at Laravel Company.

Happy coding!

Database Orders Customers

Our network