You can get all the attribute by using the sql query.

Run the following sql query to get the list of all product attributes in magento

select attribute_id, attribute_code, frontend_label from mgsu_eav_attribute where entity_type_id IN (select entity_type_id from mgsu_eav_entity_type where entity_type_code = ‘catalog_product’ order by attribute_id)

If you want to get all product attribute title and code then you can use the following magento code.

$attributes = Mage::getResourceModel(‘catalog/product_attribute_collection‘)
->getItems();

foreach ($attributes as $attribute){
echo $attribute->getAttributecode();
echo ‘<br>’;
echo $attribute->getFrontendLabel();
}

Fact-Checked & Verified by W3ctrl

This content has been written and reviewed by Adobe-Certified Technical Experts with over 16 years of experience in Enterprise Architecture.