How can i check all my categories have META Tags Values (Title, Desc, Keywords)

Question

I need to check my all categories have proper meta tags (title, description, keywords). Which table stored category meta tags (title, description, keywords) value.

Answer 1

You can try this ...

require_once('./app/Mage.php');
umask(0);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

$attributes = array('name', 'meta_title', 'meta_description', 'meta_keywords');
$collection = Mage::getModel('catalog/category')->getCollection()
    ->addAttributeToSelect($attributes);

$out = array();
foreach ($collection as $category) {
    $out[$category->getId()] = array(
        $category->getData('name'),
        $category->getData('meta_title'),
        $category->getData('meta_description'),
        $category->getData('meta_keywords')
    );
}

var_dump($out);

Edit: for CSV-Export:

$fp = fopen('file.csv', 'w');
foreach ($out as $fields) {
    fputcsv($fp, $fields);
}
fclose($fp);

Answer 2

This data is all in either catalog_category_entity_text or catalog_category_entity_varchar tables. The following sql will get all the category names (and paths just in case you have duplicate category names) where the description is NULL. You will have to find the relevant entity_id values for the other data you want. (The values I have given below are specifically for my database - yours may be different). I hope this gets you started

select ccev.value as name,ccet.value as description,cce.path from catalog_category_entity cce 
join catalog_category_entity_text ccet on cce.entity_id = ccet.entity_id
join catalog_category_entity_varchar ccev on cce.entity_id =ccev.entity_id
where ccet.attribute_id='44'
and ccev.attribute_id='41'
and ccet.value is NULL