Magento

I ran a DataFlow Profile import with two matched columns, sku and status, to set the status of 1000+ products to 2 (disabled).  I tested the profile on a few products and it worked, but when it ran on the larger set it updated each product and set the status to blank instead of 2.  This is causing issues across the board, the products are not visible on the front end or back end except in certain searches, but not admin product sku searches.  I would like to add the 2 to fix the issue, but am not sure how to do it.  Any suggestions?

I did try the following sql to update the status manually based on sku and status attribute id of 96, with no luck:

UPDATE catalog_product_entity_int cpei, catalog_product_entity cpe
SET cpei.value = “2”
WHERE cpe.entity_id = cpei.entity_id
AND cpe.sku LIKE ‘&#xsk;u%’
AND cpei.attribute_id = 96

Thanks in advance for any advice.

Hi there,

You have an incorrect SQL query. Here is the one that should work -

Let me know how it goes.

Also for future updates, in case you need to update some values, there is other way, as not all required values can be updates that easily. You can try Multi-Editor tool of Store Manager application for bulk changes and updates. It is available for 14-days free of charge, so in case you need to do it one more time, you can do it without additional fee. If you are interested, check the URL in my signature.

Thanks, I’ll give it a try and will check out that extension.

And one more important thing I forgot to mention - do database backup before any mass changes