Sometimes your Magento store will reach a point where a traditional browser-based reindex falls on its face. You’ll probably be presented with something like:
This isn’t good at all, especially if its your product index – you may find things like search and prices do not update if it stays like this!
Well there are many ways to combat this – lots of people tell you to truncate your database index tables, clear your var/locks folder – all sorts of stuff. What I find better is firstly try to re-index via SSH. It’s a lot quicker and most of the time it gets the job done.
To re-index via SSH you simple have to login via terminal/putty or some other SSH client. Now perform the following: