I'm working on a product migration that involves about 200 attributes. I'm making most of these as a dropdown so that the clients can pick and choose which ones to utilize on the layered navigation (LN). They are not sure which attributes they would want exactly on the LN, so that's why I'm making them all as dropdown, instead of text field, to give them flexibility.
If I want to switch them as a text field without deleting and re-creating attributes, what do I need to do in the database? I've tested modifying values in
frontend_input and that seems to do it without causing any problems. This is under the assumption that associated products will be removed and re-created, obviously, so that the respective attribute value are in the correct EAV tables.
Are those all I need to change in order to manually change a dropdown attribute to a text field attribute, or are there other tables involves that may potentially cause errors?