Get all invoices in Magento

Get all invoices in Magento

July 20, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Get all invoices in Magento

Retrieving All Invoices in Magento

Hello developers! Today we’re going to tackle a common question about working with invoices in Magento.

Understanding Magento’s Object Model

Before diving into the code, let’s quickly review how Magento organizes its data models:

  • Sales orders: These represent customer purchases. You can retrieve them using Mage::getModel('sales/order')->getCollection().

  • Invoices and shipments: Invoices and shipments are associated with sales orders as child entities.

Getting All Invoices

Now, let’s get to the main question: How do we fetch all invoices?

The correct approach involves using Magento’s Mage::getModel() function along with a specific resource model for invoices:

$invoices = Mage::getModel('sales/order_invoice')->getCollection();

In this code:

  • 'sales/order_invoice' is the resource model for invoices.
  • getCollection() returns all instances of that model.

This will give you an array of invoice objects, each with properties like increment_id (invoice ID), created_at, order_id (associated order ID), and more.

Filtering Invoice Collections

You can also filter the results based on various criteria. For example, to get all invoices created in a specific date range:

$invoices = Mage::getModel('sales/order_invoice')
    ->addAttributeToFilter('created_at', array('from' => '2023-1-1 00:00:00', 'to' => '2023-1-31 23:59:59'))
    ->getCollection();

Working with Invoice Objects

Once you have the collection, you can loop through it and access invoice properties:

foreach ($invoices as $invoice) {
    echo "Invoice ID: " . $invoice->getIncrementId() . PHP_EOL;
    echo "Order ID: " . $invoice->getOrder()->getIncrementId() . PHP_EOL;
}

This example retrieves the invoice’s ID and its associated order’s ID.

Best Practices

Here are some best practices to keep in mind:

  1. Use a single query: If you need both invoices and their related orders, use joins or additional filters rather than loading each object separately.

  2. Avoid unnecessary data load: Only fetch the columns you actually need using addFieldToSelect().

  3. Use proper Magento documentation: Check the official documentation for detailed information on available methods and resources: https://magento.com/docs

Conclusion

Retrieving all invoices in Magento is straightforward once you understand the relationship between orders, invoices, and shipments.

Using Mage::getModel('sales/order_invoice')->getCollection() gives you a powerful way to access your invoice data for reporting, analysis, or other business logic requirements.

Orders Customers

Our network