Unable To Delete Magento Attribute Duplicate Value
Hi Guys I have a custom attribute that I use for multi-channel flexibility called att_brands which is exactly is what it says. Over the past years, VA.s have uploaded 10000 of products via csv with Magmi. Over the time we have duplicate Brand names and I mean duplicate also some with spelling differences. If I try to delete the duplicates they go but after saving they all come back!
I have even tried removing the Brands name from the relevant product so they are blank. Then tried removing but they will not go. At my wits end anybody any idea how to get rid.
I have used data flow to export the products deleted all the values so the Brand is blank in all of them. Then gone back and tried to delete the values but they all come back after a save.