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 ?


1 Answer 1


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
  • 1
    yes enable all products using above query Jan 26, 2019 at 8:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.