[solved] Which table contains Colour Picker field?

[noesac]

I'm trying to write a query that displays all products with combinations > 0, but does not have a Colour Picker = TRUE

 

 

But I can't seem to find where this value is stored. It makes sense that it should be in ps_product but it's not. Does anyone have any idea?

[Bill Dalton]

This old thread might help ...

 

http://www.prestashop.com/forums/topic/17620-solved-color-picker-bulk-active-setting/

[noesac]

This is awesome, thanks so much!!!

[noesac]

I just wrote the following query in case anyone wants to use it in the future:

 

 

SELECT ps_product_lang.name, ps_product.id_product AS id

FROM ps_product

LEFT JOIN ps_product_attribute ON

ps_product.id_product = ps_product_attribute.id_product

INNER JOIN ps_product_lang ON

ps_product_lang.id_product = ps_product.id_product

WHERE ps_product.active = 1 AND ps_product.id_color_default = 0

GROUP BY ps_product.id_product

HAVING COUNT(ps_product.id_product) > 1

Edited June 1, 2013 by noesac (see edit history)

[vekia]

manu thans for your SQL query - im convinced that it will be really helpful for other community members

 

now i can mark this thread as [solved]

 

feel free to continue discussion here

 

regards!