Fix magento 1 price&stock auto-update issue

Job ID: 32356308

Budget: $30 – $250 USD

We have an magento 1 store and one script that is updating every night the prices and stocks from an xml file with a crontab entry. Issue is that not all products are updating. There is a error in script. Also Some product appear in stock in frontend and out of stock in backend. Maybe a index/cache issue.
Related categories: PHP JavaScript XML Magento MySQL