![\"magento](\"http:\/\/magebrew.com\/blog\/wp-content\/uploads\/2015\/12\/magento-set-image.png\")
<\/a><\/p>\n<\/p>\n
So it is going to be a shell script that you can launch from command line. It will help us not to face with\u00a0PHP execution time and memory limits. What is the plan of attack?<\/p>\n
- \n
- Firstly we grab\u00a0all products ids that have ‘no_selection’ value in database (catalog_product_entity_varchar<\/em> table) as\u00a0Base Image.<\/li>\n
- Then get\u00a0products ids that have missing image value record in catalog_product_entity_varchar<\/em> table.<\/li>\n
- Next step is to combine those ids.<\/li>\n
- Get\u00a0id to image<\/em> relation from\u00a0catalog_product_entity_media_gallery<\/em> table.<\/li>\n
- Set Base Image \/\u00a0Small Image \/\u00a0Thumbnail.<\/li>\n<\/ul>\n
For the last step we use\u00a0saveAttribute<\/em> method of product resource model. But please note that we have to modify this method to use default store id 0, otherwise you will set images for wrong store.<\/p>\n
Here is how this method looks like:<\/p>\n
\/\/file app\/code\/local\/Magebrew\/SetImage\/Model\/Resource\/Catalog\/Product.php\r\n\r\n protected function _saveAttributeValue($object, $attribute, $value)\r\n {\r\n $write = $this->_getWriteAdapter();\r\n \/\/set default store id\r\n $storeId = Mage_Catalog_Model_Abstract::DEFAULT_STORE_ID;\r\n $table = $attribute->getBackend()->getTable();\r\n\r\n \/**\r\n * If we work in single store mode all values should be saved just\r\n * for default store id\r\n * In this case we clear all not default values\r\n *\/\r\n if (Mage::app()->isSingleStoreMode()) {\r\n $storeId = $this->getDefaultStoreId();\r\n $write->delete($table, array(\r\n 'attribute_id = ?' => $attribute->getAttributeId(),\r\n 'entity_id = ?' => $object->getEntityId(),\r\n 'store_id <> ?' => $storeId\r\n ));\r\n }\r\n\r\n $data = new Varien_Object(array(\r\n 'entity_type_id' => $attribute->getEntityTypeId(),\r\n 'attribute_id' => $attribute->getAttributeId(),\r\n 'store_id' => $storeId,\r\n 'entity_id' => $object->getEntityId(),\r\n 'value' => $this->_prepareValueForSave($value, $attribute)\r\n ));\r\n $bind = $this->_prepareDataForTable($data, $table);\r\n\r\n if ($attribute->isScopeStore()) {\r\n \/**\r\n * Update attribute value for store\r\n *\/\r\n $this->_attributeValuesToSave[$table][] = $bind;\r\n } else if ($attribute->isScopeWebsite() && $storeId != $this->getDefaultStoreId()) {\r\n \/**\r\n * Update attribute value for website\r\n *\/\r\n $storeIds = Mage::app()->getStore($storeId)->getWebsite()->getStoreIds(true);\r\n foreach ($storeIds as $storeId) {\r\n $bind['store_id'] = (int)$storeId;\r\n $this->_attributeValuesToSave[$table][] = $bind;\r\n }\r\n } else {\r\n \/**\r\n * Update global attribute value\r\n *\/\r\n $bind['store_id'] = $this->getDefaultStoreId();\r\n $this->_attributeValuesToSave[$table][] = $bind;\r\n }\r\n\r\n return $this;\r\n }\r\n<\/pre>\nAnd finally our shell script:<\/p>\n
\/\/file shell\/setBaseImage.php\r\nrequire_once 'abstract.php';\r\n\r\nclass Magebrew_Set_Image extends Mage_Shell_Abstract\r\n{\r\n \/**\r\n * Run script\r\n *\r\n *\/\r\n public function run()\r\n {\r\n $installer = new Mage_Catalog_Model_Resource_Setup('core_setup');\r\n try {\r\n \/\/grab all products ids that have 'no_selection' value in database\r\n $noSelectionSelect = $installer->getConnection()->select()\r\n ->from(\r\n array('product' => $installer->getTable('catalog\/product')),\r\n array('id' => 'product.entity_id')\r\n )\r\n ->join(\r\n array('varchar_table' => $installer->getTable('catalog_product_entity_varchar')),\r\n 'varchar_table.entity_id = product.entity_id',\r\n array()\r\n )\r\n ->join(\r\n array('eav_table' => $installer->getTable('eav\/attribute')),\r\n 'varchar_table.attribute_id = eav_table.attribute_id',\r\n array()\r\n )\r\n ->where('eav_table.attribute_code = \"image\" AND eav_table.entity_type_id = 4 AND varchar_table.value = \"no_selection\" AND varchar_table.store_id = 0');\r\n\r\n \/\/get products ids that have missing image value record\r\n $missingImageValueSelectInner = $installer->getConnection()->select()\r\n ->from(\r\n array('product' => $installer->getTable('catalog\/product')),\r\n array('id' => 'product.entity_id')\r\n )\r\n ->join(\r\n array('varchar_table' => $installer->getTable('catalog_product_entity_varchar')),\r\n 'varchar_table.entity_id = product.entity_id',\r\n array()\r\n )\r\n ->join(\r\n array('eav_table' => $installer->getTable('eav\/attribute')),\r\n 'varchar_table.attribute_id = eav_table.attribute_id',\r\n array()\r\n )\r\n ->where('eav_table.attribute_code = \"image\" AND eav_table.entity_type_id = 4 AND varchar_table.store_id = 0');\r\n\r\n $missingImageValueSelect = $installer->getConnection()->select()\r\n ->from(\r\n array('product' => $installer->getTable('catalog\/product')),\r\n array('id' => 'product.entity_id')\r\n )\r\n ->where('product.entity_id NOT IN ?', $missingImageValueSelectInner);\r\n\r\n \/\/combine ids.\r\n $unitedSselect = $installer->getConnection()->select()->union(array($noSelectionSelect, $missingImageValueSelect));\r\n $ids = $installer->getConnection()->fetchCol($unitedSselect);\r\n Mage::log(sprintf(\"found %s candidats for setting image\", count($ids)), null, 'image_set.log', true);\r\n\r\n \/\/Get id to image relation from catalog_product_entity_media_gallery table\r\n $mediaSelect = $installer->getConnection()->select()\r\n ->from(array('gallery' => $installer->getTable('catalog_product_entity_media_gallery')), array('id' => 'entity_id', 'value'))\r\n ->join(\r\n array('gallery_value' => $installer->getTable('catalog_product_entity_media_gallery_value')),\r\n 'gallery_value.value_id = gallery.value_id AND store_id = 0',\r\n array()\r\n )\r\n ->where('entity_id in (?)', $ids)\r\n ->order('position asc');\r\n $query = $installer->getConnection()->query($mediaSelect);\r\n $idToImage = array();\r\n while ($row = $query->fetch()) {\r\n if (!isset($idToImage[$row['id']])) {\r\n $idToImage[$row['id']] = $row['value'];\r\n }\r\n }\r\n\r\n \/\/Mage::log($idToImage, null, 'image_set.log', true);\r\n \/** @var Magebrew_SetImage_Model_Resource_Catalog_Product $resource *\/\r\n $resource = Mage::getModel('magebrew_setimage\/resource_catalog_product');\r\n foreach ($idToImage as $id => $image) {\r\n $product = Mage::getModel('catalog\/product')->setId($id);\r\n $product->setStoreId(Mage_Catalog_Model_Abstract::DEFAULT_STORE_ID);\r\n $product->setImage($image);\r\n $product->setSmallImage($image);\r\n $product->setThumbnail($image);\r\n Mage::log(sprintf(\"trying to set image %s to product %s\", $image, $id), null, 'image_set.log', true);\r\n $resource->saveAttribute($product, 'image');\r\n $resource->saveAttribute($product, 'small_image');\r\n $resource->saveAttribute($product, 'thumbnail');\r\n echo 'set images for product ' . $id . PHP_EOL;\r\n }\r\n echo 'Finished' . PHP_EOL;\r\n } catch (Exception $e) {\r\n echo $e->getMessage() . \"\\n\";\r\n }\r\n }\r\n}\r\n\r\n$shell = new Magebrew_Set_Image();\r\n$shell->run();\r\n<\/pre>\n - Then get\u00a0products ids that have missing image value record in catalog_product_entity_varchar<\/em> table.<\/li>\n