Unirgy :: Blog

Bug in Magento Product Collections (UPDATE: it’s a feature)

If you ever had issues with products disappearing from collections when they shouldn’t be, here’s one of the possible reasons:

There’s a

1	Mage_Bundle_Model_Observer::loadProductOptions()

method, which calls

1	$collection->addPriceData()

on EVERY product collection, which has some nasty consequences.

For example, if you have configured System > Configuration > Inventory > Stock Options > Display Out of Stock Products to No, then all the out of stock products will not show up in ANY product collection, because $collection->addPriceData() inner joins with price index table, which doesn’t have entries for products not shown on the frontend (Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_productLimitationJoinPrice)

Anyways, I hope this saved you few minutes (hours) of debugging… I will update this post when or if I’ll find an acceptable solution.

UPDATE: Got a clarification from senior Magento developer: This is an intended behavior.
All the product collections, when not in admin, will be forced to hide products out of stock if this is configured.
I don’t like it, and don’t think that should be the case, but I guess that’s life.

March 16th, 2011| Bugs, Magento| 1 Comment »

Rapid Prototyping for Custom Magento Extensions

I’ve finally had enough of dreading to write all the configuration for each custom module, and invested a couple of hours into this:

http://unirgy.com/wiki/uscaffold

Feedback is welcome as always!

December 19th, 2010| Extensions, Magento| No Comments »

How to use the same Magento copy with multiple DBs and configurations

If you ever need to run multiple Magento configurations from the same copy of core files, this wiki article will help you with basic configuration.

I’ve used it to create QA and demo copies, for easy upgrade of both Magento and tested/demoed extensions.

Let me know if it was useful for you!

February 6th, 2010| Magento, Tips| 4 Comments »

Adding your extension version to admin pages

So you’d like users of your extension to know which version it is, so you can give them support, without asking them to open extension files?

In your helper add this method:


public function addAdminhtmlVersion($module)
{
    $layout = Mage::app()->getLayout();
    $version = (string)Mage::getConfig()
        ->getNode("modules/{$module}/version");

    $layout->getBlock('before_body_end')->append(
        $layout->createBlock('core/text')->setText('

<script type="text/javascript">
$$(".legality")[0].insert({after:"'.$module.' ver. '.$version.'<br/>"});
</script>

        ')
    );

    return $this;
}

And in your controller action, add the method call:


// ADD:
Mage::helper('yourhelper')->addAdminhtmlVersion('Your_Module');
// BEFORE:
$this->renderLayout();

Now on admin pages that were introduced by your module it will show “Your_Module ver. 1.2.3″ right above the Magento version.

July 10th, 2009| Extensions, Magento, Tips| No Comments »

Importing product images with CSV

I’ve seen recently this issue – editing and saving products in admin deleted existing images from frontend.

On evaluation it appeared that the images, while showing on the frontend, did not appear in the admin product edit Images tab at all.

Inspection of the database tables revealed that while EAV records contained image names (used on frontend), the image gallery (used in admin) was missing the relevant entries, so it appears that CSV import does not populate gallery table.

This problem will happen with both new and updated products, when new image names are added with CSV.

I’ve made an SQL statement that will fill the missing records, and which you will need to run each time after importing products with images using CSV:


insert into catalog_product_entity_media_gallery (attribute_id, entity_id, `value`)
select ga.attribute_id, v.entity_id, v.value 
from catalog_product_entity_varchar v
inner join eav_entity_type et on et.entity_type_code='catalog_product'
inner join eav_attribute va on va.entity_type_id=et.entity_type_id and va.frontend_input='media_image' and va.attribute_id=v.attribute_id
inner join eav_attribute ga on va.entity_type_id=et.entity_type_id and ga.attribute_code='media_gallery'
left join catalog_product_entity_media_gallery g on g.entity_id=v.entity_id and g.value=v.value
where v.value<>'no_selection' and v.value<>'' and g.value is null;

March 20th, 2009|Tags: dataflow, fix, images, import, Magento| Magento, Tips| 2 Comments »

Unirgy

Archive for the ‘Magento’ Category

Bug in Magento Product Collections (UPDATE: it’s a feature)

Rapid Prototyping for Custom Magento Extensions

How to use the same Magento copy with multiple DBs and configurations

Adding your extension version to admin pages

Importing product images with CSV

Categories

Archives

Tags