CODEWITHSUNDEEP
magentoproductconfigurable
SebiF
SebiF

Reputation: 509

Magento: "Products Ordered" report - how to show child products of configurable product?

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.

Upvotes: 3

Views: 4317

Answers (1)

SebiF
SebiF

Reputation: 509

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/

Upvotes: 8

Related Questions