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 ?


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 ? – Hamza Mustafa Jan 26 '19 at 8:33
  • 1
    yes enable all products using above query – Rakesh Donga Jan 26 '19 at 8:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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