Total Posts: 4
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.