Skip to main content

Magento 2 add/update configure products meta title, Description programetically using custom script

Magento 2 add/update meta values of configure products using custom script

 <?php  
 //increase the max execution time  
 @ini_set('max_execution_time', -1);  
 //memory_limit  
 @ini_set('memory_limit', -1);  
 error_reporting(E_ALL);  
 ini_set('display_errors', '1');  
 use \Magento\Framework\App\Bootstrap;  
 require __DIR__ . '/app/bootstrap.php';  
 $bootstrap   = Bootstrap::create(BP, $_SERVER);  
 $objectManager = $bootstrap->getObjectManager();  
 $instance   = \Magento\Framework\App\ObjectManager::getInstance();  
 $state     = $objectManager->get('\Magento\Framework\App\State');  
 $state->setAreaCode('frontend');  
 $product_collections = $instance->get('\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');  
 $collections     = $product_collections->create()->addAttributeToFilter('type_id', 'configurable');  
 foreach ($collections as $product) {  
   echo "<pre>";  
   echo 'Produc Id : ' . $product->getId();  
   echo "<br>";  
   $sku = $product->getSku();  
   echo 'Produc SKU : ' . $sku;  
   echo "<br>";  
   $productIdBySku = $product->getIdBySku($sku);  
   echo "<br>";  
   echo 'Produc Id BY SKU : ' . $productIdBySku;  
   echo "<br>";  
   $product = $objectManager->get('\Magento\Catalog\Model\Product')->setStoreId(0)->load($productIdBySku);  
   //$category = $objectManager->create('Magento\Catalog\Model\CategoryFactory')->create()->setStoreId(0)->load($catId)  
   //echo $product->getName();  
   echo 'Produc Name : ' . $productTitle = $product->getName();  
   $metaTitle = $productTitle . ' {Content}';  
   $metaDescription = '{Content} ' . $productTitle . ' {Content}.';  
   $product->setMetaTitle($metaTitle);  
   $product->setMetaDescription($metaDescription);  
   $product->save();  
   echo "<pre>";  
   echo $product->getMetaTitle();  
   echo "</br>";  
   echo $product->getMetaDescription();  
   /*}*/  
 }  
 ?>  

Comments

Popular posts from this blog

Magento 2 get category collection using specific controllers and category level using object manager

Magento 2 get category collection using object manager <?php $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $category = $objectManager->get('Magento\Framework\Registry') ->registry('current_category'); //get current category $requestInterface = $objectManager->get('Magento\Framework\App\RequestInterface'); //echo $routeName = $requestInterface->getRouteName(); //echo $moduleName = $requestInterface->getModuleName(); $controllerName = $requestInterface->getControllerName(); //echo $actionName = $requestInterface->getActionName(); $parcatId = $category->getId(); // current Category ID $parcategory = $objectManager->create('Magento\Catalog\Model\Category') ->load($parcatId); $parent_category = $parcategory->getParentCategory(); $subcatId = $parent_category->getId(); $subcategory = $objectManager->create('Magento\Catalog\Model\Category...

Magento 2 Update product image attributes value using custom script programetically

Magento 2 Update product image programetically <?php //increase the max execution time @ini_set('max_execution_time', -1); //memory_limit @ini_set('memory_limit', -1); error_reporting(E_ALL); ini_set('display_errors', '1'); use \Magento\Framework\App\Bootstrap; require __DIR__ . '/app/bootstrap.php'; $bootstrap = Bootstrap::create(BP, $_SERVER); $objectManager = $bootstrap->getObjectManager(); $instance = \Magento\Framework\App\ObjectManager::getInstance(); $state = $objectManager->get('\Magento\Framework\App\State'); $state->setAreaCode('frontend'); $product_collections = $instance->get('\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory'); $collections = $product_collections->create(); foreach ($collections as $product) { if ($product->getId() == 2052) { $product = $objectManager->create('\Magento\Catalog\Model\Pr...

Magento 2 check product attribute values in database using mysql query

Magento 2 check product attribute in database using mysql query SELECT * FROM `catalog_product_entity_text` where store_id = 1; SELECT * FROM `catalog_product_entity_datetime` where store_id = 1; SELECT * FROM `catalog_product_entity_decimal` where store_id = 1; SELECT * FROM `catalog_product_entity_int` where store_id = 1; SELECT * FROM `catalog_product_entity_varchar` where store_id = 1; Note : In above SQL query store_id 1 is ID of store. kindly you need to check store Id for all store-views in admin and run the above code for each store-views separately.