Posted on 27/09/2016 01:39:32
Hi Oleg,
I just tried this on a local site using a backup of the database from production. When I create a new variant, and delete it, it works. When I create a variant, open it to make it extended, save it and then delete it it also works. However, when I create a variant, open it to make it extended, change some product category field values, then save it and then delete it, it breaks (only this last action seems to add records to EcomProductCategoryFieldValue). I turned on the SQL Profiler and at some point I can see it's deleting from EcomProductCategoryFieldValue where productID = '1234" and VariantID = ''. That surprises me a bit as that seems to delete the fields for the container product and not the actual variant (since VariantID is empty).
We have some fields that are readonly, and some other that inherit. Could that have something to do with it?
I can supply a backup of the database; it's over 40GB so I have some cleansing to do first ;-)
Thanks,
Imar