I have a CSV file from my supplier that has approx 17000 products on it. What i want to do is be able to load those products into Oscommerce, but also keep the 2000+ products that i already have in the database, so its not just a case of uploading it, but i need to be able to select which products are uploaded from the CSV file first.
Also i need to be able to add new descriptions and change titles, quantities etc before the new products are uploaded. I will need the description field to be WYSIWYG and keep the formatting when uploaded (which i already have in my oscommerce install). Any products that match shouldn't be uploaded/over written etc.
I also need to be able to delete products that no longer appear in the CSV file but are in the online database (ie: a model number match) so that they can be deleted/updated.
I had a program written that flagged when model numbers matched but prices had changed, but if that could be incorperated into this then that would be good.
The above is the main product that i need produced but there will be other little bits later, but only CSV/Database compare bits and bobs.