Tutorial by Examples

// get existing collections $orders = Mage::getModel('sales/order')->getCollection(); $products = Mage::getModel('catalog/product')->getCollection(); $customers = Mage::getModel('customer/customer')->getCollection();

// $orders is collection $orders->addAttributeToSelect('status'); // get status attribute $orders->addAttributeToSelect('*'); // get all attributes

// filter by creation date $date = new Zend_Date(); $toDate = $date->get(Zend_Date::W3C); // today $fromDate = $date->sub('1', Zend_Date::MONTH)->get(Zend_Date::W3C); // one month ago $orders->addAttributeToFilter('created_at', array('from' => $fromDate, 'to' => $toDate)); ...

// sort by creation date $orders->setOrder('created_at', 'asc'); $orders->setOrder('created_at', 'desc'); $orders->setOrder('created_at'); // default direction is 'desc'

// iterating over items in collection foreach ($orders as $singleOrder) { // do something with individual objects var_dump($singleOrder->getData()); } // get first/last item in collection $first = $orders->getFirstItem(); $last = $orders->getLastItem();

// get product collection object $productCollection = Mage::getResourceModel('catalog/product_collection'); // get customer collection object $customerCollection = Mage::getResourceModel('customer/customer_collection'); // get order collection object $orderCollection = M...