Web app that stores and displays magento order information.

In Progress

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 [url removed, login to view] 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-------------------------------------------

Date

Time

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:

[url removed, login to view]

Thank you for your consideration!

-Dan

Skills: AJAX, Magento, MySQL, User Interface / IA

See more: magento order information mysql, work as a freelancer web developer, where to find work as a freelancer, where to find web developer, where to find freelancer projects, where to find app freelancer, where store can be freelancer, where i can find web developer freelancer, where freelancer to find projects, where find app developer, where can i find web developer, where can i find a developer for an app, we find you web developer, web projects freelancer, web page screen shot, web developer where to find, web developer on freelancer, web application freelancer, web application developer freelancer, web app google, web app freelancer, web app for freelancer, web app developer find, view projects on freelancer, user testing freelancer

Project ID: #4137991

Awarded to:

georgeschiopu

I write the tastiest code. Please check my PM for further details. Thanks

$25 USD / hour
(3 Reviews)
2.6

12 freelancers are bidding on average $34/hour for this job

p4provider

Here are Magento Experts , please check Our Latest Magento work In PMB For Our Experience and skills Regarding Magento projects and Let me start your work , Thanks

$10 USD / hour
(64 Reviews)
7.0
iclicknetwork

Hi, I'm Magento guru, just check my reviews about magento works, i've check your requirement, please check my PMB for further details

$250 USD / hour
(61 Reviews)
6.5
qitsol

We are magento experts.

$20 USD / hour
(20 Reviews)
6.1
tsseu

Dear Client, We have been through the details of your project. Please check PMB for our profile & portfolio. It would be a pleasure if we can get an opportunity to work with you. Warm Regards, Techinflo

$18 USD / hour
(18 Reviews)
5.5
sveralex

Hello Dan, here is my bid

$18 USD / hour
(18 Reviews)
4.9
oozeit

We are expert in Magento and can do this job easily. Please select and us we will complete this with no issue.

$10 USD / hour
(9 Reviews)
4.1
nyquistlab11

please check the PMB.Thanks

$20 USD / hour
(22 Reviews)
4.0
codehard

We are Magento Experts and are in business since 2006 and have developed more then 300+ Magento Projects . Lets get this Magento project done and you will not be disappointed . Please check your PMB

$8 USD / hour
(7 Reviews)
3.6
dakshsoftech

Hello sir please check pmb

$8 USD / hour
(6 Reviews)
3.4
vw1990574vw

HI,I CAN provide u best solution pls msg me to discuss the things

$4 USD / hour
(0 Reviews)
0.0
MagentoExpert123

I am Expert in Magento Framework and Magento Shopping Cart | Magento Themes | Magento Up-gradate | Magento Extension | Magento Api | Magento ERP | Magento Migration | Magento Speed Enhancement Expert!

$20 USD / hour
(1 Review)
0.0