Skip to main content

Magento Copy Base Image To Thumbnail Image

--------------------------------------------------------------------------------
Copy Base Image To Thumbnail Image
--------------------------------------------------------------------------------
UPDATE catalog_product_entity_varchar AS ev,
       catalog_product_entity_varchar AS ev2
SET    ev.value = ev2.value
WHERE  ev.entity_id = ev2.entity_id
AND    ev.attribute_id =
       (
              SELECT `attribute_id`
              from   eav_attribute a
              WHERE  attribute_code = 'thumbnail'
             
              AND    entity_type_id =
                     (
                            SELECT `entity_type_id`
                            FROM   eav_entity_type e
                            WHERE  entity_type_code = "catalog_product"
))
AND    ev.value = 'no_selection'
AND    ev2.attribute_id =
       (
              SELECT `attribute_id`
              FROM   eav_attribute a
              WHERE  attribute_code = 'image'
              AND    entity_type_id =(SELECT `entity_type_id`
                            FROM   eav_entity_type e
                            WHERE  entity_type_code = "catalog_product"));
--------------------------------------------------------------------------------
Compare Base Image And Small Image
--------------------------------------------------------------------------------
SELECT `entity_id`
FROM   `catalog_product_entity_varchar`
WHERE  `attribute_id` = (
              SELECT `attribute_id`
              FROM   eav_attribute a
              WHERE  attribute_code = 'image'
              AND    entity_type_id =(SELECT `entity_type_id`
                            FROM   eav_entity_type e
                            WHERE  entity_type_code = "catalog_product"))
       AND `entity_id` NOT IN (SELECT `entity_id`
                               FROM   `catalog_product_entity_varchar`
                               WHERE  `attribute_id` = (
              SELECT `attribute_id`
              from   eav_attribute a
              WHERE  attribute_code = 'thumbnail'
             
              AND    entity_type_id =
                     (
                            SELECT `entity_type_id`
                            FROM   eav_entity_type e
                            WHERE  entity_type_code = "catalog_product"
)));
--------------------------------------------------------------------------------

Comments

Post a Comment

Popular posts from this blog

Magento 2 generate custom log

the custom log file created using below code for Magento 2.4.2 before version use this :  $writer = new \Zend\Log\Writer\Stream (BP . '/var/log/custom.log' ); $logger = new \Zend\Log\Logger (); $logger -> addWriter ( $writer ); $logger -> info ( 'Custom message' ); $logger -> info ( print_r ( $object -> getData (), true )); for Magento 2.4.2 or after version use this :  $writer = new \Laminas\Log\Writer\Stream (BP . '/var/log/custom.log' ); $logger = new \Laminas\Log\Logger (); $logger -> addWriter ( $writer ); $logger -> info ( 'text message' ); $logger -> info ( print_r ( $object -> getData (), true )); for Magento 2.4.3 version use this $writer = new \Zend_Log_Writer_Stream (BP . '/var/log/custom.log' ); $logger = new \Zend_Log (); $logger -> addWriter ( $writer ); $logger -> info ( 'text message' ); $logger -> info ( print_r ( $object -> getData (), true )); Or you can try this : f...
Post a Comment
Read more

Magento 2 Search Programatically

public function getSearchedProductIds($searchTerm){ //$searchTerm = "UKF8001"; $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $searchCriteriaBuilder = $objectManager->create('Magento\Framework\Api\Search\SearchCriteriaFactory'); $filterBuilder = $objectManager->create('Magento\Framework\Api\FilterBuilder'); $filterGroupBuilder = $objectManager->create('Magento\Framework\Api\Search\FilterGroupBuilder'); $searchInterface = $objectManager->create('Magento\Framework\Api\Search\SearchInterface'); $sortOrder = $objectManager->create('Magento\Framework\Api\SortOrder'); $search_criteria = $searchCriteriaBuilder->create(); $search_criteria->setRequestName("quick_search_container"); $filter = $filterBuilder->setField('search_term') ->setValue($searchTerm) ->setConditionType("like") ->create(); $filterGroup = $filterGroupB...
Post a Comment
Read more

Magento 2 Change Core Config Value Programmatically

$objectManager = \Magento\Framework\App\ObjectManager::getInstance(); // Instance of object manager $cacheTypeList = $objectManager->get('\Magento\Framework\App\Cache\TypeListInterface'); $cacheFrontendPool = $objectManager->get('\Magento\Framework\App\Cache\Frontend\Pool'); $resource = $objectManager->get('Magento\Framework\App\ResourceConnection'); $connection = $resource->getConnection(); $table = $resource->getTableName('core_config_data'); $select = $connection->select()->from( $table, ['config_id', 'value'] )->where( 'path = ?', 'carriers/storepickup/active' ); $data = $connection->fetchAll($select); if ($data) { try { $connection->beginTransaction(); foreach ($data as $value) { if($storeId == 1){ $dvalue = !(bool)1; }else{ $dvalue = 1; } $bind = ['path' => 'carriers/storepickup/active', 'value' => $dvalue]; $whe...
Post a Comment
Read more