For some of our configured products (unfortunately), the
PRODUCT_HAS_WEIGHT attribute has not been set to
1. Although, the products all have weight set (as a float), Magento still refuses to provide shipping calculation for these products.
I want to modify the
PRODUCT_HAS_WEIGHT property for all products in the database. For that I want to access the MySQL database and issue a query that updates all the corresponding fields. Unfortunately, I was unsuccessful in identifying the attribute to update.
For example, to examine the weights, I would do the following:
SELECT * FROM eav_attribute where attribute_code LIKE '%weight%'
SELECT * FROM catalog_product_entity_decimal where attribute_id = 82
In a similar fashion as in line (2),
product has weight is not found.
I'd kindly ask the community, to help me find the related attribute to update for each product.
I'm using Magento CE 2.1.6.