Drupal commerce - product display view replicates products I'm building a ecommerce for a fashion designer and of course every item has got variation such as color and size.
With line item it's fine, on the product display i've got the option to change color and size and with the fancy attribute module I can show a small box with the color instead of simple text.

Now I have to build a view of product display which contains title, 1 picture and price.
In order to get the price I create a relationship with the product reference but here comes the problem, it shows all the products, every variations so one item could be repeated several times in different color and different size.

I would like to show just one product of that group, then the user clicks on it and sees the product display and there he can choose the variation.

Of course I can delete the relationship, add a price field on the content type "product display" and show it in the view but I would like to know if there is another way to do it.

Thanks in advance.
This is known issue discussed in this issue. Setting the query to distinct in the queery settings under advanced within views worked for me, as described in comment 6.