How to remove property from variant when deleted from code?

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

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

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