Magento 把所有产品的 Special Price 同步添加给Group Price代码

最新推荐文章于 2019-04-03 15:34:00 发布

原创最新推荐文章于 2019-04-03 15:34:00 发布 · 532 阅读

0 ·

CC 4.0 BY-SA版权

Magento 专栏收录该内容

133 篇文章

订阅专栏

本文介绍了一段用于Magento系统的PHP脚本，该脚本能够批量读取产品的小数属性值，并将这些值作为特定条件下的组价进行插入。通过数据库操作实现产品价格的批量更新。

<?php
error_reporting(E_ALL);
set_time_limit(0);
define('MAGENTO', realpath(dirname(__FILE__)));
require_once MAGENTO . '/app/Mage.php';
umask(0);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);




//1.
$read= Mage::getSingleton('core/resource')->getConnection('core_read');
$sql = "SELECT entity_id,`value` from catalog_product_entity_decimal  WHERE attribute_id=76";  
$results = $read->fetchAll($sql); 
 
foreach ($results as $row)   
{  
    // echo $row['entity_id'].'==>'.$row['value'] . "<br/>";  

    if (!empty($row['value'])) {
        // echo $row['entity_id'].'==>'.$row['value'] . "\n"; 
        $read= Mage::getSingleton('core/resource')->getConnection('core_read');
        $sql = "select * from catalog_product_entity_group_price where entity_id={$row['entity_id']}";  
        $results = $read->fetchAll($sql);
        
        if (empty($results)) {
             $write = Mage::getSingleton('core/resource')->getConnection('core_write'); 
             $sql = "INSERT INTO catalog_product_entity_group_price (`entity_id`,`all_groups`,`customer_group_id`,`VALUE`) VALUES ({$row['entity_id']},0,1,{$row['value']})"; 
             $write->query($sql);
             // echo $sql.'<br>';  
        } 
    }
}