Import XML file into Mysql Database with php or python

Budget $30 - $250 SGD
Bids 41
Average Bid $207
Status Closed

Provide a modular command line PHP or python tool (script/s) that parses an XML file (example of structure attached) containing a list of approximately 4500 products with details from one of our vendors and update a Mysql database based on the following rules.

a) if the product does not exist in the database then insert the full record

b) if the product exists and there are no changes then ignore the record

c) if the product exists and one or more of the details have changed, then update the changed fields only. Do not update the entire record.

d) If the product is in the database but not in the XML file delete the record

The item to field mappings will be provided prior to the start of the work.


1) Tool to import / update / delete records in mysql database from XML based upon above rules.

2) Tool can be written in either PHP or Python.

3) Provide source code for all components that go together to create import tool

4) if tool is made of multiple components all scripts to be contained within a logical directory structure

Happy to answer any questions about the project prior to start.

Get Free Quotes For A Project Like This

This project was awarded to


Where do I begin. I was spending 20 hours a week manually invoicing all of my spreadsheet data. He said he could have a script written up in a few hours! He delivered as promised! Now with one click of a button, I have 170 invoices done in 10 seconds! His communication is excellent and was more than considerate answering any questions and adding features to the script. I have more work for this guy coming up. It was such a pleasure and I will hire him for all my programing needs! Now I can enjoy my Sundays instead of sitting in front of a computer for 10 hours straight doing admin work! Highly recommended! USE THIS GUY! Trust me! Worth Every Dollar Spent!!
About the Freelancer
robinsjp Profile Picture

I spent most of my working life as a researcher in physics. I used mainly C++ and Matlab. My current day job involves coding in Perl, PHP and interacting with a MySQL database.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • mahindaranil Profile Picture


    Colombo,  Sri Lanka

    We have experienced software developers who have worked on large projects. Before starting this company we worked for FastSearch and Transfer / Microsoft Sharepoint for more than 4 years. C#, Java, Python were heavily used. Other than that we have experience on web technologies. We are experts on following technologies - PHP, JSP, Servlets, Spring, Hibernate , Ajax, JavaScript. Also have experience on Android and Apple mobile application developments

  • lechu502 Profile Picture



    I am looking forward to being hired by you for all your MySQL jobs. I am an experienced MySQL Developer and have a blend of experience in the area of Python and so my service will prove to be useful for your projects. I have a distinguished career as a MySQL Developer and Python Designer. I am ready to be hired by you and start work today.

  • animeshmishra86 Profile Picture


    Bangalore,  India

    Experienced Java, Python , web based application developer

  • xiddw Profile Picture


    Leon,  Mexico

    I've pursed a Master degree in a top-tier Research Centre at Mexico. During my studies, I have been working in Machine Learning techniques as also Pattern Recognition methods. I'm also interested in Computer Vision/Image processing applications. I'm proficient in C, C++, C#, R, Matlab for doing scientific computing. I've also been working as freelancer developing and designing websites and on-demand software using HTML5, CSS3, PHP, C#, VisualBasic and Java.

  • toinnisfree Profile Picture


    IKOTA LEKKI AJAH,  Nigeria

    I am a fulltime freelance programmmer with over 10 years programming experience. An expert in PHP / MYSQL / Javascript / AJAX / XML deployments. I particularly specialize in shopping carts and API integrations: payment, shipping, inventory, autoresponders and the like: Interspire, Zencart, Virtuemart, Cubecart, Amember, OSC, TomatoCart, Woocommerce. You will find my services highly reliable and professional. Let me get right to it and deliver your next project with a professional quality that many of my previous customers can attest to.

  • SigmaVisual Profile Picture


    Taxila Cantt,  Pakistan

    Web, Bots, Crawlers, and Scrapers Development. I have expertise in automation services and I can automate any manual process.

  • trkr Profile Picture


    Mersin,  Turkey

    I've been working more than 15 years as a web developer. ## Area of Expertise - PHP4/PHP5 - MySQL - Javascript/DHTML/AJAX/JQUERY/AngularJS - CSS2/CSS3 - Bootstrap - XML/XHTML/HTML4/HTML5 - Wordpress - Buddypress - bbPress - Mobile App Development - Payment gateways - Search engine optimization (SEO) - Content Management Systems - Project debugging and improvement - Data mining and transfering - Server setup and configuration

  • bogdanpeschir Profile Picture


    Brasov,  Romania

    iOS, C++, Python, Web Development

  • M5L2764K Profile Picture


    Riga,  Latvia

    C and C++ on many Unix platforms, Python, MQL4, SQL (Oracle), Lua network programming, SOAP (gSOAP, SOAPpy), web scraping (Scrapy framework), Varnish VMODs, bugfixing and performance tuning. Bitcoin and Litecoin experience with many exchanges, market and trading API. I own a profitable Bitcoin/Litecoin arbitrage bot.

  • hoprocker Profile Picture


    San Francisco,  United States

    I am a python-oriented full stack programmer, with experience in cloud hosted, multiple-node systems programming and testing. I have several years experience working as a frontend developer and have helped created several interactive, javascript-rich web applications.