En cours

Magento API to/from MySQL via PHP: Need 5 easy scripts

We need 5 php files that connect to Magento's API and performs the following in conjunction with mySQL:

1) GET New Magento Orders

- Get All orders with status of PROCESSING from Magento

- INSERT into a mySQL database: (

OrderID, OrderDate, SKU, Quantity, GiftMessage, DisplayableComment, DeliveryServiceLevel, AddressName, AddressFieldOne, AddressFieldTwo, AddressFieldThree, AddressCity, AddressCountryCode, AddressStateOrRegion, AddressPostalCode, AddressPhoneNumber)

- Orders with multiple items in one order INSERTED as separate line, but with same Order ID and order number

- Create Shipping Service Level Mapping, i.e. UPS, USPS Ground = "Standard"; UPS/FedEx 2nd Day Air = Expedited; Overnight = Priority. This is to map Magento's various shipping service levels into 3 standardized shipping service levels

2) UDATE Magento Orders

- Query mySQL database for Orders marked as SHIPPING

- Update corresponding Magento Order via API, add shipping comments into Customer Comment, trigger "visible on front end" and "Notify customer" email with updated shipping comments.

- Update Magento Order status to "SHIPPING"

3) COMPLETE Magento Orders

- Query mySQL, GET orders marked as SHIPPED

- Update corresponding Magento Order via API, Add Shipper, tracking number (from MySQL DB), set order to COMPLETE, trigger customer email notification

4) Export Magento Inventory to MySQL

- Get SKU, QTY, Status from Magento, INSERT into a MySQL database

5) Manage Magento Inventory Levels

- UPDATE Magento stock QTY via API FROM MySQL database

Looking for a quick turnaround. You can develop them in your own dev environment (using standard Magento variable names and WSDL protocols) or use ours whichever is faster for you. We can supply the mySQL database and tables.

Thanks for bidding.

Compétences : Magento, MySQL, PHP

Voir plus : magento mysql order complete, magento api trigger email, magento api mysql, ups customer service, ups api status, notification using php, mysql customer database, magento develop front, need front end dev, dev php, magento connect mysql database, magento mysql database api, magento insert order api, magento api php, mapping api, magento customer service, magento service, usps tracking, update mysql, tracking api, sku inventory, one line php, new magento, need 5, magento shipping

Concernant l'employeur :
( 0 commentaires ) Kirkland, United States

N° du projet : #1082101

Décerné à :

gstradex123

Hey Magneto experience holder is here for details check PM

250 $ USD en 5 jours
(2 Commentaires)
0.0

12 freelance ont fait une offre moyenne de 543 $ pour ce travail

value4u

Hi, please check my PM. Thank you.

750 $ USD en 10 jours
(318 Commentaires)
8.7
TeamMagento

STOP !!! STOP LOOKING AT ANY MORE BIDS !! Get your project done Check our private message.your search ends here,Thanks.

520 $ USD en 5 jours
(170 Commentaires)
7.1
arnab0143

--Hi, I'm back. I could do this work for you. Please check your pm. Thanks.--

600 $ USD en 2 jours
(69 Commentaires)
6.6
gsala81

Hello, 10+ years exp full time freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.

500 $ USD en 3 jours
(43 Commentaires)
6.4
Magjoom

Magento expert here, Lets do it

870 $ USD en 15 jours
(33 Commentaires)
6.2
shashank20062

Magento experts here with 2 years of experience , can help you .

750 $ USD en 15 jours
(27 Commentaires)
5.3
fparekh

Dear Sir, i have read every points we have done this kind of task.Please check Your PMB for further information. Sincerely Yours, Mustafa

555 $ USD en 9 jours
(13 Commentaires)
5.2
asheagle

Hi, I am interested to work on your project. Please check PMB. Thanks,

600 $ USD en 20 jours
(7 Commentaires)
5.2
Vikaskukki

Hi Very Interesting project for us as we have solid experience in different cutomized solution in ASP/ASP.NET/MSSQL/AJAX/JAVASCRIPT/XML/CSV, PHP/MYSQL and various open source softwares like OScommerce,wordpress,Joom Plus

625 $ USD en 6 jours
(5 Commentaires)
4.0
siavashmusic

READY TO START IMMEDIATELY, PLease check your Pm

250 $ USD en 12 jours
(7 Commentaires)
3.7
HardwareDesign

Hi im PHP5/CodeIgniter/Mysql/XHTML/Jquery developer im looking forward for you work tell me if interested

250 $ USD en 10 jours
(9 Commentaires)
3.3