Page 1 of 1

Automatic manufacturer sales reports

Posted: Sat Jul 02, 2011 4:24 am
by farmiemarket
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!

Re: Automatic manufacturer sales reports

Posted: Wed Jan 28, 2015 8:56 pm
by evanomondi
Hi

Did you get a solution for this?

Re: Automatic manufacturer sales reports

Posted: Thu Jan 29, 2015 10:09 pm
by cmerry
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