Get related product on with same category,brand,gender
include('app/Mage.php'); Mage::app(); $product = Mage::getModel('catalog/product')->load(2122); $ids = $product->getCategoryIds(); //echo '<pre>'; //print_r($ids); $latest_cat_id = $ids[count($ids)-1]; $_category = Mage::getModel('catalog/category')->load($latest_cat_id); $_gender=Mage::getResourceModel('catalog/product')->getAttributeRawValue(2122, 'gender'); $_brand_name=Mage::getResourceModel('catalog/product')->getAttributeRawValue(2122, 'brand_name'); $catagory_model = Mage::getModel('catalog/category')->load($latest_cat_id); $collection = Mage::getResourceModel('catalog/product_collection'); $collection->addCategoryFilter($catagory_model); $collection->addFieldToFilter('brand_name',$_brand_name ); $collection->addFieldToFilter('gender',$_gender ); $collection->addAttributeToFilter('status',1); $collection->ad