One of my customer want to disable multiple bulk products and he has provided me product IDs for all products.
So first of all you need to find what is attribute Id for Status of product, In my case it is 97
Now open phpmyadmin and run SQL query as per your product id:
UPDATE catalog_product_entity_int
SET VALUE = '2'
WHERE attribute_id = 97
AND entity_id IN (2252, 2259, 2260, 2261, 2262, 2267, 2270, 2271);
Result will look like:
It will work for only Magento 2.x not for Magento 1.x
Note: Please do the test for 2-3 product then run a bulk query at own risk.
