sql - Magento:有没有办法将所有可配置产品设置为 "Not Visible Individually"

Question

我想将可配置产品的所有子项设置为“单独不可见”，并且还为可配置产品的子项激活网站下的复选框。

有办法吗？

Answer 1

如果您没有 MySQL 访问权限，我相信这也可以:

$sites=Mage::app()->getWebsites(true);
foreach($sites as $site){
    $site_list[]=$site->getWebsiteId();
}

$products=Mage::getResourceModel("catalog/product_collection")->addAttributeToFilter("type_id","configurable");

foreach ($products as $product){
    $child_products = $product->getTypeInstance()->getAssociatedProducts();

    $child_product_ids=array();

    foreach($child_products as $child_product){
        array_push($child_product_ids,$child_product->getId());
    }

    Mage::getSingleton('catalog/product_action')->updateAttributes(
        $child_product_ids,
        array(
            'visibility' => "1",
            'website_ids' => $site_list
        ),
        Mage::app()->getStore()->getId()
    );

}