Order History by Department

Hello everyone, I have been working to set up a Zen Cart site for my company for the last few weeks and I've almost completed it...and now I've come across a problem that might make my last few weeks worthless. PLEASE help me out if you know of how to do this.

I need to be able to seperate my orders by department. For example, my store will have about 5 different departments (housewares, clothing, jewelry, etc...) and I need to be able to get the total sales from EACH department. Without this function I will not be able to use Zen Cart for our store. I just assumed that this was a built-in feature because this is a common thing to do, but I can't figure out how to do it. When I click on "Order History" it brings up every order that has been placed, but I can't figure out how to seperate those by departments (I have each department in it's own category so what I really need to know how to do is seperate orders by product category). Is this something that is possible? It seems to me like I should be able to do this, but I just can't figure it out. If anyone knows of how to do this please help me! Thanks so much in advance!

-Andrew

I found a solution to my problem so I thought I would post it here in case anyone else runs into the same issue. In our store we have a one letter code for each department (A is toys, B is Menswear...one for each department). What I have decided to do is whenever I am adding products instead of adding the model number as 11111 (the actual model number), I will add it as A11111 (if it is a toy). I then installed the Zen Cart Sales Report module (http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=83). Once that is done you can go to the Reports section in your admin panel and then click on Sales Reports and sort the sales reports by model number. I export mine to a CSV file and then run them through excel so that I can easily add up my department sales each day.

I hope that this will help someone!

That is a very handy solution ... thanks for posting it as it will help others with a similar situation ... :smile: