Magento查询系统还有那些产品没有设置Group Price的代码

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

学习笔记666

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

阅读量517

点赞数

分类专栏： Magento

本文链接：https://blog.csdn.net/github_26672553/article/details/50424290

版权

Magento 专栏收录该内容

133 篇文章 2 订阅

订阅专栏

<?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, sku  FROM catalog_product_entity";  
$results = $read->fetchAll($sql); 
foreach ($results as $row)   
{  
    //2.
    $read= Mage::getSingleton('core/resource')->getConnection('core_read');
    $sql = "SELECT * FROM catalog_product_entity_group_price where entity_id={$row['entity_id']}";  
    $results = $read->fetchOne($sql); 
    if (empty($results)) {
      echo  $row['sku'].'<br>'; 
    }
}