Merge product feature, is that possible?

[ferramentaacasa]

Hi, I have a website where the person assigned to the loading of products had create 839(yes 839!!!) features and I really need to solve because loading product page in back office is VERY VERY SLOOOW. She had created 32 feature called "Weight", 29 called "Measures" and so on...

As you know, is not possible to solve manually and migrate ALL values to just one correct feature, is it possible to merge, for example, all 32 "Weight" in just one "Weight"?

 

Yes, I know that this is a really hard thing.

 

Thank you...

[hakeryk2]

This is kinda easy if we wan't to swap if You want to delete a group of feature and assign them to different one. It can be done like this where ids 73,74 that will be moved to 38 

UPDATE `ps_feature_product` SET `id_feature` = 38 WHERE `ps_feature_product`.`id_feature` IN(73,74)

But does anyone knows how to remove features_values duplicates that was created by typing them multiple times into multiple products?