{"id":743,"date":"2020-01-08T06:02:32","date_gmt":"2020-01-08T06:02:32","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/2020\/01\/08\/fix-indexer-reindex-required-error-magento-2\/"},"modified":"2025-05-22T15:08:18","modified_gmt":"2025-05-22T09:38:18","slug":"fix-indexer-reindex-required-error-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/fix-indexer-reindex-required-error-magento-2\/","title":{"rendered":"How To Fix &#8220;Indexer Reindex Required&#8221; Error In Magento 2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Ever faced an issue of the Customer Grid Indexer not working, when reindexing via CLI?!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Me too!!!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sometimes, while running a command in Magento 2, &#8220;indexer re-index required&#8221; error is faced.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is due to an issue in Magento 2 table. The table might have been corrupted in the database where it existed but something was missing.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Run the command <strong>php bin\/magento indexer:status<\/strong> to check the status of indexer:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Design Config Grid: Reindex required\nCustomer Grid: Reindex required\nCategory Products: Ready\nProduct Categories: Ready\nProduct Price: Ready\nProduct EAV: Ready\nCatalog Search: Reindex required\nStock: Ready Catalog Rule Product: Ready\nCatalog Product Rule: Ready<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">When you run the command&nbsp;<strong>php bin\/magento indexer:reindex<\/strong>&nbsp;\u2013 you get the error as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2019\/12\/Screen-Shot-at-December-9th-2019-4.48.47-pm.png\" alt=\"&quot;Indexer Reindex Required&quot; Error In Magento 2\" class=\"wp-image-7190\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Method To Fix Indexer ReIndex Required Error in Magento 2:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Go to <em><strong>C:xamppmysqldatamag232<\/strong><\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Locate customer_grid_flat.ibd table on the customer grid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Rename it to <strong>customer_grid_flat.ibd.old<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once the issue is solved, you can run the command &#8211; php bin\/magento indexer:reindex without any issue as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2019\/12\/Screen-Shot-at-December-9th-2019-4.49.26-pm.png\" alt=\"Solved - Magento 2 Reindex Failed On Customer Grid\" class=\"wp-image-7191\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Do share the solution with the Magento community via social media.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thanks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Also Read:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/meetanshi.com\/blog\/how-to-reindex-in-magento-2\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Reindex in Magento 2 from Admin &amp; CLI?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Ever faced an issue of the Customer Grid Indexer not working, when reindexing via CLI?! Me too!!! Sometimes, while running a command in Magento 2,&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-743","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/743","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=743"}],"version-history":[{"count":2,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/743\/revisions"}],"predecessor-version":[{"id":15125,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/743\/revisions\/15125"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}