238332 oscommerce data import program

I am using oscommerce as an online shop. At the moment, I can automatically update price and stock, but it is not convenient. I need a program to import new products from suppliers' datafeed( more than 7 suppliers, but they are similar), detect discontinued products and generate list for further action, set up margin and update data automatically and easily. Further details as follows: 1) I need the program can detect and know which are new from supplier's datafeed then import them automatically(I can choose and decide which one need to be imported, because it is not neccessorry to import everything) 2). might be choosed by clicking some optional list. Eg, choose catagrory. Catagory is very important. My catagory is different with suppliers' catagories. Please be aware there are many products, not only for one. You need to put product into different catagories as well. I do not know how to do that, but it must be very convenient and flexible to suit different suppliers. We can manuly choose catagory according to our current catagories. 3). Might be able to set up margin according to supplier's pricelist to generate my pricelist. 4). We have GST, so there are two prices for every product. One is GST include price at 10% GST and another one is exclude price. 5) can be able to update price and stock easily. At the moment, I can do that, but I have to spend long time to combine all suppliers' pricelist together, set up price and use excel vloop function to change it. it is not convienent. 6) can detect and generate discontiued products( code is not match with any suppliers' datafeed) list. We can choose to delete some products that we do not need to keep on web. 7) we are using more than 20 suppliers, but it not nesassory to set up each program for each supplier. I know one person has samiliar program and that program does not mind how many suppliers they have. They choose one or two for standard format. If they want to update other suppliers' datafeed, the datafeeds must be samiliar. that means other datafeeds must be same or can be change or trim to same format. At the moment, most suppliers' datafeed is similiar. So actually you do not need to program 20 different program. Just one or two. it is enough. If one supplier's datafeed can not suit this format, we will give up its data. We only need to import a few things in their datafeed, such as product code, name, description, import date, ETA, GST or not( all should be GST yes)price exclude GST, price include GST( it is price exclud GST x10%), product status( all should be in stock, value in database should be 1), quantity, picture( suppliers's datafeed include picture library. If some do not have, just put is blank or default picture), products url(can be set to blank, products weight( if not available, can be set to default weight)... others we can ignore it.