Above screenshot given a csv file, in this have sku and quantity if we update qty in this csv file and save then automatically update in magento admin.
EX: like sku A016 have 25 quantity then if you want to update qty 35.
First of all upload csv file in root directory. And one php file upload in root like qty.php.
here is code... copy code and paste in qty.php file.
<?php
$mageFilename = 'app/Mage.php';
require_once $mageFilename;
Mage::setIsDeveloperMode(true);
ini_set('display_errors', 1);
umask(0);
Mage::app('admin');
set_time_limit(0);
ini_set('memory_limit','1024M');
$data = array() ;
if (($file = fopen("qtyupdate.csv", "r")) !== FALSE) // qtyupdate.csv is file which is have sku and quantity (above given screenshot)
{
while (($data = fgetcsv($file, 1000, ",")) !== FALSE)
{
$product = Mage::getModel('catalog/product');
$id = Mage::getModel('catalog/product')->getResource()->getIdBySku( $data[0] );
$product->load($id);
$stockItem = $product->getStockItem();
$stockItem->setData( 'manage_stock', $data[1] );
$stockItem->setData( 'is_in_stock', $data[1] );
$stockItem->setData( 'use_config_notify_stock_qty', $data[1] );
$stockItem->setData( 'qty', $data[1] );
$stockItem->save();
$product->save();
echo '<br/>';
}
fclose($file);
}
?>
After both file upload in root, run the url: yourdomain.com/qty.php
and update product quantity which is update in csv file.