cancel
Showing results for 
Search instead for 
Did you mean: 

Short description in magento 2 table.

Short description in magento 2 table.

Hello everyone, 

 

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

 

Best regards, Timur.

3 REPLIES

Re: Short description in magento 2 table.

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.

Andreas von Studnitz, Trainer, Consultant, Developer and CEO of integer_net, Germany.

Re: Short description in magento 2 table.

Hi @mtimur,



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

Screen Shot 2017-01-27 at 3.49.27 PM.png

 

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

Screen Shot 2017-01-27 at 3.50.16 PM.png

 

Best regards.
Gabriel

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".

Re: Short description in magento 2 table.

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

Andreas von Studnitz, Trainer, Consultant, Developer and CEO of integer_net, Germany.