Design a product and price update module for Oscommerce

Product Update There would be about 8 price lists in excel fromdifferent suppliers, With their own unique way of defining a product and SKU(product code) but all similar products will have similar words in common.? We think each product can be sourced from upto 3 (max)suppliers. Sort them by product and then price and group eachproduct from different suppliers then remove those products that are not instock and then all but one in the same group that has the lowest price is addedto a Master price list.? Therefore the module has to find only products that arein the stock and find the cheapest supplier out of them and select that particularproduct for uploading. We would like to copy Model no, Product Title, description,price, Qty. on to the Master file. Each product will have image named after theSKU. Ex if the product SKU is SCABXXXX1234.(then the image file will be named SCABXXXX1234.gif. Please remember SKU need to be defined in a particular way. Product Upload Now this price list of about 20,000 products withtheir respective images and prices should be uploaded and listed on thewebsite. This is done everyday. When we update again the next day first allexisting products on the website should be deleted. Then we upload that day’sproducts afresh automatically (using cronjob). It should be done this wayeveryday and uploaded everyday afresh. The upload should be quick. When theproducts are uploaded the images must match the product Only those who have experience in this fieldshould bid. Expertise and timely delivery is important. ## Deliverables Please remember SKU need to be defined as follows:? First 2 digits name of our website,? next 2 digits name ofthe supplier,? next 8 digits will be the SKU of the product from the supplier.