I have got order collection with the following code:

$orders = $objectManager->create('Magento\Sales\Model\Order')->getCollection();

Which is working fine. Problem is that it returns all types of orders including 'processing', 'cancelled' etc. I don't want the cancelled order in this collection.

I don't know how to exclude cancelled order in the above code.

Hope somebody helps.


3 Answers 3


Try this,

$orders = $objectManager->create('Magento\Sales\Model\Order')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('in' => array(complete,processing)));

Status not in cancelled order will get into the collection.

am not sure about the status name cancelled make sure you use the exact one in the table sales_order table.

  • Call to undefined method Magento\Sales\Model\ResourceModel\Order\Collection::addFieldToField() Apr 4, 2019 at 13:05
  • sorry typo erro check now Apr 4, 2019 at 13:06
  • I have checked it in db for status, its 'canceled' but still it is not working niether yours nor mine. Apr 5, 2019 at 10:42
  • Will it returns collection Apr 5, 2019 at 10:44
  • It is returning collection including all types of status Apr 5, 2019 at 10:45

It isn't the best way to get collections in M2 using object manager. Use collection factorty for this purpose instead. Here's a short example:

use Magento\Sales\Model\ResourceModel\Order\CollectionFactory;

class SomeClass
    public function __construct(
        CollectionFactory $orderCollectionFactory
    ) {
        $this->collectionFactory = $orderCollectionFactory;
     public function getOrders(){
         $orders = $this->collectionFactory()->create()
             ->addFieldToFilter('status', ['neq' => 'cancelled']);
         return $orders;
  • Magento is spelled using broken English (i.e. American). "Correct" spelling for the filter is "canceled" (even though the actual correct spelling is "cancelled", GARGH!!!) Jun 29, 2020 at 13:21

I've just done this in Magento 2.4. I found the statuses needed quotations to match. Here I filter orders by customer email and then orders of statuses - complete, processing and closed.

$orders = $objectManager->get('\Magento\Sales\Model\OrderFactory')->create()->getCollection()->addFieldToFilter('customer_email', $customer_email)->addFieldToSelect('*')->addFieldToFilter('status', array('in' => array( 'complete','processing','closed')));

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.