Magento have 26500 products are available and I want to disable all this product using MySQL because via Magento take lots of time. all products attributes set name is Diamond and Diamond id is 9. Please help me in this case.
First of all, DON'T think the writing SQL way. It's because the "Status" attribute id might NOT identical in each version. Modifying records directly can cause unexpected result.
Instead, I'll recommend you to use export CSV way to do your task.
Login to admin panal, go to System=>Import/Export=>Export
Select "Products" on "Entity Type", and click "Continue" on the bottom.
Wait for a moment, the browser will prompt you to download a CSV file.
Open the CSV file using MS Excel or other equivalent spreadsheet software.
Here I use Excel 2016 as example. Go to Sort & Filter and select Filter
Click the filter under
_attribute_setand select Diamond
status, change all the values to 2 and save the CSV.
Go back to admin panal, then go to System=>Import/Export=>Import
Select "Products" on "Entity Type" and "Replace Existing Complex Data".
After selecting the modified CSV, click "Check Data". Your data should be valid. And click "Import" after that.
Tested on Magento EE 22.214.171.124, equivalent to CE 126.96.36.199