cancel
Showing results for 
Search instead for 
Did you mean: 

Attribute at products in database

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

Re: Attribute at products in database

Hi @georg_filler,

 

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

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"

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.