Magento – Magento Index : Update Required field always is set to YES

indexingmagento-1.8

I am not very much sure about how Magento Indexing works, But "Update Required" field is set to "Yes" immediately after i am done with re-indexing all indexes.

enter image description here

I have few queries regarding indexing

On what condition status of an Indexer changes?
Are various indexer available in Magento are dependent on each other?
Why it shows "Update required = Yes" even it is in "Ready" status.
?
Is indexing executed on daily basis?If yes, then from where we
can change time of its execution?
If a store receives couple of thousand request to update inventory
via Soap API, do indexer are executed and updated for every request
which is received to update inventory of a product?

Your valuable input are much appreciated.

Thank You.

Best Answer

On what condition status of an Indexer changes?

Anything that triggers the event. For more information see below.

Are various indexer available in Magento are dependent on each other?

Yes and no. You technically don't need one for the other, but performance and other issue will arise by not using them jointly.

Why it shows "Update required = Yes" even it is in "Ready" status. ?

One show the Status that needs to be updated. The "Ready" status just means its available to. When it's not available it will say processing or error.

Is indexing executed on daily basis?If yes, then from where we can change time of its execution?

It depends, you have to Update on Save. So on every save of the indexing event. There is also manual if you want to manually do it or there is tools out there that can run on cron as well.

If a store receives couple of thousand request to update inventory via Soap API, do indexer are executed and updated for every request which is received to update inventory of a product?

Yes, it will update the indexer, however, based on you setting is how it will fire. It's important to make sure that your store is getting the newest results. However, resources are used so just keep that in mind.

How indexing works in magento

There is a lot of great information out there for this as well. Let me know if you have any other questions.

Related Solutions

Magento – Catalog Search Index Not Changing Status ‘Required Index’ Fix

Check which events set the indexes to invalid

Magento docs show the events for every index (see Events that Trigger Reindexing):

Further you can add some debug code in Mage_Index_Model_Resource_Process::updateStatus()

if ($status === Mage_Index_Model_Process::STATUS_REQUIRE_REINDEX) {
    Mage::log(sprintf('Indexer %s was invalidated.', $process->getIndexer()->getName()), null, 'invalid_index.log', true);
    foreach (debug_backtrace() as $db) {
        Mage::log(sprintf('%s::%s', $db['class'], $db['function']), null, 'invalid_index.log', true);
    }
}

This should show you a stack trace about what is setting the indexes to invalid. In my case it were API requests of 'catalogProductUpdate'

You can also check the exception.log if you'll find any locks of the 'index_process' table. This tables holds the data you see in System > Index Management

Creds for the debug code go here

Magento 1.8 Customer Account – Remove Required Field on Create Account

I have checked it and it's saying "your room" is a required. whereas I can't see this field. You can do two things:

You can delete this required customer attribute from database. For removing any custom attributes run below code by adding some where in your loading templates file
```
$setup = new Mage_Eav_Model_Entity_Setup('core_setup');
$setup->removeAttribute('customer', 'customcode');`
```
Note: replace customcode with attribute code of "your room" Once run, please remove above code.
Or, If you don't want to remove this customer attribute then post a dummy or null value using hidden type field with this attribute from customer registration template.

Best Answer

Related Solutions

Magento – Catalog Search Index Not Changing Status ‘Required Index’ Fix

Magento 1.8 Customer Account – Remove Required Field on Create Account

Related Topic