Extract Spare Parts P/Ns and Descriptions from web

I have started using CLAUDE AI, BUT HAVE BEEN UNSUCCESFUL IN COMPLETING THIS CHAT. I have a xls dataset of a specific manufacturer parts e.g Caterpillar Tractors or Solar Turbines say up to 500. The xls contains a Mfrs P/N and a Description. I would like a Python script to look up/find each part on the Mfrs Web Shop and return/populate the web site's P/N and Description to the same xls. iF THERE IS NO WEB SHOP THEN TO SEARCH THE WEB AND FIND. I HAVE ATTACHED A XLS FILE WITH 3 WORKSHEETS, THE SAMPLE LISTS ARE A) CATERPILLAR, B) SOLAR TURBINES AND B) YORK INTERNATIONAL.