Dear Client,
I hope this proposal finds you in great spirits. I am thrilled to have the opportunity to work on your project, "FTP/Web based CSV file which updates from Autotrader listings." As a freelancer with expertise in PHP, Data Entry, Excel, Web Scraping, and Software Architecture, I am confident in my ability to deliver exceptional results.
Now, let's get down to business. I propose developing a script or macro that operates on a web-based platform and automatically runs three times a day (8am/2pm/8pm) as per your requirements. This script will ensure that each of your 6 locations has an updated CSV file.
The script will be designed to detect new listings specifically for each location from the Autotrader website. By scraping the necessary data from these new listings, such as image URLs (gallery size), video links, and vehicle information, the script will export this data to the respective CSV files. Additionally, the script will identify any price changes in the existing Autotrader entries and update the CSV accordingly. It will also remove any entries in the CSV that are no longer present on Autotrader.
To ensure accuracy, the script will extract the location information from the advert text using the keyword "Location:" and include it in the CSV.
I am confident that my expertise in PHP, web scraping, and data manipulation will enable me to deliver a reliable and efficient solution for your project. I am committed to providing you with a high-quality deliverable that meets your specifications.
Thank you for considering my proposal. I look forward to the opportunity to work with you and discuss the project further.
Best regards,