Swap long and short description

Question

Is there an easy way to swap the long and short descriptions in the mysql database for a magento 2.2.0 installation for all products?

Answer 1

1. Make a New File in Magento Root name it 'swap-product-desc.php'

2. Add Below Code in that file and run it by url : 'your-site-url/swap-product-desc.php'.

   <?php 
   
   use \Magento\Framework\App\Bootstrap;
   include('app/bootstrap.php');
   
   // add bootstrap
   $bootstraps = Bootstrap::create(BP, $_SERVER);
   $object_Manager = $bootstraps->getObjectManager();
   
   $app_state = $object_Manager->get('\Magento\Framework\App\State');
   $app_state->setAreaCode('frontend'); 
   
   $productCollection = $object_Manager->create('\Magento\Catalog\Model\Product')->getCollection();
   
   foreach($productCollection as $product){
   
      $productObject     =  $object_Manager->create('\Magento\Catalog\Model\Product')->load($product->getId());
   
      try{
        $productDesc       = $productObject->getDescription();
        $productShortDesc  = $productObject->getShortDescription();
   
        $productObject->setDescription($productShortDesc);
        $productObject->setShortDescription($productDesc);
   
        $productObject->save();
   
        echo "Product ID :".$productObject->getId()." DESCRIPTIONS Swapped Successfully.<br>";
      }
      catch(Exception $e)
     {
       // errro in exception/code
       print_r('Error in Product Desc Swapping For Product ID : '.$productObject->getId().' : '.$e->getMessage().'<br>');
     }
   }