Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

How to remove property from variant when deleted from code?

Muller
Muller
Vote:
 

How to remove property from variant when deleted from code? I don't want to just unlink but I want to remove from tables like ecfVersionProperty and CatalogContentproperty. I am not sure if a query to delete form both tables does not break anything and works properly. I am using Commerce of version 13.2.

#205215
Jul 02, 2019 6:13
Quan Mai
Quan Mai
Vote:
 

There is no such query, and we recommend against deleting data directly. In this case I suggest to leave them as is, they would not affect performance anyway.

#205216
Jul 02, 2019 7:19
Muller
Muller
Vote:
 

I agree it won't make any impact on perforamance. However, I have cases where property name is already occupied by previously deleted names. And there are so many properties which are difficult to read and time consumingl.

#205238
Jul 02, 2019 13:30
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.