Tell me more ×
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It's 100% free, no registration required.
up vote 0 down vote favorite

I need a SINGLE report showing all products purchased by all customers within a given time period. Similar to /report_customer/totals/key/xxxxxxxxxxxxxx/filter/, but instead of number of orders I would need to see which products they purchased.

Unless I am missing something, this report is not available using native 1.5.1 functionality. I also looked at these extensions, but none of them does what I need:

Reports Pro by Mage-Shop (put a dash between mage and shop to get URL to work)

Advanced Reports by aheadWorks

Handy Sales Tabs by Amasty

Product Orders by Customers by MageWorx

Since none of the extensions above do what I need, what would the the proper SQL query be to extract such data from Mage 1.5.1?

TIA!

share|improve this question

1 Answer

up vote 0 down vote

Take a look at Product Sales Information module, it doesn't give you a report for a given period (but you can get it from the database with a simple query). It does give you a better overview of sold products over different periods (week, two weeks, month, quarter, half year, year and total). You can also see who bought a specific product and what products are bought by a customer.

share|improve this answer
Thanks. And what would that simple query be? – Gaia Apr 30 at 19:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.