- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2018
10:01 AM
01-24-2018
10:01 AM
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!
Labels:
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2018
10:41 AM
01-24-2018
10:41 AM
Re: Attribute at products in database
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2018
10:03 PM
01-24-2018
10:03 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2018
10:16 PM
01-24-2018
10:16 PM
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
Magento 2 Blogs/Tutorial