I am trying to build a marketplace once which a buyer can buy the same product from multiple sellers. For example, if you selling a book on the marketplace, multiple sellers can list the same book for sale. On the main catalogue listing page I want to displace all products, but only show one unique tile per product. Then within the product tile do a count to show the number of active listings for that product. A user would then be able to click on the product and be taken to the product page where I will be able to show all sellers and the price at which they are wanting to sell the product for.
I can not work out how to “group” all listings for the same product into 1 item in a repeating group.
In the example below I want both the “Where the Crawdads sing” books to show as 1 tile. I can then do a count on the number of books that are for sale and show it on the tile as a count of items for sale (this step I can already do).
Can anyone recommend a way to limit the listing of products to only one unique tile per product?