Though I have no knowledge of coding what so ever, the Studio app works great.
I've created several fields (float fields, integer fields, ...) but can't remove them afterwards. All fields have been named x_studio_... They all are base fields. It seems to be a problem because I named want to create a new field but from a different type (integer to float) while using the name I've used for a previous (= tried to delete) field.
The fields are not invisible on the product form nor on the list "existing fields".
Already checked this out https://www.odoo.com/nl_NL/forum/help-1/how-can-you-delete-existing-fields-inventory-studio-v15-207713
Cybrosys, thank you very much for the detailed explination. Some research on Google I dead previously also mentioned this but I was unsure if changing them from Base Fields to Custom Field wouldn't mess up the DB.
Must be doing something wrong: ValueError: <class 'psycopg2.errors.UndefinedColumn'>: "column "x_studio_float_field_1hwuy" does not exist
My bad, rookie mistake, I did not understand that "Field name" and "ID" were not the same.
To find the ID's, I exported the fields along with their ID. Is there a more efficient way?
Why do some Custom Fields suddenly become Base Fields?
The id will be available in the URL when you open the form view of the field(The one you have shared in the image). If you need to remove the fields by name, just change the domain. The id will be unique in the table. If you use the name of a field, there is a possibility of having more fields with the same name(in different models). But, in your case it is not an issue(Please use this method for only removing the fields added using Studio.). For example,
query = "UPDATE ir_model_fields set state = 'manual' WHERE name = 'x_studio_float_field_1hwuy';"
env.cr.execute(query)
base_fields = model.sudo().search([('name', '=', 'x_studio_float_field_1hwuy')])
base_fields.sudo().unlink()
Regarding the state of the fields: the model 'product.product'(model for product variants) inherits model 'product.template'(model for product). As mentioned earlier, the Odoo Studio created that base field. The one you have created will be there as a custom field(in 'product.template').
You can also refer the following app
https://apps.odoo.com/apps/modules/15.0/remove_studio_field/