Magento – Cannot associate Simple Products in a Configurable

magento

I did an upgrade from 1.4.2 to 1.5.0 and realized that the product association in a Configurable product didn't work. After hours of rollbacks and testing I haven't found a solution. Even though I did a rollback to the previous version and database I couldn't get it back on track. I've tried to uninstall all extensions we have installed lately with the same result. This site is more or less based on Configurables so we are sort of stuck…

I've found some details though;

  • Simple products created before the upgrade can be associated to a new Configurable product and existing ones.
  • Simple products made after the upgrade can’t be associated to any Configurable product.
  • When I create a new Configurable and make an association with the quick tool the new Simple product is created, but there's no insert to the database table catalog_product_relation for example.

It seems that the Adminhtml is broken by something. I have no lead any longer so please fill in with suggestions what to look for.

Best Answer

I've finally found it, hours later. :)
I went through the server side code, the client js-scripts and came to the conclusion that even though the server side is updated, the js-scripts are the same. And they didn't get the data back I expected when the association was added. It all drilled down to the settings of the attribute that the configurable option was based upon (it seems the DB lookup is changed and the attribute affected the result). I found that the result sets from the db differed when a simple product was created before the upgrade, compared to a simple product created after the upgrade.
I think 1.5 is alot more picky when it comes to the settings as this attribute has been used for more then 500 products with no problem.

I changed the attribute to be valid for all product types and not mandatory. Now we can create Configurables again!

Related Topic