Get product media gallery images from the product collection in Magento

Question

I have a collection of products in Magento that I would like to get from media gallery images. However, I found that I needed to repeat my collection and download the product again so that the getMediaGalleryImages () function worked correctly.

$products = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSelect('*') ->addAttributeToFilter('visibility', 4) ->addAttributeToFilter('status', 1); foreach($products as $product) { $_product = Mage::getModel('catalog/product')->load($product->getId()); $product->getMediaGalleryImages(); // This returns nothing $_product->getMediaGalleryImages(); // Returns the Collection of Images } 

Obviously, I could continue to just restart the product every time, but that would add a bit of overhead to the time it takes to run this code.

Is there any way to add images to the media gallery in the collection?

Answer 1

you can use

 $product->load('media_gallery'); 

before getMediaGalleryImages (for products uploaded to the collection).

Answer 2

upload a cached product image using the collection using the following codes

 Mage::helper('catalog/image')->init($_product, 'small_image')->resize(135); 

//or

 Mage::helper('catalog/image')->init($_product, 'thumbnail')->resize(135); 

//or

 Mage::helper('catalog/image')->init($_product, 'image')->resize(135); 

this is the collection in which I used

 $collection = Mage::getModel('catalog/product')->getCollection() ->addAttributeToSelect('small_image') //or ->addAttributeToSelect('thumbnail') //or ->addAttributeToSelect('image'); 

Answer 3

One easy way to use in the future:

Beyond your foreach add

 $mediaBackend = Mage::getModel('catalog/product_attribute_backend_media'); $mediaGalleryAttribute = Mage::getModel('eav/config')->getAttribute(Mage::getModel('catalog/product')->getResource()->getTypeId(), 'media_gallery'); $mediaBackend->setAttribute($mediaGalleryAttribute); 

and then run the foreach command:

 foreach ($productCollection as $product) { $mediaBackend->afterLoad($product); } 

You will have a gallery uploaded to the product.

Answer 4

You can create a helper class and use it every time you need media gallery images to download for a collection of products:

 class My_Package_Helper_Media extends Mage_Core_Helper_Abstract { public function addMediaGalleryAttributeToProductCollection( &$productCollection ) { $storeId = Mage::app()->getStore()->getId(); $ids = array(); foreach ( $productCollection as $product ) { $ids[] = $product->getEntityId(); } $resource = Mage::getSingleton( 'core/resource' ); $conn = Mage::getSingleton( 'core/resource' )->getConnection( 'catalog_read' ); $select = $conn->select() ->from( array( 'mg' => $resource->getTableName( 'catalog/product_attribute_media_gallery' ) ), array( 'mg.entity_id', 'mg.attribute_id', 'mg.value_id', 'file' => 'mg.value', 'mgv.label', 'mgv.position', 'mgv.disabled', 'label_default' => 'mgdv.label', 'position_default' => 'mgdv.position', 'disabled_default' => 'mgdv.disabled' ) ) ->joinLeft( array( 'mgv' => $resource->getTableName( 'catalog/product_attribute_media_gallery_value' ) ), '(mg.value_id=mgv.value_id AND mgv.store_id=' . $storeId . ')', array() ) ->joinLeft( array( 'mgdv' => $resource->getTableName( 'catalog/product_attribute_media_gallery_value' ) ), '(mg.value_id=mgdv.value_id AND mgdv.store_id=0)', array() ) ->where( 'entity_id IN(?)', $ids ); $mediaGalleryByProductId = array(); $stmt = $conn->query( $select ); while ( $gallery = $stmt->fetch() ) { $k = $gallery[ 'entity_id' ]; unset( $gallery[ 'entity_id' ] ); if ( !isset($mediaGalleryByProductId[$k]) ) { $mediaGalleryByProductId[$k] = array(); } $mediaGalleryByProductId[$k][] = $gallery; } unset( $stmt ); // finalize statement // Updating collection ... foreach ( $productCollection as &$product ) { $productId = $product->getEntityId(); if ( isset( $mediaGalleryByProductId[ $productId ] ) ) { $product->setData( 'media_gallery', array( 'images' => $mediaGalleryByProductId[ $productId ] ) ); } } unset( $mediaGalleryByProductId ); } } 

Sample Usage:

 $coll = Mage::getResourceModel('catalog/product_collection') ->setStoreId( Mage::app()->getStore()->getId() ) ->addAttributeToFilter( 'sku', array( 'in' => array( 'AAA', 'BBB' ) ) ); Mage::helper('my_package/media')->addMediaGalleryAttributeToProductCollection( $coll ); 

Answer 5

Here is the code you were looking for, sorry for the delay :)

From this discussion: http://www.magentocommerce.com/boards/viewthread/17414/

I just added an extra check on id a and pagination

 function addMediaGalleryAttributeToCollection(Mage_Catalog_Model_Resource_Product_Collection $_productCollection) { if (Mage::getStoreConfig('color_selector_plus/colorselectorplusgeneral/showonlist', Mage::app()->getStore())) { $_mediaGalleryAttributeId = Mage::getSingleton('eav/config')->getAttribute('catalog_product', 'media_gallery')->getAttributeId(); $_read = Mage::getSingleton('core/resource')->getConnection('catalog_read'); $pageCur = $_productCollection->getCurPage(); $pageSize = $_productCollection->getPageSize(); $offset = $pageSize * ($pageCur - 1); $ids = $_productCollection->getAllIds($pageSize, $offset); // added check on products number: if 0 ids the following query breaks if (count($ids) > 0) { $sql = ' SELECT main.entity_id, `main`.`value_id`, `main`.`value` AS `file`, `value`.`disabled`, /*`value`.`label`, `value`.`position`, */ /*`default_value`.`label` AS `label_default`, */ /*`default_value`.`position` AS `position_default`, */ `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main` LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id=value.value_id AND value.store_id=' . Mage::app()->getStore()->getId() . ' LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id=default_value.value_id AND default_value.store_id=0 WHERE ( main.attribute_id = ' . $_read->quote($_mediaGalleryAttributeId) . ') AND (main.entity_id IN (' . $_read->quote($_productCollection->getAllIds()) . ')) /*ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC */ '; $_mediaGalleryData = $_read->fetchAll($sql); $_mediaGalleryByProductId = array(); foreach ($_mediaGalleryData as $_galleryImage) { $k = $_galleryImage['entity_id']; unset($_galleryImage['entity_id']); if (!isset($_mediaGalleryByProductId[$k])) { $_mediaGalleryByProductId[$k] = array(); } $_mediaGalleryByProductId[$k][] = $_galleryImage; } unset($_mediaGalleryData); foreach ($_productCollection as &$_product) { $_productId = $_product->getData('entity_id'); if (isset($_mediaGalleryByProductId[$_productId])) { $_product->setData('media_gallery', array('images' => $_mediaGalleryByProductId[$_productId])); } } unset($_mediaGalleryByProductId); } } return $_productCollection; }