Reindexing Magento Data via Shell

January 24th, 2020

Reindexing Magento Data via Shell

The fastest and recommended way to do reindexing in Magento is run it through Shell. To do so go to your Magento Web root directory( eg. /var/www/html/).

To execute all the indexes at once run the following command.

gt; php shell/indexer.php reindexall
If you only have to index one or two indexes, it is not recommended running the indexing for entire data. Individual indexing syntax for

#Category Flat Data

gt; php shell/indexer.php –reindex catalog_category_flat
#Product Flat Data

gt; php shell/indexer.php –reindex catalog_product_flat
#Stock Status

gt; php shell/indexer.php –reindex cataloginventory_stock
#Catalog product price

gt; php shell/indexer.php –reindex catalog_product_price
#Category URL Rewrites

gt; php shell/indexer.php –reindex catalog_url_category
#Product URL Rewrites

gt; php shell/indexer.php –reindex catalog_url_product
#All URL Redirects

gt; php shell/indexer.php –reindex url_redirect
#Catalog Category/Product

gt; php shell/indexer.php –reindex catalog_category_product
#Catalog Search

gt; php shell/indexer.php –reindex catalogsearch_fulltext
#Tag Aggregation Data

gt; php shell/indexer.php –reindex tag_summary
#Product Attributes

gt; php shell/indexer.php –reindex catalog_product_attribute
Magento strongly recommends this method if your store got more products. This method usually avoids time-out issues and also limit the chances of getting any database error.

Re-indexing needs more resources, you should run this while there are few users online.

Know More About This Topic from our Techies

Programmer writing readme file
Reduce Latency with Load Balancing
How Cubet Hopes to Redefine Cyber Security Needs with AI
Why React Native Is the Right Choice for Mobile Application Development
What Are You Missing in Your Web Application Project and Why Do We Recommend Laravel
Why Laravel Application Development Is Not a Piece of Cake for Everyone

Latest Post

Get a free quote