Magento – Magento get products by website id and store id

product-listproductsstoreswebsites

I am working in magento one website multiple stores platform, i successfully created one website with 3 stores and 3 store view. I assigned a category to my default store and products in it, but i getting other products also. Let me know how i can go to correct direction.

$collection = Mage::getModel('catalog/product')->setStoreId($storeId)->getCollection()->addAttributeToSelect('*')->addWebsiteFilter($website_id)->addAttributeToFilter‌('type_id', array('eq' => 'simple'));
$collection->getSelect()->limit(8);

Best Answer

Try this

$websiteIds = array(Mage::app()->getStore()->getWebsiteId());
$storeId = Mage::app()->getStore()->getStoreId();

$collection = Mage::getModel('catalog/product')->getCollection()
            ->addAttributeToSelect('*');
$collection->addStoreFilter($storeId);
$collection->addWebsiteFilter($websiteIds);

Related Solutions

Get Store Details by Website ID in Magento

you can get it like that...

$websiteId=1;
    $website = Mage::getModel('core/website')->load($websiteId); 
    foreach ($website->getGroups() as $group) {
            $stores = $group->getStores();
            foreach ($stores as $store) {
                echo $store->getId() ." ".$store->getName()."<br/>";
            }
        }

Programmatically Update Store Name and Website Name in Magento

Updated

For store try this

$storeModel = Mage::getModel('core/store_group');

//  Load by store Id:

 $storeModel->load($id);

 $storeModel->setData('name','Amit');
 $storeModel->save();

For Website:

$websiteModel = Mage::getModel('core/website');
$websiteModel->load($WebsiteId);
$websiteModel->setData('name','MYStoreWebsite');
$websiteModel->save();

You can easily do it by shell script. Create a file update.php in your Magento directory and add the following code:

require "YourMagentoDirPath/app/Mage.php";
umask(0);
Mage::app('admin');

$storeModel = Mage::getModel('core/store_group');

//  Load by store Id:
$storeModel->load($id);

$storeModel->setData('name','Amit');
$storeModel->save();

$websiteModel = Mage::getModel('core/website');
$websiteModel->load($WebsiteId);
$websiteModel->setData('name','MYStoreWebsite');
$websiteModel->save();