cancel
Showing results for 
Search instead for 
Did you mean: 

Attribute at products in database

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Attribute at products in database

Hello,

 

we want to sync products in the Magento 2 Store.

In witch table I can find the links to the attributes of a products?

 

Attributes are stored in:

eav_attribute_set

eav_attribute

eav_attribute_option

eav_attribute_option_swatch

 

But I can´t find in the products table, where the links to this attrributes are.

 

Thank you!

 

3 REPLIES 3

Re: Attribute at products in database

Hi @georg_filler,

 

I guess the table you're looking for is: catalog_eav_attribute

Re: Attribute at products in database

Hello,

 

thank you ... but where is the link to a product?

I need to know, which product has which attributes.

 

Thank you!

Re: Attribute at products in database

You can get links for product to attributes from below table,

catalog_product_entity_datetime  (attribute related to date format)
catalog_product_entity_decimal (attribute related to pricing)
catalog_product_entity_int (attribute related to int(select box) value like color,size)
catalog_product_entity_text (attribute related to text like description,short_description)
catalog_product_entity_tier_price (attribute related to tier pricing)
catalog_product_entity_varchar (attribute related to multiselect attribute)

You can check links with a product is entity_id and attribute_id refers to attribute id in above all tables.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial