CODEWITHSUNDEEP
magento
wutzebaer
wutzebaer

Reputation: 14865

magento product collection with specific id

i select products with 

$products = Mage::getModel('catalog/product')->getCollection()->addAttributeToFilter('entity_id', array('in' => $productIds));

how can i archieve that the collection is in the same order as the ids in $productIds?

thanks

Upvotes: 11

Views: 29898

Answers (1)

MagePal Extensions
MagePal Extensions

Reputation: 17656

    $productIds = array(1,3,2);
    $products = Mage::getModel('catalog/product')->getCollection()
                ->addAttributeToFilter('entity_id', array('in' => $productIds));


    $products->getSelect()->order("find_in_set(entity_id,'".implode(',',$productIds)."')");

    foreach($products as $product)
    {
        echo $product->getEntityId();
        echo $product->getSku();
    }

See more @

Upvotes: 21

Related Questions