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:

1. Enabling Views aggregating checkbox
2. Creating a new view which is based on nodes, instead of Commerce Products
3. Checking "Distinct" under "Query options"

However, neither of that worked. I'm not sure if I misconfigured these settings.

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!

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:

1. Enabling Views aggregating checkbox
2. Creating a new view which is based on nodes, instead of Commerce Products
3. Checking "Distinct" under "Query options"

However, neither of that worked. I'm not sure if I misconfigured these settings.

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?

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!

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:

1. Enabling Views aggregating checkbox
2. Creating a new view which is based on nodes, instead of Commerce Products
3. Checking "Distinct" under "Query options"

However, neither of that worked. I'm not sure if I misconfigured these settings.

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!