Change Product Features To Custom Value?

[Casper_O]

I figured out I made a huge mistake recently when I imported +40.000 products with 5-10 features each. Some of these features, have a unique value for each product and by a mistake i did not save it as a custom value. This now resulting in a slow editing and making new products manually (since it have to load 3 features with over +40.000 values).

 

Right now my only solution seems to be doing a new import and change the 3 feature types value to Custom for each product, but I was hoping there where much faster way to archive this with MySQL, sadly i had no luck searching for this.

 

I would appreciate any ideas, that could help me do it smarter

 

I'm currently thinking that changing "ps_feature_value" table column "custom" from "0" to "1" could archive this. Only done on the rows where id_feature match the features that I did like to only have custom values... But im not sure on how this could affect the shop...

Edited November 28, 2015 by Casper_O (see edit history)