Options (colors) to Products

options-to-products.php

<?php
require_once('app/Mage.php');
ob_implicit_flush(true);
umask(0);
set_time_limit(0);
ini_set('display_errors', 1);
Mage::app();
Mage::setIsDeveloperMode(true);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

$attribute = Mage::getModel('eav/entity_attribute')
                ->loadByCode('catalog_product', 'color');

$valuesCollection = Mage::getResourceModel('eav/entity_attribute_option_collection')
            ->setAttributeFilter($attribute->getData('attribute_id'))
            ->setStoreFilter(0, false);

$colors = array();            
foreach($valuesCollection as $value) {
    $colors[$value->getOptionId()] = $value->getValue();
}   


if (count($colors)) {
    echo "<h2>Colors</h2><ul>";
    foreach($colors as $optionId => $value) {
        $products = Mage::getModel('catalog/product')->getCollection();
        $products->addAttributeToSelect('color');
        $products->addFieldToFilter(array(
            array('attribute'=>'color', 'eq'=> $optionId
        )));

        echo "<li>" . $value . " - (" . $optionId . ") - (Products: ".count($products).")</li>";
    }
    echo "</ul>";
}

exit;