cancel
Showing results for 
Search instead for 
Did you mean: 

Updating attribute values for all products in a category

SOLVED

Updating attribute values for all products in a category

I figured this out. Mass update does the trick Smiley Happy

4 REPLIES

Re: Updating attribute values for all products in a category

Resolved

Re: Updating attribute values for all products in a category

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

Re: Updating attribute values for all products in a category

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/

 

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: Updating attribute values for all products in a category

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.',%'),
));

Want Magento Professionals ?
& Get FREE 3 hour development today with ClapCreative - Building a Better User interface with http://clapcreative.com