Set child product category to the same as parent product

Question

Having problems with setting up Google Shopping integration. A majority of my products have a parent product which holds the general information about it, other than size or colour. I have have associated products that include the information for the product, as well as size ect.. These products are set as non visible, however, the parent products are set to Catalog and search.

All of my child products do not have their categories set to the same as the parent product. How can I assign these attributes after the product has been created?

I have over 1000 products which need the category information updating to the same as its parent product, so I need something that will do this all in one.

Thanks.

Answer 1

You can put a script in your shell folder, e.g. update_categories.php with:

Mage::app();
$products = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToFilter('type_id', Mage_Catalog_Model_Product_Type::TYPE_SIMPLE)
    ->addAttributeToFilter('category_ids','')
    ->addAttributeToSelect('*');
$products->load();

foreach($products as $product) { 
    $parentIds = Mage::getModel('catalog/product_type_configurable')->getParentIdsByChild($product->getId());
    foreach($parentIds as $parentId) {
        $parent = Mage::getModel('catalog/product')->load($parentId);
        $product->setCategoryIds($parent->getCategoryIds());
        $product->save();
        continue;
    }
}

If you then run this then it should iterate over the simple products that do not belong to a category, then (if they have a configurable parent) update those products so that they now have the category_ids of that parent.

You could run this script on a cron or other job to 'tidy' the products before you submit your data.

Note this code loads what could be a large product collection and may need more work to be memory efficient.