Updating attribute values for all products in a category

[mcpacific]

I figured this out. Mass update does the trick

[mcpacific · Accepted solution]

Resolved

[Silvana_Lee]

How can I mass update the SKU numbers for the products?

[Store_Manager]

Hello @Silvana_Lee
There are lots of things that can be modified via Import/Export functionality of Magento, but unfortunately product SKU is not one of them.

To tell the truth, the is no easy built-in way to change SKUs for products in bulk. If you have some tech skills you can do it programmatically with the help of some script. Alternatively, you can use free trial version of Store Manager for Magento extension (included in my signature) for 2 weeks without any charges or cc details. 

It allows to change SKUs via import like this (video included) -

https://www.mag-manager.com/useful-articles/how-to/how-to-bulk-update-magento-product-skus/

[Mike Hall]

You can do this another way also

Since multiselects are stored as comma separated values you can probably use a like on it.

Since multiselects are stored as comma separated values you can probably use a like on it.

$prodCollection->addAttributeToFilter('printercolor', array(
   array($currentPrinterDescription),
   array('like'=>'%,'.$currentPrinterDescription),
   array('like'=>$currentPrinterDescription.',%'),
   array('like'=>'%,'.$currentPrinterDescription.',%'),
));