Create Dashboard Widgets from MAGENTO

Closed Posted Apr 28, 2011 Paid on delivery
Closed Paid on delivery

Hello, we currently use MAGENTO and

We want to set up an internal dashboard

We have this service in mind...

[[url removed, login to view]][1]

They have an API and some basic magento extensions available...

PLEASE READ DETAIL DESCRIPTION FOR MORE INFO.

## Deliverables

We want to essentially send to this

The following things:

1. Number of NEW orders for the Day

2. Daily Total Revenue

3. # of Backorders

3.A, # of backorders 7 days ago (from the current date) So if today is monday, and we have 10 backorders... I need to know how many backorders we had the monday 7 days ago... and then I need to know the % increase/decrease.

4. # of Shipped Orders FOR the day...

4.A # of shipped orders 7 days ago (from the current date) so if today is monday and we SHIP 10 orders... I need to know how many backorders we had the monday 7 days AGO and then I need to know the % increase/decrease.

5. # of Products Sold For the Day...

(i just need to know the number of actual products we sold for the day)

[url removed, login to view] time to FILL order...

I need to know the average # of days from when an order is placed to when an order is shipped.

So, let's say that an order comes in June 1 and is marked shipped on June 4. So in this case, the order took 4 days to ship.

We would like to track the average time to fill order for the LAST 7 days... The Last 14 days... and the last 30 days.

However, one technical thing is... Saturday and Sunday do not count as days... It is only the 5 business days.

7. We would like to track the same thing as number 6... but for BACKORDERS...

So, for this... you would need to track the amount of time a backorder is averaging... To figure that date... you would track from when the order goes into BACKORDER and then changed the status to SHIPPED.

[[url removed, login to view]][2]

Let me know if you have any questions.

Linux MySQL Software Architecture Software Testing UNIX Web Hosting Website Management Website Testing Windows Desktop

Project ID: #3277447

About the project

3 proposals Remote project Active May 20, 2011

3 freelancers are bidding on average $907 for this job

mobiletech1604

See private message.

$382.5 USD in 14 days
(64 Reviews)
6.0
globussoftteam

See private message.

$637.5 USD in 14 days
(1 Review)
3.5
omsun

See private message.

$1700 USD in 14 days
(0 Reviews)
0.0