Deleting a field in the database

I set a custom field and then changed sign-up requirements so that field is now redundant with an earlier one. There are only 25 users for the 2 membership levels that field is used for.
Since it is such a small number, is there any reason I can’t just edit each users record and put the information from the field to be deleted into the field I’m deleting and then delete it?

So you want to delete the field, or the data for it in the database?

The field you can delete from where you created it: WP Admin > s2Member > General Options > Registration/Profile Fields & Options

If you want to delete that field’s data for users, you can do it from their profile editor before you delete the field, or from the database (usermeta table) with a query or phpMyAdmin…

If you have s2Member Pro, you can use the advanced user import/updater. Do an export, look for that field’s column, delete the data but leave the heading, and then import it back. https://s2member.com/kb-article/advanced-importexport-tools/

:slight_smile: