[SOLVED] Color Picker Bulk Active setting?

[retromodo]

Hi

Is there anyway to mass active the Color picker for a multiple of products? Can this be done at the database level if so what table? If not in the front end???

[rocky]

I'm not aware of a way to do this using the Back Office. You can modify the database manually though. In ps_product, there is a field called id_color_default. For each product you want the colour picker on, change the value from 0 to the ID of the colour picker. To find this, go to the ps_attribute_group_lang table, look for the name of the colour picker you want, then copy the id_attribute_group for the colour picker.

[AndersIvar]

This way is not a solution for me, anyone has a working simple idea?

[lape]

i need a solution for this as well, i've got over 300 products to change

[shahnawazsibi]

worked...

[BorisAlexandre]

Worked for me too ! Executed a sql statement as follow:

___________________

UPDATE ps_product

SET id_color_default = XXX

___________________

 

replace "XXX" by the value of id_attribute_group that you find in the table ps_attribute_group_lang for the color attribute group.

Edited September 21, 2012 by BorisAlexandre (see edit history)

[benjamin utterback]

Hello all! I'm happy that the solution worked. I will go ahead and mark this thread as solved. Thank you for choosing PrestaShop