Price-Indexer Will Not Re-Index in Magento

Interface: SSH
Engine: Magento 1.8
Plugin: Organic Internet’s Simple Configurable Products

Organic Internet’s Simple Configurable Products is a handy Plugin if you’re creating Configurable Products, and wish to only have to set the price of the Simple Product, and not on every Configurable Product. This way, you can change your what-cha-ma-call-it from 4$ for the small to 5$ by only changing it on the Simple Product, not on every single Configurable Product in your store. If you have 100 configurable items (or even 5 for that matter) in your store, trust me, this is a good thing.

So, what I had done is first create my Simple Products that I was going to be associating with my Configurable Product, then I created my Configurable Product. All was good.

Then I added this handy Plugin: “Simple Configurable Products”, and changed a few things around, and noticed that I had to re-index a few things in the Index Manager (this was a warning at the top of the page). When I went to the Index Manager, my Price-Indexer wasn’t re-indexing for me.

Obviously this isn’t acceptable since prices do change.

I dug around a while, and there is already a lot of information out there on this solution, but it was still kind of hard to find the right solution.

The Solution

There is a GitHub forum around this exact issue. It has the solution I’ll be relaying here.

To solve this issue, go into the file located at:

../app/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php

and add the following code:

line 87 ->      'group_price'       => new Zend_Db_Expr('pi.group_price'),
line 88 ->      'base_group_price'  => new Zend_Db_Expr('pi.group_price'),

line 131 ->     'group_price',
line 132 ->     'base_group_price',

Note: I always try to make my code align with the way it’s done in the file. This one was a bit tricky!

The Tools

I ran into a problem though when I was trying to access this file my usual ftp way (I use Notepad++). So, I ended up having to use SSH directly and alter the file using the command:

sudo vi [path to magento folder]/app/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php

The commands when using vi are fairly straight forward.

i = insert
esc = exit insert
:wq = save and quit

Hope this helps!

This article referenced:

• Organic Internet’s Github Fix
• There’s also a bit of information about this in the Magento Forum too, which I didn’t have to use.