Magento 2 – Where PRODUCT_HAS_WEIGHT Attribute is Stored

attributesdatabasemagento-2.1product

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:

USE database
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.

Best Answer

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 Magento\Downloadable\Model\Product\TypeTransitionManager\Plugin\Downloadable, on configurable products it will be determined by the sum of the children state specified by the meta modifier.

A quick solution:

make attribute visible in backend:

UPDATE catalog_eav_attribute cea
INNER JOIN eav_attribute ea ON ea.attribute_id=cea.attribute_id
SET cea.is_visible=1
WHERE attribute_code="the_attribute_code"

change the value in the backend, using grid filter and mass action in product grid (as suggested by Amasty)

make attribute invisible again:

UPDATE catalog_eav_attribute cea
INNER JOIN eav_attribute ea ON ea.attribute_id=cea.attribute_id
SET cea.is_visible=0
WHERE attribute_code="the_attribute_code"

Magento2 Product Attribute – Fix Global Product Attribute Empty on Store View Level

Here is a quick fix.
you need to identify the attribute ids for all global attributes then delete all the values from the catalog_product_entity_* tables that have the attribute id one of those identified above and the store id field not zero.

DELETE FROM `catalog_product_entity_int` 
WHERE
   store_id <> 0 AND
   attribute_id IN (
           SELECT attribute_id 
           FROM catalog_eav_attribute 
           WHERE is_global = 1

   )

Do the same for the tables catalog_product_entity_varchar, catalog_product_entity_text, catalog_product_entity_datetime, catalog_product_entity_decimal.

Rebuild your indexes when your are done.

Note: The select from catalog_eav_attribute in the way I wrote it will give you attribute ids for the global category attributes also, but that's not important since in the product tables you don't have category attributes references.

Also, before trying this, backup your database in case I missed something.

Best Answer

Related Solutions

Magento 1.9 – Quickly Update Attribute Values for Products

A quick solution:

Magento2 Product Attribute – Fix Global Product Attribute Empty on Store View Level

Related Topic