218280 Zen-Cart Mass Product Imports

I have 250,000 products I need added to Zen-Cart. I have a spreadsheet that has a generic name and price that can be used, however that still leaves a large portion of the information missing however I think we can write a script to grab the missing data such as images descriptions and proper names from the manufacturers websites matching our spreadsheet part number to the websites part numbers. Not really sure how to execute this project but needs to be done in a timely fashion with as much automation as we can. If you need additional information please feel free to ask more questions.