We run several very busy ecommerce sites with many orders and skus. We also aggressively use adwords. We want to create a internal, multiple client program we can use to aggregate all our sales, margins, product, and advertising costs into. We want a very flexible reporting option so we can easily see each metric with in our database. Would like to have a dashboard type main page to see predetermined drivers at a glance. This is for internal use only so visual aesthetics are not important, being scale-able and robust is.
I am not a programmer so It would be easier for me to tell you what I have and what I need when you are done. See attached PDF, each of those boxes contain data we would like to aggregate some how so we can run sales reports with details on skus, products, etc. The preferred way in entering this data would be copy and paste as an entire page.
Also, we need to be able to add cost and shipping charges to the above mentioned section. This would be added later on once the order is processed. We also need to have a way to identify the orders as processing, shipped, backordered, cross shipped, etc. we also need to be able to add tracking numbers.
Also, we need to be able to add our advertising costs into so we could run p&l of sorts.
Also, we need a dash board to keep track of all this.