Msql change product visibility value

SELECT * FROM eav_attribute WHERE attribute_code LIKE ‘visibility’
// get id the EAV attribute 102

 

select * from catalog_product_entity_int as cpei
where attribute_id = 102 and entity_id in
(select entity_id from `catalog_product_entity` where `type_id`= ‘simple’) and value >1
update catalog_product_entity_int set value=1
where attribute_id = 102 and entity_id in
(select entity_id from `catalog_product_entity` where `type_id`= ‘simple’) and value >1

Leave a Comment