We are looking for a simple stock control system. We currently have a supplier who publishes a csv file daily to their webserver. This csv can be downloaded either via http or ftp and it contains SKU's, current stock levels, estimated date (if out of stock) and some other non relevant data.
What we are after is a website/software/database that can automatically retrieve the csv file each day, compare a list of SKU's that we sell to the csv file and if there are some out of stock items to auto-generate an email (which we can print automatically) listing the SKU's that are out of stock and showing the estimated date when they're back in stock.
We would also like it to check for when a previously out of stock SKU is back in stock and notify us of this as well.
We are fairly flexible in terms of how this is achieved and more information is available on request.