Duplicate commerce items when using attributes in taxonomy page
When products have multiple attributes, created multiple copies of the same product with different attribute and linked them to a content product display node.
By doing so, every single product of the attribute is showing once on category page. How do I remove the duplicates?
- In views advanced setting enable Distinct at Query settings
- Use aggregation but it is complicated ! :]
- If enabled, some fields may become unavailable. All fields that are selected for grouping will be collapsed to one record per distinct value. Other fields which are selected for aggregation will have the function run on them. For example, you can group nodes on title and count the number of nids in order to get a list of duplicate titles.
- add filter to your view: field_product_reference:delta = 0
- JUST IT!