For attributes with type: select, multiselect, checkbox, radio_button.
To delete these attributes, you need to first delete all of their option options.
Then go back to delete that attribute.
If you do not delete the attribute options first, they will still exist in your database. This leads to when you create an attribute option, you will get a slug match error.
For the rest of the attributes, just delete the attribute.
