I've got a script that is extracting attributes and inserting them into my Magento installation. The problem is that one of the attributes has created hundreds of duplicate options.
If I set the option
Use In Search Results Layered Navigation to
NO and hit save, it complains that the
admin value needs to be filled in. There are hundreds.
I want to disable this directly from the database so it doesnt show in the frontend and allow me to troubleshoot why this happened.
How do you disable layered navigation for a specific attribute from the database?