magento 获取产品的销售量

最新推荐文章于 2021-05-17 16:03:48 发布

cclehui

最新推荐文章于 2021-05-17 16:03:48 发布

阅读量2.2k

点赞数

分类专栏： magento 文章标签： ordered_qty

本文链接：https://blog.csdn.net/clh604/article/details/8157952

版权

magento 专栏收录该内容

35 篇文章 1 订阅

订阅专栏

1、如已知产品ID为1

$collection = Mage::getResourceModel('reports/product_sold_collection')
                                ->addOrderedQty()
                                ->setStoreId(1)
                                ->addStoreFilter(1)
                                ->addUrlRewrite()
				->addAttributeToFilter('visibility', array('in' => array(Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_CATALOG, Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH)))
				->addAttributeToFilter('status', Mage_Catalog_Model_Product_Status::STATUS_ENABLED)
                                ->setOrder('ordered_qty', 'desc')
				->addIdFilter(1);
    $collection->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds());
 foreach($collection as $item){
	echo '产品',$item->getOrderItemsName(),'的销售量为:',$item->getOrderedQty(),"";
    }

2、获取所有产品的销售量

$collection = Mage::getResourceModel('reports/product_sold_collection')
                                ->addOrderedQty()
                                ->setStoreId(1)
                                ->addStoreFilter(1)
                                ->addUrlRewrite()
				->addAttributeToFilter('visibility', array('in' => array(Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_CATALOG, Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH)))
				->addAttributeToFilter('status', Mage_Catalog_Model_Product_Status::STATUS_ENABLED)
                                ->setOrder('ordered_qty', 'desc')
    $collection->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds());
 foreach($collection as $item){
	echo '产品',$item->getOrderItemsName(),'的销售量为:',$item->getOrderedQty(),"";
    }