A Simple Tutorial to Update Product Attributes in Bulk in Magento 2
Given the number of tasks a Magento 2 store admin has to do, any shortcut technique that reduces the pile of tasks is a blessing š
Magento 2 provides some default product attributes, but you can create product attribute in Magento 2 to address specific needs. After adding the product attributes, you may need to update its values for some reason. If your store has thousands of products, doing it manually is a fool’s errand.Ā I have come up with a tutorial that allows the admin to update product attributes in bulk in Magento 2. You can use this method whenever you have to change the price of multiple products, change labels of products such as “sold out”, put up the sale of selected products, etc.
No need to edit one by one product for these things, owing to batch update for Magento 2 product attributes!
Steps to Update Product Attribute in Bulk in Magento 2:
- Log in to Admin Panel
- Navigate to Catalog > Products
- Select multiple products for which you want to update the product attribute value.
- From the mass action drop-down menu, select “Update Attributes“
- Change the value of product attribute by clicking on “Change” checkbox
- Click “Save“
The steps are shown below:
Easy to follow, isn’t it?
You can also implement these steps to bulk update the value of custom product attributes!
This method is quite useful and a time saver.
Hope it is helpful to you.
Iād be very grateful if you helped share this helpful post on social media to fellow developers!
Thanks!
![Meetanshi Magento Extensions Launches and Updates [July 2019]](png/meetanshi-magento-extensions-launches-and-updates-july-2019-150x150.png)
17 Comments
I want to update SKU in bulk is it possible
Hello Jitendra,
It is not possible to update in bulk using mass action/update from the admin side. However, you can update SKU in bulk by developing a programmatic solution.
Thank you.
I have 2.3.5-p and the price and special price does not show in the update attribute page. All other attributes are there. Please help. I want to remove all the special prices on all products at once.
Hello Rawraj,
I have checked in Magento 2.3.5 -p1 and Magento 2.3.5-p2 both and the options of price and special price are already there. Please do check.
Thank you.
Hello Sir Sanajay
how can add a manufacture attribute to a bundle product?
Hello,
Check your Bundle Product attribute set – https://drops.meetanshi.com/UBYe4G
Add attribute you want to add by drag & drop – https://drops.meetanshi.com/bDwItf
Lastly, run command indexing and cache flush
Thanks
can u answer this question? -> https://magento.stackexchange.com/questions/301545/bulk-product-attribute-update-fails-in-the-magento-2-back-end
Hello,
Please refer the solution at https://meetanshi.com/blog/configure-magento-cron-job/
If you have cron job setup in the live website, the issue will be resolved by following this solution.
Thanks.
Hi Sanjay,
I had done bulk update after that i am getting message like Task “Update attributes for 34 selected products”: 1 item(s) have been scheduled for update. For reference please find the attached image
How can i solve this one ?
Hello,
Can you please set Magento 2 Cron job with the standard method? It will resolve this issue and you’ll face no error.
Thanks.
This doesn’t work in magento 2.3.2 if you select all it hangs. If you select 20 it does it. Magento 2.3.2 is a disaster for anyone who is not a developer. Expect a very big bill and lots of long nights. Magento 1.9 was hugely better than magento 2
Hello Martin,
I’m sorry to hear that you have issues with Magento 2 but there is no option due to the end of life of support for Magento 1.
You can avoid the issue that you mentioned if you upgrade the store to the latest Magento 2 version.
Thanks.
It won’t work on Magento 2.3.2. It makes a bulk operation that won’t finish. It stills says not started
Hello Patrick,
This is a server side issue that you need to fix.
You can refer https://devdocs.magento.com/guides/v2.3/install-gde/prereq/php-settings.html for the settings.
Thanks.
It won’t work in Magento 2.3.2. It makes a Bulk Operation and it’s still says ‘not started’
Can you help?
Thanks for sharing this easy-to-follow guide.
Welcome š