There's an issue we're struggling with the products EAV. Here's an explanation:
- There's a shop with attributes and attribute sets created from them.
- A product is assigned an attribute set, and a value is given for a particular attribute from the set.
- Then, it turns out that the attribute set was wrong for the product, so it's assigned to a different attribute set.
Here's where the problem happens - Once you change the attribute set, the attributes from the old attribute sets which have a value previously assigned for the products, stay.
And if the attribute is filterable, it appears on the filters of the category, which is the main reason I'm writing this.
What's the best way to handle removing attribute values from old attribute sets/ attribute sets that were wrongly assigned? Should they be manually deleted from the db?
We tried reindexing, but it didn't work.