Magento – Get associated products of group in parts

collection;productproduct-collection

I need to load associate products in parts/portions.

I am showing 3 products default. After that I have added a link ("load more"). Once the user clicks on "load more", the next 3 products should be added in the table.

Maybe this could be DONE by Offset but how can I do this? I don't understand.

I don't know how I can get associate products collection.

Please help if any one know how I divide associated collection in parts/portions.

Below is my code

        $product = Mage::getModel('catalog/product');
$product->load('157902');
         $associatedProducts = $product->getTypeInstance(true)->getAssociatedProducts($product)->setCurPage(2)->setPageSize(2);

But collection is empty when I used offset , current page or page size

Best Answer

This should do what you are looking for, setCurPage is the start of the Offset, and setPageSize is the number of items return starting from the offset:

$product = Mage::getModel('catalog/product');
$product->load('157902');
$_simples = Mage::getModel('catalog/product_type_grouped')->getAssociatedProductCollection($product)->setCurPage(0)->setPageSize(2);
foreach ($_simples as $key => $value) {
    Zend_Debug::dump($value->getEntityId());
}

Related Solutions

Magento 1.7 – Work with Custom Product Attribute Without Loading the Product Object

Get your collection like this.

$productsCollection = Mage::getModel('catalog/product')->getCollection()->addAttributeToSelect('customizableonly');

And here is an other way of updating all products at once so you don't have to call saveAttribute 2k times.
From what I understand, you want to set the value for customizableonly to 0 for all the products that don't have that value.
Here goes:

$toUpdate = array();
foreach ($productsCollection as $_product) {
    if (is_null($_product->getCustomizableonly())) {
        //remember the id for update
        $toUpdate[] = $_product->getId();
    }
}

//update all products
Mage::getSingleton('catalog/product_action')->updateAttributes($toUpdate, array('customizableonly'=>0), 0);

This should get you a boost in speed.

Grouped Products – Link from Associated Product Name to Detailed Product Page

You can make the associated product names clickable by editing the template file : /app/design/frontend/{package}/{theme}/template/catalog/product/view/type/grouped.phtml and replace

<td><?php echo $this->escapeHtml($_item->getName()) ?></td>

with

<td>
   <?php if ($_item->getVisibility() != Mage_Catalog_Model_Product_Visibility::VISIBILITY_NOT_VISIBLE)) : //if simple product is visible?>
        <a href="<?php echo $_item->getProductUrl()?>"><?php echo $this->escapeHtml($_item->getName()) ?></a>
   <?php else :?>
       <?php echo $this->escapeHtml($_item->getName()) ?>
   <?php endif;?>
</td>

Best Answer

Related Solutions

Magento 1.7 – Work with Custom Product Attribute Without Loading the Product Object

Grouped Products – Link from Associated Product Name to Detailed Product Page

Related Topic