Magento re-indexing by Shell scripting:
Normally magento re-index we will do it from admin section. Once you login as a admin, you can see the re-index management from admin -> Configuration -> Index management. Here there is a option to choose the checkbox do the select the “re-index” action from top above right side near submit button dropdown.Instead of this we can do the re-index by Shell scripting command prompt.Doing shell scripting re-indexing is much fast compare with admin panel re-index section.
Commands:
1. First go to shell(magento root folder) folder using command prompt
cd [ROOT]/shell/
2. Find current status of indexing
Cmd [shell]> php indexer.php –status
Once you enter above command prompt, you may see all the index type with current status
Ex:
Product Attribute : Pending
Product Price : Require re-index
etc….
3. Re-index all the index
Cmd [shell] > php indexer.php –reindexall
4. We can do the indivitually also, Indivitual re-index for each index is
Cmd [shell] > php indexer.php –reindex catalog_product_attribute
Cmd [shell] > php indexer.php –reindex catalog_product_price
Cmd [shell] > php indexer.php –reindex catalog_url Catalog
Cmd [shell] > php indexer.php –reindex catalog_product_flat
Cmd [shell] > php indexer.php –reindex catalog_category_flat
Cmd [shell] > php indexer.php –reindex catalog_category_product
Cmd [shell] > php indexer.php –reindex catalogsearch_fulltext
Cmd [shell] > php indexer.php –reindex cataloginventory_stock
5. Multiple command in a line with comma separater
Cmd [shell] > php indexer.php –reindex catalog_product_price,catalog_url,catalog_product_flat, etc
Important Note: Magento EE 1.13 – There is no admin option to re-index for some of the index type. That we need to do using Shell script only.
Great….thanks for sharing
After i hosting, how can i use ssh
Hi Jeeva Rathinam, Using your host & private or public key (if you don’t have Key then you have to use your server Username & password ) you have to login via putty or terminal . And go to your root folder of mageto then do the re-index.
While configuring php shell script, We need to take care of these commands, Abstract.php, Compiler.php, Indexer.php, Log.php, You can check more details about these commands at, https://www.cloudways.com/blog/php-shell-scripts-magento/. Hope it will help your readers as well as I got help from your and this post.
Thanks for sharing useful tips.