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?
Solved! Go to Solution.
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.