本文共 1677 字,大约阅读时间需要 5 分钟。
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(),""; }
转载地址:http://rksmb.baihongyu.com/