Attribute at products in database

[georg_filler]

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!

[Damian Culotta]

Hi @georg_filler,

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

[georg_filler]

Hello,

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

I need to know, which product has which attributes.

Thank you!

[Rakesh Jesadiya]

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.