Hi,
Thank you for your feedback.
For other people with similar issues, I would recommend to do it differently:
- create one unpublished category
- inside that unpublished category, create one unpublished category for each custom field
- in each custom field, select the corresponding category
- then, in each product, you can just add/remove the unpublished categories corresponding to the custom fields you want for that product when you're creating/editing it.
You still can't create custom fields directly from the product edition page, but you don't have custom fields with out dated data (products) selected in them, and you can directly select the fields you want from the product edition page when you create new products without having to go in the custom fields interface.
Finally, doing it like that, if you want to clean up custom fields that aren't used anymore, you can use a product mass action with a filter on the category corresponding to the custom field to see if any product still use it and if not you can delete the category and the custom field.