Automatic manufacturer sales reports

I am trying to automate my backend to a greater degree. Currently, I manage online marketing for a handful of local manufacturers, and deliver their sales to customers' doors. Now, I tabulate orders one night a week per territory (of which I have three markets) and email sales to each manufacturer so they can meet me in the morning to hand-off their sold inventory. I would like to come up with a way to automatically tabulate manufacturer's sales and email them a list of what sold so I can get some more sleep. Or, if I could publish sales by manufacturer to a website where manufacturers could logon to view their sales, that would work too. Is there a way I could configure this by writing an SQL query or process? Any suggestions would be extremely helpful. Thanks!

Hi

Did you get a solution for this?

Please look at ADV Products Purchased Report v3.2, you can generate report by manufacturer and export it with product list:
http://www.opencart.com/index.php?route ... on_id=3688

Documentation:
http://www.opencartreports.com/document ... index.html