Web app that stores and displays magento order information.

Avg Bid (USD)
$34 / hr
Project Budget (USD)
$2 - $8 / hr

Project Description:
We are hiring a developer to create only the beginning of a web application.
If these milestones are completed well, there will be an opportunity for more work immediately following. The requirements are as follows:
--Milestone 1--
We need you to create an API connection to a testing magento installation and use it to save order related information to a separate mySQL database at a users request. The mySQL and connection information will be saved in a config.txt for now.
(if you're installing a fresh magento cart please include the sample data during install so that it can be used for creating test orders)
Only magento orders with the status of “Processing” will be saved. If an order already exists in the database it will not be downloaded again.

We would like to save the following information for each order so that the web application can retrieve and display it:
ORDER INFO-------------------------------------------
Store (Purchased from)
Order #
Admin Comments

SHIPPING INFO-----------------------------------------
Shipping Name
Shipping Address 1
Shipping Address 2
Shipping City
Shipping State
Shipping Postal Code
Shipping Country
Shipping Method

PACKING INFO--------------------------------------------
Item SKUs and Quantity Ordered
Customer Comments
In addition, we’d also like to have another field available that will store the status of the order:
The possible order statuses are: “Awaiting Processing”, “Processed”, “On Hold” and “Canceled”.
All orders should initially have their status set to “Awaiting Processing”.

To complete the first milestone please send a screen shot of the order information in the MySQL database.

---Milestone 2---

Next, we need an AJAX interface constructed that will allow us to view this data.
A mockup of this interface is attached.
The user will be able to import new orders using a “Retrieve New Orders” button.
By using the text links at the top of the interface the user can choose to display orders of a specific status.
Initially every order imported will have a status of “Awaiting Processing”.
The user will be able to change the status of an order to “Processed”, “On Hold” and “Canceled”.

To change the status the user will check the checkboxes at the beginning of the row of each orders he wants to change. Then, using a drop down he will select the new status.

If the user clicks the row of any of the orders displayed a popup will open. It will list all of the information for that order. The Fields listed are the same which appear above. The information will not be editable at this time. A close button will close the popup and return focus to the orders list.

All required actions should take place without reloading the page.

After this functionality exists and it has been tested please send us a link where we can review it and approve it. Please also provide a link where we can create test orders in magento for importing. When you contact with the links please also attach the source code so we can review the process and commenting. Once approved the second milestone and this project will be complete.


Please read these additional Requirements for this and future projects (Important):

Freelancer says that I'm over the character limit, please find the requirements at the link below before bidding:

Thank you for your consideration!

Hours of work: Unspecified Project Duration: < 1 week Skills required:
AJAX, Magento, MySQL, User Interface / IA
Additional Files: Orders-List-Ver+0.1-Initial+project+post.png
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
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.

$10 / hr
Hours: 40 hr/ week
Hire iclicknetwork
$250 / hr
Hours: 2 hr/ week
$20 / hr
Hours: 20 hr/ week
$18 / hr
Hours: 40 hr/ week
$18 / hr
Hours: 20 hr/ week
$10 / hr
Hours: 20 hr/ week
$20 / hr
Hours: 10 hr/ week
Hire codehard
$8 / hr
Hours: 20 hr/ week
Hire dakshsoftech
$8 / hr
Hours: 40 hr/ week
Hire georgeschiopu
$25 / hr
Hours: 10 hr/ week