how do I implement it for this sample download the sample data from here http://www.2shared.com/document/2Vlm8cWU/sample.html (the sample only has a 20 items, the original one has 21000) and some products are the same from even 8 suppliers.
I want to get rid of the duplicate products with the same reference and keep just the one with the smallest price.
I hope I explained now correctly.
Thanks again for all your help.