Short description in magento 2 table.

[mtimur]

Hello everyone, 

I could not find short decriptions in magento 2 table (mysql), where is short decr is located? Please answer. 

Best regards, Timur.

[avstudnitz]

Magento has a specific database model for products (categories, customers and customer addresses) called EAV (Entity Attribute Value). You have a single row for every attribute in every product. You will find the short description in the table catalog_product_entity_text, while:

• entity_id is a reference to the product in the product main table catalog_product_entity
• attribute_id is a reference to the attribute, here "short_description". The main attribute table is eav_attribute, where you can find out the attribute_id for each attribute
• store_id tells you if it's a global value (0) or a store view specific one (>0)

With this information, you can find the short_description value of each product. You can find a more detailed explanation at http://devdocs.magento.com/guides/m1x/magefordev/mage-for-dev-7.html. Don't wonder if it's about Magento 1 - it stayed the same in Magento 2.

[Gabriel Guarino]

Hi @mtimur,

You can find the short description for the products in the "catalog_product_entity_text" table:

The attribute_id for short description is 76, as can be seen in the eav_attribute table:

Best regards.
Gabriel

[avstudnitz]

Don't rely on the attribute_id of "short_description" being 76. Better look it up in the eav_attribute database table.