Compare CSV file to MySQL Database

I need a simple script to compare a large CSV file to my database. The database contains products with descriptions, prices etc. The CSV file is from my suppliers, which is updated every day with new prices and products. I need a script to compare the existing products to the CSV and automatically update the prices, also if a product is no-longer supplied I need a list, so I can manually remove them or find another supplier. Also I want the script to make a list of all changes made to the database (before and after)