When you delete a product category field of type list from the database, the options stay in the database. When you then later recreate the field, it reattaches the existing field options. Is this by design?
Steps:
1. Create a new field of type List i an existing category under Attributes | Product fields | Attribute groups | Category groups.
2. Add two options to the list (I called my MyOption1 and MyOption2)
3. Confirm the fields are in the database: SELECT * FROM dbo.EcomFieldOption WHERE FieldOptionName LIKE 'MyOption%'
4. Delete the field from the UI.
5. The fields are still in the database: SELECT * FROM dbo.EcomFieldOption WHERE FieldOptionName LIKE 'MyOption%' Should they not have been deleted in step 4?
6. Create a new field with the same system name as in step 1. Notice how the options now show up again.
Imar