When I create a "Products Ordered" report in Magento, configurable products show up as a single product, where the sales of all child products were summed up.
How can I modify this behaviour, so that - additionally - the child products are shown and their sold quantities?
The used version is Magento 1.6.2.
millejano from #magento-de helped me out and allowed me to post this answer:
Create a rewrite for or copy /app/code/core/Mage/Reports/Model/Resource/Product/Collection.php to local.
In addOrderedQty(), change the line
->where('parent_item_id IS NULL')
to
->where('e.type_id = ?', 'simple')
You're done. Instead of the summed up configurable product, you will now see the underlying simple products in every report and even on the dashboard.
Original post by millejano: https://gist.github.com/3149637/