Alex,
We actually have software that's built to do this. Is very flexible and customizable. You might want to check out:
http://www.bcsengineering.com/store/product-importer-updater_pro-for-x-cart.html?MMCF_xfPIP
Drop us an email if you're interested in getting more information and we can help you out.
Thanks,
Carrie