FTP/Web based CSV file which updates from Autotrader listings
Budget: £20 – £250 GBP
FTP/Web based CSV file which updates from Autotrader.co.uk listings
I need a script or macro setup that is web based and runs on a schedule 3 times a day (8am/2pm/8pm) automatically.
We have 6 locations so each location needs a copy of a CSV to be updated on a scheduled run.
It needs to detect if a listing is new for that location from that site page on Autotrader, example:
https://www.autotrader.co.uk/retailer/stock?advertising-location=at_motorhomes&advertising-location=at_profile_motorhomes&channel=motorhomes&dealer=10025576&page=2&sort=desirability-desc
Then in that new listing, extract / scrape the data and export to the relevant CSV files which need to be in the attached format for image URLs (gallery size), video link and data for the vehicle. Using the right formatted text in the CSV for the relevant field. Location picked up from the keyword "Location:" in the advert text and extracted to the CSV.
Listing Example:
https://www.autotrader.co.uk/motorhome-details/202310122922641
On a scheduled run it needs to detect price changes on the Autotrader existing entries then update the CSV and delete entries in the CSV that are no longer present on Autotrader.
I need a script or macro setup that is web based and runs on a schedule 3 times a day (8am/2pm/8pm) automatically.
We have 6 locations so each location needs a copy of a CSV to be updated on a scheduled run.
It needs to detect if a listing is new for that location from that site page on Autotrader, example:
https://www.autotrader.co.uk/retailer/stock?advertising-location=at_motorhomes&advertising-location=at_profile_motorhomes&channel=motorhomes&dealer=10025576&page=2&sort=desirability-desc
Then in that new listing, extract / scrape the data and export to the relevant CSV files which need to be in the attached format for image URLs (gallery size), video link and data for the vehicle. Using the right formatted text in the CSV for the relevant field. Location picked up from the keyword "Location:" in the advert text and extracted to the CSV.
Listing Example:
https://www.autotrader.co.uk/motorhome-details/202310122922641
On a scheduled run it needs to detect price changes on the Autotrader existing entries then update the CSV and delete entries in the CSV that are no longer present on Autotrader.