It ‘very useful to extract the list of the category especially when you automate import processes through the “data flow” function.

In magento information regarding the categories are distributite on different tables, the SQL queries to extract the full list of categories is as follows:

SELECT DISTINCT cc.entity_id as id, cc.value as path, cc1.value as name    
  FROM catalog_category_entity_varchar cc    
  JOIN catalog_category_entity_varchar cc1 ON cc.entity_id=cc1.entity_id    
  JOIN eav_entity_type ee ON cc.entity_type_id=ee.entity_type_id
  JOIN catalog_category_entity cce ON cc.entity_id=cce.entity_id
  WHERE cc.attribute_id = '57' AND cc1.attribute_id = '41' AND ee.entity_model = 'catalog/category';

The result will be a list of categories with their "ID" to be used in the import file.

Leave a Reply

Your email address will not be published. Required fields are marked *