I have 3 data feeds that I have in my business. Every supplier I use has a majority of the same products. Is there a way I can only display a product on the frontend that has the cheapest price? If possible, then if the cheapest no stock moves to the next price.
The image below shows an example of the same product in the store, where the MPN is the same, but the prices are different. Of course, the cheapest want to show at the front end.