I have a view which displays the list of all Commerce Products on the site.

The problem is that it displays variations as separate products.

I've tried enabling Views aggregating checkbox and I've tried creating a new view which is based on nodes, instead of Commerce Products; however, neither of that worked.

I suspect that it has to do something with aggregation/grouping but I can't figure it out for a couple of hours already :@

How can I limit the display of products to only *one* variation?

Thanks!