Insert Product attribute via mysql

[mycloudcms]

Hi i have many product attributes and I want to add them via mysql.

I tried

INSERT INTO prestashop02.ps_feature_value_lang (id_feature_value, id_lang, value) VALUES     (    55    ,    1    ,    '    Kia    '    )    ; but even it can be added is not visible to site.

 

Any help? Thank you

[Scully]

Unfortunately it is not that easy and your description misses some information. 

First of all, your topic mentions attribute but your insert is related to features. This is not the same.

 

Furthermore there are many tables involved for attributes as well as for features. But first question remains: Is your topic related to attributes or to features?

[mycloudcms]

Hi.thank you for your reply.features i try to add via mysql.

[musicmaster]

Make a dump of your Prestashop database. Then add one feature in the backoffice of Prestashop. Then make another dump. Then compare the dumps with a tool like Winmerge. 

 

That way you will learns what actually happens in the Prestashop database. As Scully says, it is a bit complicated, specially for features that can be pre-defined or not.

[mycloudcms]

Thank you for your replies, managed to add attributes via mysql.