I have two queries.
by mistakes admin add multiple same name for options like many products have same option name color and others options. and also same options values for same option like many products have same red values for color options name. can we run a queries to remove the redundency of option names and values.
second i want the option name must be select from drop down if require we can add a new option name but if add an existing option name it should error message and also i want when a new option value added there should be a drop down of available option values like if option name is color there will be option values drop down to select (red , green, black) and if option value not exist we can add a new value.
please help me in both the queries.
thanks