The most efficient way to run the reindexing through command line using SSH.
- Log in to your server or hosting account via SSH, change to the magento user.
- Navigate to /public_html/shell/ folder
- Check the status of the indexes to see what needs reindexing
php indexer.php --status - To reindex all
php indexer.php --reindexall - Or, find the key names of each index and reindex only the items requiring a reindex
php indexer.php --info - Running the above will give you a list as follows:
catalog_product_attribute
Product Attributes
catalog_product_price
Product Prices
catalog_url
Catalog URL Rewrites
catalog_product_flat
Product Flat Data
catalog_category_flat
Category Flat Data
catalog_category_product
Category Products
catalogsearch_fulltext
Catalog Search Index
cataloginventory_stock
Stock Status
tag_summary
Tag Aggregation Data - Now choose the key names that require reindexing and run, seperating with a comma if more than one
php indexer.php --reindex key_name_here - As an example, if we need to reindex catalog_product_flat and catalog_category_product we would choose
php indexer.php --reindex catalog_product_flat,catalog_category_product - Now we wait until completion