Magento : Update price and QTY based on sku price

Question

I have script for the update price and QTY but it takes too much time on live server.I am trying to execute script for 4 to 5 hours but unable complete process. I have also tested script on my localhost it takes around 1 Hour and 30 Min to update 1400 products.

Please check my below script and suggest me idea so i can reduce timing for local and live both.

<?php

require_once 'app/Mage.php';
$app = Mage::app('default');
ini_set('max_execution_time', 0);
$currentStore = Mage::app()->getStore()->getId();
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
umask(0);

$path = ''.$_SERVER['DOCUMENT_ROOT'].'/product_stock_price.csv';
$readfile = file ($path);
$j=0;$k=0;
for ($i=1; $i < count($readfile); $i++ ) {
    $fields = split('"',$readfile[$i]);
    $sku=split(',',$fields[0]);
    $arr=array('sku'=>$sku[0],'stock'=>$fields[1],'price'=>$fields[3]);
    //print_r($arr);
    $sku= $arr['sku'];
    //print_r($sku);die;
    $product = Mage::getModel('catalog/product')->setStoreId(1)->loadByAttribute('sku',$sku);

    if ($product) 
    {
        //echo $product->getPrice(); 
        $product->setWebsiteId(1);
        $product->setStoreId(1);
        $product->setPrice($fields[3]);
        $product->save();

        $productId = $product->getId();
        $stockItem =Mage::getModel('cataloginventory/stock_item')->loadByProduct($productId);
        $stockItemId = $stockItem->getId();

        $stockItem->setData('manage_stock', 1);
        $stockItem->setData('qty', $fields[1]);

        $stockItem->save();

       // echo $SKU," Updated: Name: '",(string)$XMLproduct->Name,"', Price: ",$fields[3],", Stock level: ",$fields[1];

        $updated++;
        $j+=1;
    }
    else
    {
        $k+=1;
        echo $sku." product not found.</br>";
    } 
}

echo "Total Row : ".count($readfile)." Proceed row : ".$i." Inserted Row : ".$j." Not Found : ".$k;


?>

Please give me some solution.

Thanks Jalpesh

Just set `max_execution_time` to 0 for no limit. Setting it to 18 trillion seconds is a bit silly. — Anthony, Nov 07 '13 at 07:21

score 0 · Answer 1 · edited May 23 '17 at 11:50

0

The process is too much heavy since it is running on big catalog. Instead of using model/collection, you can fire direct sql queries with minimal possible joins as per you need. You can easily create sql or just search for queries like to update qty is at Magento - update all products inventory with sql

edited May 23 '17 at 11:50

Community

1
1

answered Nov 07 '13 at 07:03

Deependra Singh

1,504
16
31

Thanks for reply but your given url has not any way to update price. – Jalpesh Patel Nov 07 '13 at 07:41
That was just one example that you can find your sql queries just by googling. My solution was that you should be using sql queries. – Deependra Singh Nov 07 '13 at 08:05

Magento : Update price and QTY based on sku price

1 Answers1