不通过后台快速更新Magento库存_magento教程_php教程

Magento通过后台更新库存的时候，会把一些自定义的项目都自动变为默认的，这个不友好；而且通过后台更新库存的速度也比较慢；现在弄一个更快更新库存的方法。
1.创建一个CSV文件（stocks.csv），里面包含两列，一列SKU，一列QTY，然后把对应的要更新的SKU和QTY都写入到这个CSV里，然后上传到网站的根目录下。
2.创建一个 update_stocks.php 文件，并且放在网站根目录下，代码如下：

/**

* @author Jeffrey

* @website http://www.最模板zuimoban.com

* @category Export / Import

$mageFilename = 'app/Mage.php';

require_once $mageFilename;

Mage::setIsDeveloperMode(true);

ini_set('display_errors', 1);

umask(0);

Mage::app('admin');

Mage::register('isSecureArea', 1);

Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

set_time_limit(0);

ini_set('memory_limit','1024M');

/***************** UTILITY FUNCTIONS ********************/

function _getConnection($type = 'core_read'){

return Mage::getSingleton('core/resource')->getConnection($type);

}

function _getTableName($tableName){

return Mage::getSingleton('core/resource')->getTableName($tableName);

}

function _getAttributeId($attribute_code = 'price'){

$connection = _getConnection('core_read');

$sql = "SELECT attribute_id

FROM " . _getTableName('eav_attribute') . "

WHERE

entity_type_id = ?

AND attribute_code = ?";

$entity_type_id = _getEntityTypeId();

return $connection->fetchOne($sql, array($entity_type_id, $attribute_code));

}

function _getEntityTypeId($entity_type_code = 'catalog_product'){

$connection = _getConnection('core_read');

$sql = "SELECT entity_type_id FROM " . _getTableName('eav_entity_type') . " WHERE entity_type_code = ?";

return $connection->fetchOne($sql, array($entity_type_code));

}

function _checkIfSkuExists($sku){

$connection = _getConnection('core_read');

$sql = "SELECT COUNT(*) AS count_no FROM " . _getTableName('catalog_product_entity') . " WHERE sku = ?";

$count = $connection->fetchOne($sql, array($sku));

if($count > 0){

return true;

}else{

return false;

}

function _getIdFromSku($sku){

$connection = _getConnection('core_read');

$sql = "SELECT entity_id FROM " . _getTableName('catalog_product_entity') . " WHERE sku = ?";

return $connection->fetchOne($sql, array($sku));

}

function _updateStocks($data){

$connection = _getConnection('core_write');

$sku = $data[0];

$newQty = $data[1];

$productId = _getIdFromSku($sku);

$attributeId = _getAttributeId();

$sql = "UPDATE " . _getTableName('cataloginventory_stock_item') . " csi,

" . _getTableName('cataloginventory_stock_status') . " css

SET

csi.qty = ?,

csi.is_in_stock = ?,

css.qty = ?,

css.stock_status = ?

WHERE

csi.product_id = ?

AND csi.product_id = css.product_id";

$isInStock = $newQty > 0 ? 1 : 0;

$stockStatus = $newQty > 0 ? 1 : 0;

$connection->query($sql, array($newQty, $isInStock, $newQty, $stockStatus, $productId));

}

/***************** UTILITY FUNCTIONS ********************/

$csv = new Varien_File_Csv();

$data = $csv->getData('stocks.csv'); //path to csv

array_shift($data);

$message = '';

$count = 1;

foreach($data as $_data){

if(_checkIfSkuExists($_data[0])){

try{

_updateStocks($_data);

$message .= $count . '> Success:: Qty (' . $_data[1] . ') of Sku (' . $_data[0] . ') has been updated.
';

}catch(Exception $e){

$message .= $count .'> Error:: while Upating Qty (' . $_data[1] . ') of Sku (' . $_data[0] . ') => '.$e->getMessage().'
';

}

}else{

$message .= $count .'> Error:: Product with Sku (' . $_data[0] . ') does\'t exist.
';

}

$count++;

}

echo $message;
?>

3.在浏览器里输入 http://域名/update_stocks.php 回车即可快速更新库存(责任编辑：最模板)