Automatic manufacturer sales reports
Posted: Sat Jul 02, 2011 4:24 am
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!