How to edit items in mass

[ross_cohen]

Hi,

We have about 2000 items on Magento and have discovered that we need to change every single items SKU to match the sku we have given those items on Amazon. Please can someone tell me if there is a quick way to edit items in mass rather than going onto the edit page for each item individually.

Thanks,

Ross

[Manish Mittal]

Hello @ross_cohen

If you want to edit mass products you can login in to admin > go to catalog grid > select products > choose action update attributes.

Or You can use import CSV to update sku's. 

https://firebearstudio.com/blog/modify-attribute-values-import-export-magento-2.html

[ross_cohen]

Hi Manish,

Thanks for the suggestion. I should have mentioned we use Magento 1.9 not 2. The solution you provided suggests how to edit attributes in mass using rules, however this is not quite what i want to do. The ideal solution would be that i can download a spreadsheet with all of the items on and all of the information in columns, then i can just copy the correct SKU from Amazon and simply paste it into the SKU column for every item. Then just import that spreadsheet back into Magento and it will update the item information.

Thanks,

Ross

[Manish Mittal]

@ross_cohen

Yes you can update using export-import functionality in Magento 1.

[julie_dougherty]

I cannot find the import/export function in Magento.  I assume it would be in the Manage Products under the Catalog tab but I am not finding it there.  Any help will be appreciated.  

[joykristof]

This blog was really very useful. Helped a lot! Thank you!