Scrape Online Store

Good Day, I require a python script, MUST be based on SCRAPY, to crawl and scrape online retail stores periodically. The script will reside on my cloud server and will be run periodically (daily) via cron. It should crawl the retail site and check for products and all its details. If the product is new and does not exist in the database it should be added with version 0. If the product is already known from a previous crawl but has NEW/UPDATED information like price change then a new record should be added with version field incremented by 1. If the product is the same then no record in added/updated. The crawler should fetch products images where available and store them on the server. A link to the image on the server should be stored in the database to be able to associate the image back to the product. The database structure should be like (and may change depending on product details available): Id, create date, version, category, brand, item number, model, name, price, image Id is primary key, auto incremented Creation date is the date and time that the record is added. Version - is the version of this record starting from 0 and inc when details change Category - is the area that the store places this product in csv format i.e. home, heating and cooling, aircons Brand, item, model, name, price - product details Image - reference to file location on server The crawler should also output logs showing how it is crawling and which products it found, which fields were found, comparison results against existing products and what will be finally inserted in db. This will allow for debugging. Results will be stored in a mySQL database. Success/Payment based on crawler finding at least 95% of products correctly.