i have easy populate excel upload in my oscommerce template and shop, in the zip folder already coded in ok but i would like to have it customized what i need is - my supplier sends me price lists everyweek which has - Part Code - Brand - Final Code - Description - Sell1 - Active - Category - PicURL - ok but i want to be able to upload straight away with out editing the whole exel file to match oscommerce style also the Category is under code eg (512MB DDR2 PC533 2 X 256MB STICKS RETAIL) which will be in category (SDD2) which i would want that to be in category memory/ddr2/ ) i hope you understand what i need this to do. but thats also why i want the images change to the suppliers site as in the excel file they send, it has just the picture name of product.
at the moment i have been changing the pricelists to match that of oscommerce the way it need to be to upload like change all the categories from code to the name and the colum headers to oscommerce ones but this is taken up a lot of my time each week changing it all. please can you give me a price for the two projects then i might get them both done at the same time. thank you
also like it to delete products that are not in the excel database that i upload as some product my supplier stops getting. however this wouldnt effect anything as they send me the whole price list of everything everyweek. so i will be putting in every single product each week again from the excel file.