Hi I want to enable all products I have in my Magento 2 store, is there any query to enable all products we have using a single sql query ?
Modified 4 years, 4 months ago
Viewed 742 times
below sql command useful for you
SELECT entity_id FROM `catalog_product_entity_int` WHERE attribute_id = ( SELECT attribute_id FROM `eav_attribute` WHERE `attribute_code` LIKE 'status' ) AND `catalog_product_entity_int`.value = 1
will this query enable all disabled products ? Jan 26, 2019 at 8:33
1yes enable all products using above query Jan 26, 2019 at 8:35