php - Magento - Get Best Sellers Product including Soldout Products -


this code products available in stock. want products, including sold-out. have idea?

 $productcount = 5;         $storeid    = mage::app()->getstore()->getid();    $productsbestsellermens = mage::getresourcemodel('reports/product_collection')             ->addorderedqty()             ->addattributetoselect('*')               ->setstoreid($storeid)             ->addcategoryfilter($mensid)             ->setpagesize($productcount);

the comment osdave place start finding answer question.

at it's heart magento uses zend_db when accessing database. result can use 'magic' __tostring() method of zend_db_select output underlying mysql query generated php code. category filtering specific situation i've adapted original code slightly:

$productcount   = 5; $storeid        = mage::app()->getstore()->getid();  $productsbestsellermens = mage::getresourcemodel('reports/product_collection')     ->addorderedqty()     ->addattributetoselect('*')       ->setstoreid($storeid)     ->setpagesize($productcount);  var_dump((string) $productsbestsellermens->getselect()); exit;

this crude simple way of finding resulting sql query is:

select  sum(order_items.qty_ordered) `ordered_qty`, `order_items`.`name` `order_items_name`, `order_items`.`product_id` `entity_id`, `e`.`entity_type_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`sku`, `e`.`has_options`, `e`.`required_options`, `e`.`created_at`, `e`.`updated_at`  `sales_flat_order_item` `order_items`  inner join `sales_flat_order` `order` on `order`.entity_id = order_items.order_id , `order`.state <> 'canceled'  left join `catalog_product_entity` `e` on (e.type_id not in ('grouped', 'configurable', 'bundle')) , e.entity_id = order_items.product_id , e.entity_type_id = 4  (parent_item_id null)  group `order_items`.`product_id`  having (sum(order_items.qty_ordered) > 0)

as can see reviewing query there nothing filters 'sold out' products.

you can handle display of 'sold out' products using issaleable() method of mage_catalog_model_product class. example of in practice shown within magento template file /app/design/frontend/base/default/template/catalog/product/view.phtml.

it's worth noting when tried use same method pull list of best-sellers found results didn't match audited sales data. fuller investigation , corrected method retrieving best sellers macth auditedsales data available on our blog.


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more