We have a system which generates a csv output each day.
We need to remove any duplicates in the file, leaving the one with the lowest price (separate field). e.g:
So we need to remove Item 5 £6.99, and leave Item 5 £2.99.
This it to run via cron job each day as the csv files change every day.
If you are able to do this please let us know