Search our supplier website by part number and update price for 3000 products in excel sheet

I have an Excel sheet containing roughly 3,000 unique part numbers. Your task is straightforward: for each part number, look it up on the designated supplier website and record the current unit price back into the same spreadsheet.

What I will provide
• The Excel file with every part number clearly listed
• The URL of the supplier site and, if the site ends up being gated, the login credentials you’ll need

What I expect back
• The same spreadsheet returned with an accurate, up-to-date price in the column I’ve reserved for that purpose
• Consistent currency formatting and no alteration of any other data already in the file
• A brief note outlining any part numbers you could not match or any anomalies you encountered

Accuracy matters — only use web scraping tools—provided the final numbers match the supplier site at the time you pull them. I will check all entries before releasing the milestone.

If you have done similar high-volume data enrichments or can suggest workflow improvements that shorten turnaround without compromising precision, let me know when you place your bid.