Käynnissä

Sales and invoice detail aggregation into one database

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.

Taidot: tiedonlouhinta, tietojenkäsittely, Tietokannan hallinto, Excel, MySQL

Näytä lisää: data processing costs, adwords dashboard, sales reporting, sales excel, sales dashboard, invoice processing, detail, create invoice, excel 2013 visual, main detail, invoice excel database, adwords client reporting excel, program invoice, excel sales, orders invoice, sales program excel, want dashboard excel, processing orders excel, ecommerce adwords, excel database invoice, detail client database, ecommerce database program, orders excel, sales invoice excel, product sales database

About the Employer:
( 0 reviews ) Hilliard, United States

Projektin tunnus: #4283254

Myönnetty käyttäjälle:

manprag

ready to start ,check PMB

250 $ USD 3 päivässä
(0 arvostelua)
0.0

2 freelanceria on tarjonnut keskimäärin 275 $ tähän työhön

thedee

So you want to make a mini datawarehouse and ETL process. You want to normalize all existing data and stored it into database so it could used by your dashboard engine. You could hire me to make those things. Please Lisää

300 $ USD 5 päivässä
(0 arvostelua)
0.0