Sales and invoice detail aggregation into one database

IN PROGRESS
Bids
2
Avg Bid (USD)
$275
Project Budget (USD)
$250 - $750

Project Description:
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.

Additional Project Description:
02/28/2013 at 2:50 IST
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.

Skills required:
Data Mining, Data Processing, Database Administration, Excel, MySQL
Additional Files: Command+Center.pdf
Hire byf2
Project posted by:
byf2 United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.