I would like to know how to merge attribute values so that all of the affected products would be part of 1 filterable attribute as apposed to multiple.
Problem: The data sheets I use have multiple entries for the same value, this translates into multiple filterable attribute values for the same value.
Attribute touch_sensitive Value YES (10 products) Value Yes (5 products) Value Y (2 products) Value NO (20 products) Value No (1 product) Value N (6 products)
Essentially I have 6 different attributes on the front end spread across multiple products that should be really under 2 attributes.
What is the recommended method to merge multiple attribute values?