Ttdfjt

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:

 (1) USE database;
 (2) SELECT * FROM eav_attribute where attribute_code LIKE '%weight%';
 (3) 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.

The attribute is not stored, is only use for meta purposes by the repo and it is basically a wrapper for the weight attribute within the method customizeWeightField() of class Catalog/Ui/DataProvider/Product/Form/Modifier/General.php

Modifying the product_has_weight you will change the product type; it defaults to 'Virtual' but it will get converted to "Download" if it has downloadable data, remember that 'has' is a magic method prefix, although hasWeight is overridden on product types virtual and downloadable for the purpose of locking down a false Boolean value. The value is not specifically stored, the state will remain in the form of the product type, see the TypeTransitionManager class and the plugin MagentoDownloadableModelProductTypeTransitionManagerPluginDownloadable, on configurable products it will be determined by the sum of the children state specified by the meta modifier.

I have found the constant for the property you are referring to, I haven't been using the API or repositories very much so I haven't seen the attribute before today:

https://github.com/magento/magento2/blob/99e85cbc45223baa3551e4c534b650c0d2c6358b/app/code/Magento/Catalog/Api/Data/ProductAttributeInterface.php

The "weight" code attribute is mentioned in this file but only to update, not add.

https://github.com/magento/magento2/blob/99e85cbc45223baa3551e4c534b650c0d2c6358b/app/code/Magento/Catalog/Setup/InstallData.php

Unfortunately I haven't got a Magento instance set up at the moment, but my first (perhaps stupid) thought is to check catalog/product eav attributes?