Hi. I need a simple app that will be run on a daily basis, so I'd rather have a simple gui rather than a dos application. I want the program to connect to a mysql database that use for my oscommerce site and download details on products that have a stock level below the reorder level into a csv file. I then want the app to compare this csv to another that I will have locally that is provided by my supplier. The purpose of this is explained in this example.
'Product A' has a reorder level of '0', stock levels on the database show current stocks of '-9'. My supplier supplies 'Product A' to me in packs of '6'. The app needs to work out how many packs I need to order, in this case I need to order '2' packs.
The csv file I will keep locally provided by my supplier will be in the the following order-
model number, pack size
The csv file to download I would like in the following order-
model number, quantity in stock, reorder level
The csv I would like the app to produce to send off to my supplier should be in the following format-
model number, quanity
I'm guessing that this is a simple app for those of you with the experience. Thanks