I have an existing web site that is live. We need some links removed on the home page and a new one added that links to a new static page. This is an online store. One of the links is giving a 500 error and that's because a product was deleted in the admin but the delete did not remove the link in a related table. This will need to be fixed. I have attached some screen shots with a list of the things that I need to have done. Also we have several new products in an excel file. I would like a new function to upload the file and load the products into the database. There are also related images for each product and I need a way to get those loaded as well. That could be done with FTP. I think that the system system currently creates a thumbnail from the image when you add a single product. Finally we have another excel file with a list of products to delete. Need a new option in the admin that will allow us to upload the file and remove those products.
Please see attached file for more information. This is a Ruby On Rails application running on MySQL on a Red Hat Linux box with Apache.