Skip to content

Instantly share code, notes, and snippets.

@lnoering

lnoering/productAttributes.md

Last active September 2, 2022 17:37
Show Gist options
  • Save lnoering/3fd4cef0695530a46a8d9905d686393d to your computer and use it in GitHub Desktop.
Save lnoering/3fd4cef0695530a46a8d9905d686393d to your computer and use it in GitHub Desktop.
Download ZIP
[Magento 2] - Get all attributes from product
Raw
productAttributes.md

Get all product attributes from entity

SELECT
	ea.attribute_code,
	ea.frontend_label,
	ea.entity_type_id 
FROM 
	eav_attribute AS ea
LEFT JOIN eav_entity_type as eat ON eat.entity_type_code = 'catalog_product'
WHERE 
	ea.entity_type_id = eat.entity_type_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment