Dtjytyk

How to set all associated products in the entire store to 'not visible individually' I've been scrolling through other answers but I can't seem to find a solution.

Here is an example script that sets the children of both grouped and configurable products to Not Visible Individually.

Save this in ./shell/makechildrennotvisible.php and run from shell.

<?php
include_once '../app/Mage.php';
Mage::app()->setCurrentStore( Mage_Core_Model_App::ADMIN_STORE_ID );

// Get all configurable and grouped products
$products = Mage::getModel('catalog/product')
 ->getCollection()
 ->addAttributeToSelect('name')
 ->addAttributeToFilter('type_id', array('in' => array('configurable', 'grouped')));

// Loop each configurable product
foreach ($products as $_product) 
 // Get the child products for this product
 if ($_product->getTypeId() == 'configurable') 
 $simpleProducts = $_product->getTypeInstance(true)->getUsedProductIds($_product);
 elseif ($_product->getTypeId() == 'grouped') 
 $simpleProducts = $_product->getTypeInstance(true)->getAssociatedProductIds($_product);
 
 printf("Setting children of Product ID %srn", $_product->getId());
 // Loop each child product
 foreach($simpleProducts as $_simpleID) 
 try 
 // Set associated product as not visible
 $_simple = Mage::getModel('catalog/product')->load($_simpleID);
 $_simple->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_NOT_VISIBLE);
 $_simple->save();
 printf("Product ID %s saved as 'Not Visible Individually'rn", $_simple->getId());
 catch ( Exception $e ) 
 print_r($e);
 
 

EDIT (browser version to process 10 products at a time)

Run this script in the browser as shell/makechildrennotvisible.php?page=1 and increment the page value each time until all products have been procesed. E.g.

www.example.com/shell/makechildrennotvisible.php?page=1

www.example.com/shell/makechildrennotvisible.php?page=2

www.example.com/shell/makechildrennotvisible.php?page=3

<?php
include_once '../app/Mage.php';
Mage::app()->setCurrentStore( Mage_Core_Model_App::ADMIN_STORE_ID );

// Get the current page from $_GET
$curPage = intval(Mage::app()->getRequest()->getParam('page'));
$curPage = $curPage < 1 ? 1 : $curPage;

// Get all configurable and grouped products
$products = Mage::getModel('catalog/product')
 ->getCollection()
 ->addAttributeToSelect('name')
 ->addAttributeToFilter('type_id', array('in' => array('configurable', 'grouped')))
 ->setPageSize(10);

$curPage = $curPage > $products->getLastPageNumber() ? $products->getLastPageNumber() : $curPage;
$products->setCurPage($curPage);

printf("Processing page %s of %s<br/>", $curPage, $products->getLastPageNumber());

// Loop each configurable product
foreach ($products as $_product) 
 // Get the child products for this product
 if ($_product->getTypeId() == 'configurable') 
 $simpleProducts = $_product->getTypeInstance(true)->getUsedProductIds($_product);
 elseif ($_product->getTypeId() == 'grouped') 
 $simpleProducts = $_product->getTypeInstance(true)->getAssociatedProductIds($_product);
 
 printf("Setting children of Product ID %s<br/>", $_product->getId());
 // Loop each child product
 foreach($simpleProducts as $_simpleID) 
 try 
 // Set associated product as not visible
 $_simple = Mage::getModel('catalog/product')->load($_simpleID);
 $_simple->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_NOT_VISIBLE);
 $_simple->save();
 printf("Product ID %s saved as 'Not Visible Individually'<br/>", $_simple->getId());
 catch ( Exception $e ) 
 print_r($e);