We require a very competent web scraper to extract vehicle application data from our suppliers website.
To the programmer, we will show the information we need via teamviewer.
Due to the number of vehicle 'lookups' there will be *estimated* 50,000 rows of data (approximately).
The site is not password protected.
The process begins with a page with 2 dropdowns, (vehicle make and vehicle model filter dropdowns)
The next page goes to a list of links with various vehicles engines and submodels. (each link must represent a row in the excel master file)
The next page shows a list of productcodes and product details relating to the vehicle lookup and the selections made on the previous pages.
For each of these final pages, each productcode needs to be on a seperate row on the excel, and each information field needs to be a in a different column. there is also a further link for each productcode which goes to a product information page. all the information on this page is related only to the product, and not to the vehicle lookup, so it could be extracted seperately and then placed back into the master file.