Magento 2.1 Load Product By ID and Change SKU Programmatically

Question

I used a third party service to transfer products from woocommerce to magento, but many of the products don't have SKUs.

I attempted to do this using a CSV file containing a column of IDs and a column of SKUS. Help me make this happen.

<?php
umask(0);
if (($handle = fopen("skus.csv", "r")) !== FALSE) { 
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $objectManager = \Magento\Framework\App\ObjectManager::getInstance();
        $product_id = $data[0];
        $newsku = $data[1];
        $product = $objectManager->get('Magento\Catalog\Model\Product')->load($product_id);
        if($product) { 
        echo 'working';
            $product->setSku($newsku);
            $product->save();
            echo  $product->getName() . ' SKU updated';
            echo "\n";
            }
    }
}
?>

Answer 1

I solved this by creating an extension using this function

protected $_productRepository;

public function __construct(
    \Magento\Backend\Block\Template\Context $context,        
    \Magento\Catalog\Model\ProductRepository $productRepository,
    array $data = []
)
{
    $this->_productRepository = $productRepository;
    parent::__construct($context, $data);
}

public function getProductById($id)
{
    return $this->_productRepository->getById($id);
}

}

then in my PHTML

$numofproducts = 1088;
$id = 1;
$sku = 1000;
while($id < $numofproducts) {
    $_product = $block->getProductById($id);
    echo $_product->getEntityId();
    echo '<br />';
    echo $_product->getName();
    echo $_product->getSKU();
    $_product->setSKU($sku)->save();
    echo $_product->getSKU();
    $id = $id + 1;
    $sku = $sku + 1;
}

Answer 2

In such a quick-and-dirty script this might work:

<?php
umask(0);

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$loader = $objectManager->get('Magento\Catalog\Model\ProductFactory');

if (($handle = fopen("skus.csv", "r")) !== FALSE) { 
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $product_id = $data[0];
        $newsku = $data[1];
        $product = $loader->create()->load($product_id);
        if($product) { 
            echo 'working';
            $product->setSku($newsku);
            $product->save();
            echo  $product->getName() . ' SKU updated';
            echo "\n";
        }
    }
}

As using the ObjectManager is discouraged, in a Magento module it would look more like this:

public function __construct(
    \Magento\Catalog\Model\ProductFactory $_productloader
) {
    $this->_productloader = $_productloader;
}

public function changeSku($id, $newSKU)
{
    $product = $this->_productloader->create()->load($id);
    $product->setSku('BAZ')->save();
}

Answer 3

Can you try something like this

protected $prodMod;

public function __construct(
  \Magento\Catalog\Model\Product $prodModel
){
   $this->prodModel = $prodModel;
}

public function loadById($productId){
   $prod = $prodModel->getResource()->load( $prodModel, $productId );
   if(!$prod->getId())
   {
       throw new \Exception(__("not found"));
   }

   $prod->setSku('FOO')->save();
}