[SOLVED] Just a little question for color picker

[coldthings]

hello..i was wondering if there is an sql statement to enable the color picker for all my products by default. I have the same color picker for all my products

this is written by rocky and i think that this can be modified for the color picker but i don't know how

TRUNCATE `ps_product_attribute_image`;
INSERT INTO `ps_product_attribute_image` SELECT `id_product_attribute`, `id_image` FROM `ps_product_attribute` pa LEFT JOIN `ps_image` i ON (pa.`id_product` = i.`id_product`);

please help

Thanks !

[rocky]

Try:

UPDATE `ps_product` SET `id_color_default` = 1

Change ps_ to your database prefix and 1 to the id_attribute_group in the ps_attribute_group table of the colour group you want to use.

[coldthings]

Thank you rocky ! It works ! You're the man. A prestashop master. Good job again.Thank you !

[ysns]

Hey there
I have same color picker problem but my mysql knowledge limited so can somebody please tell me step by step how can I solve it from PHP myadmin. Otherwise I have to click 1000+ links at back office and enable color picker one by one.
Thanks

[ysns]

Could somebody please help me? Below you can see print screen. What should I do next?

[rocky]

Click on the Gözat tab to browse your products. You can select multiple rows and then click the pencil icon to edit them, then change all the "id_color_default" values to the id_attribute_group of the color group you want to use on the product.

[ysns]

Thank you so much. It works fine now.