How to mass update products weight with MySQL query?

[kostianev]

Dear, I need to update all my products that has 0.3 kg weight in Database/MySQL with Query, but can`t find where is stored. My Magento is 2.2 how can update the weight direct in the SQL for all products?

[Sunil Patel · Accepted solution]

Hello @kostianev

you can do following way

select * from eav_attribute where attribute_code='weight'; it will give you id of that attribute

select * from catalog_product_entity_decimal where attribute_id=82 // find that attribute value

update catalog_product_entity_decimal set value='' where attribute_id=82 and value='0.3'

you can do from the backend as well, filter by weight and mass update attribute.

If it will work then mark as solution.

[kostianev]

Thank you very much! @Sunil Patel