Magento 1.9 – How to Get Custom Attribute Value from a Product

attributesmagento-1.9product

I have Magento 1.9. I have to get the value of the custom attribute of an order item. I already have the product like this:

$product = Mage::getModel("catalog/product") -> load($p -> ID);

and this is fine (I logged it, and the object is product object is ok).
To get the custom attribute value, I tried this, and none worked:

error_log("DEV 1:" . print_r($product -> getData("ds_dropship_product_id"), true));
error_log("DEV 2:" . print_r($product -> getDsDropshipProductId(), true));
error_log("DEV 3:" . print_r($product -> getAttributeText("ds_dropship_product_id"), true));
$attribute_code="ds_dropship_product_id"; // attribute with text value
$some = $product -> getDsDropshipProductId();
error_log("DEV 4:" . $some);
error_log("DEV 5:" . print_r($some, true));

$attribute_value = Mage::getResourceModel('catalog/product')->getAttributeRawValue($p -> ID, $attribute_code, 1);
error_log("DEV 6:" . $attribute_value);

$description_attribute = $product->getResource()->getAttribute($attribute_code);
error_log("DEV 7: " . var_dump($description_attribute));
//error_log("DEV 8" . print_r($description_attribute, true));

$description_attribute_value = $description_attribute ->getFrontend()->getValue($product);
error_log("DEV 9" . $description_attribute_value);
error_log("DEV 10" . $product->getData($attribute_code));
error_log("DEV 11" . $product->getResource()->getAttributeRawValue($product->getId(), $attribute_code,  $product->getStoreId()));

$attribute_code="ds_dropship_product_id";

error_log("DEV 12" . $product->getAttributeText($attribute_code));
error_log("DEV 13" . $product->getResource()->getAttribute($attribute_code)->getDefaultFrontendLabel());
error_log("DEV 14" . $product->getResource()->getAttribute($attribute_code)->getStoreLabel());
error_log("DEV 15" . $product->getResource()->getAttribute($attribute_code)->getFrontendInput());

Do you know any other known way to do this?

Best Answer

What worked at last was only this:

$collection = Mage::getResourceModel('catalog/product_collection')
        ->addAttributeToSelect('ds_dropship_product_id')
        ->addFieldToFilter("entity_id", 3)
        ->load(1);

        $p = $collection->getFirstItem();
        $ds_id= $p->getData('ds_dropship_product_id');
        error_log("DEV 16:" . $ds_id);

Related Solutions

Magento – Create a sortable and filterable custom attribute to stand-alone entity

When adding the product attribute, set used_in_product_listing, used_for_sort_by and filterable to true.

You can do that with the following update script:

$installer = Mage::getResourceModel('catalog/setup', 'catalog_setup');
$installer->startSetup();
$installer->updateAttribute('catalog_product', 'product_type', 'used_in_product_listing', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'used_for_sort_by', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'is_filterable', 1);
$installer->endSetup();

Thats all, if if you are NOT using the flat catalog.

If you enable the flat catalog product feature, then you need to ensure that your custom source model implements the methods getFlatColums(), getFlatIndexes() and getFlatUpdateSelect().
If they are missing, your attribute won't be included in the generated flat tables, even if used_in_product_listing is enabled.
Have a look at the class Mage_Eav_Model_Entity_Attribute_Source_Boolean for an example. You can probably copy over the methods with minimal adjustments into your custom source model from there. Otherwise, please ask a new question.

Product Attributes – Save Value for a Specific Custom Product Attribute from Product Model

There are 2 ways to go about this, one is by getting the Magento catalog/product model and loading the product by ID which will give you the whole product, then setting the name and saving it.

$product = Mage::getModel('catalog/product')->load(1);
$product->setName('foobar!');

try {
   $product->save();
} catch(Exception $e) {
  echo "{$e}";
}

As OP pointed out, this is quite heavy just for changing one attribute. I kind of figured that the attribute mass update tool should use a cleaner way to do this and found the Mage_Catalog_Model_Resource_Product_Action class

$product_id = 1;
$store_id = 0;

$action = Mage::getModel('catalog/resource_product_action');
$action->updateAttributes(array($product_id), array(
    'name' => 'foobar!'
), $store_id);

[UPDATE] benchmark

So did a quick benchmark script and the results speak for itself.

$starttime = microtime(true);

for ($i=20; $i>0; $i--)
{
    $action = Mage::getModel('catalog/resource_product_action');
    $action->updateAttributes(array(1), array(
        'name' => 'foobar!'
    ), 0);
}

echo "Time: " . (microtime(true) - $starttime) . " seconds\n";

$starttime = microtime(true);

for ($i=20; $i>0; $i--)
{
    $product = Mage::getModel('catalog/product')->load(1);
    $product->setName('foobar!');
    $product->save();
    unset($product);
}

echo "Time: " . (microtime(true) - $starttime) . " seconds\n";

Time: 0.076527833938599 seconds

Time: 4.757472038269 seconds

Best Answer

Related Solutions

Magento – Create a sortable and filterable custom attribute to stand-alone entity

Product Attributes – Save Value for a Specific Custom Product Attribute from Product Model

Related Topic