wrong order when sorting by price in admin product grid

Question

This is screen from my admin products grid, here I sorting by price column(low to high), but as you can see it's not working right. Can it be because some products are "downloadable" ?

Answer 1

I explored what sql query magento created for this sorting grid

SELECT `e`.*, `at_qty`.`qty`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` 
FROM `catalog_product_entity` AS `e`
LEFT JOIN `cataloginventory_stock_item` AS `at_qty` ON (at_qty.`product_id`=e.entity_id) AND (at_qty.stock_id=1) 
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 ORDER BY `price_index`.`min_price` ASC 

The interesting part is that it sorting by price_index.min_price So for configurable or downloadable products it will take min price of their childen