A Srapsware is a well-known brand for more than 12 years, we cover all elements of the computing industry that can fill your hunger for the latest technology of today.

Follow Us

Bulk disable multiple Magento 2 products by Phpmyadmin

Bulk disable multiple Magento 2 products by Phpmyadmin

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

Find Status Attribute ID

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.


Shiv Singh
Fullstack Nomad Programmer, Ready to explore new places all over the world.
#programmer #gammer #traveller

You Might Also Like