I could not find short decriptions in magento 2 table (mysql), where is short decr is located? Please answer.
Best regards, Timur.
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:
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.
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:
Don't rely on the attribute_id of "short_description" being 76. Better look it up in the eav_attribute database table.