{"id":17034,"date":"2020-05-04T00:01:15","date_gmt":"2020-05-04T04:01:15","guid":{"rendered":"https:\/\/bangla.salearningschool.com\/recent-posts\/?p=17034"},"modified":"2020-05-04T08:05:32","modified_gmt":"2020-05-04T12:05:32","slug":"all-about-magento-2-indexing-reindexing","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=17034","title":{"rendered":"All About Magento 2: Indexing\/reindexing"},"content":{"rendered":"<p>[Do not forget to search this site to learn\/find related information]<\/p>\n<p># Use reset to reset current indexing status<br \/>\n# You may not need to use this all the time<br \/>\n# You will need to use this when you see invalid indexing status or you see index locked;<br \/>\n# When irrespective of that, you want to reindex, reset first<\/p>\n<p>sudo php bin\/magento indexer:reset<\/p>\n<p># want to see reset status of all indexes use the command below<br \/>\nsudo php bin\/magento indexer:status [indexer]<\/p>\n<p># to see status of one index<br \/>\nsudo php bin\/magento indexer:status [index name, one from the list given at the end]<\/p>\n<p># to check information and status on indexing\/reindexing<br \/>\nsudo php bin\/magento indexer:info<\/p>\n<p># execute the reindex: i.e. reindex<br \/>\nsudo php bin\/magento indexer:reindex<\/p>\n<p># you might find these commands useful<\/p>\n<p># i.e. when to reindex such as real-time (update on save) or by &#8220;Schedule and cron&#8221;<\/p>\n<p>sudo php bin\/magento indexer:show-mode<br \/>\nsudo php bin\/magento indexer:show-mode [indexer]<br \/>\nsudo php bin\/magento indexer:set-mode {realtime|schedule} [indexer]<\/p>\n<p># the index types are provided below. If you just want to work with one of them, use the term from the below list<br \/>\nand put on the right side of each of the command above<\/p>\n<p># design_config_grid Design Config Grid<br \/>\n# customer_grid Customer Grid<br \/>\n# catalog_category_product Category Products<br \/>\n# catalog_product_category Product Categories<br \/>\n# catalogrule_rule Catalog Rule Product<br \/>\n# catalog_product_attribute Product EAV<br \/>\n# cataloginventory_stock Stock<br \/>\n# inventory Inventory<br \/>\n# catalogrule_product Catalog Product Rule<br \/>\n# catalog_product_price Product Price<br \/>\n# scconnector_google_remove Google Product Removal Feed<br \/>\n# scconnector_google_feed Google Product Feed<br \/>\n# catalogsearch_fulltext Catalog Search<\/p>\n<p>###### If you want to configure from the admin menu, use: System -&gt; index and then do as the image below shows:<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/bangla.salearningschool.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png\" rel=\"attachment wp-att-17035\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-17035 aligncenter\" title=\"screen-shot-2020-05-03-at-3-43-03-pm-png\" src=\"https:\/\/i0.wp.com\/bangla.salearningschool.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png?resize=707%2C432\" alt=\"\" width=\"707\" height=\"432\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png?w=920 920w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png?resize=300%2C183 300w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png?resize=768%2C469 768w\" sizes=\"auto, (max-width: 707px) 100vw, 707px\" \/><\/a><\/p>\n<p><em><strong>***. ***. ***<\/strong><\/em><\/p>\n<p><em><strong>Note: Older short-notes from this site are posted on Medium: <\/strong><\/em><a href=\"https:\/\/medium.com\/@SayedAhmedCanada\">https:\/\/medium.com\/@SayedAhmedCanada<\/a><\/p>\n<p>*** . *** *** . *** . *** . ***<br \/>\n<em><strong>Sayed Ahmed<\/strong><br \/>\n<\/em><br \/>\n<em><strong>BSc. Eng. in Comp. Sc. &amp; Eng. (BUET)<\/strong><\/em><br \/>\n<em><strong>MSc. in Comp. Sc. (U of Manitoba, Canada)<\/strong><\/em><br \/>\n<em><strong>MSc. in Data Science and Analytics (Ryerson University, Canada)<\/strong><\/em><br \/>\n<em><strong>Linkedin<\/strong>: <a href=\"https:\/\/ca.linkedin.com\/in\/sayedjustetc\">https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a><br \/>\n<\/em><\/p>\n<p><em><strong>Blog<\/strong>: <a href=\"http:\/\/bangla.salearningschool.com\/\">http:\/\/Bangla.SaLearningSchool.com<\/a>, <a href=\"http:\/\/sitestree.com\">http:\/\/SitesTree.com<\/a><\/em><br \/>\n<em><strong>Training Courses: <\/strong><a href=\"http:\/\/training.SitesTree.com\">http:\/\/Training.SitesTree.com<\/a> <\/em><br \/>\n<em><strong>8112223 Canada Inc\/Justetc<\/strong>: <a href=\"http:\/\/JustEtc.net\">http:\/\/JustEtc.net<\/a><\/em><\/p>\n<p><em><strong>Facebook Groups\/Forums to discuss (Q &amp; A): <\/strong><\/em><br \/>\n<a href=\"https:\/\/www.facebook.com\/banglasalearningschool\">https:\/\/www.facebook.com\/banglasalearningschool<\/a><br \/>\n<a href=\"https:\/\/www.facebook.com\/justetcsocial\">https:\/\/www.facebook.com\/justetcsocial<\/a><\/p>\n<p><em>Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. <\/em><a href=\"http:\/\/sitestree.com\/training\/\">http:\/\/sitestree.com\/training\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[Do not forget to search this site to learn\/find related information] # Use reset to reset current indexing status # You may not need to use this all the time # You will need to use this when you see invalid indexing status or you see index locked; # When irrespective of that, you want &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=17034\">Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[182],"tags":[],"class_list":["post-17034","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":16367,"url":"http:\/\/bangla.sitestree.com\/?p=16367","url_meta":{"origin":17034,"position":0},"title":"Reindex magento data using PHP (Shell) and Command Line","author":"Sayed","date":"November 8, 2019","format":false,"excerpt":"You can go to the shell folder, and run the following to reindex everything php indexer.php --reindexall Magento 2 has similar command line features. php bin\/magento indexer:reindex --- To reindex individually php yourmagentofolder\/shell\/indexer.php -reindex catalog_product_attribute php yourmagentofolder\/shell\/indexer.php -reindex catalogsearch_fulltext php yourmagentofolder\/shell\/indexer.php -reindex catalog_category_flat php yourmagentofolder\/shell\/indexer.php -reindex cataloginventory_stock php yourmagentofolder\/shell\/indexer.php -reindex\u2026","rel":"","context":"In &quot;Magento 2&quot;","block_context":{"text":"Magento 2","link":"http:\/\/bangla.sitestree.com\/?cat=1907"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16497,"url":"http:\/\/bangla.sitestree.com\/?p=16497","url_meta":{"origin":17034,"position":1},"title":"Magento 2: Reset indexes","author":"Sayed","date":"December 9, 2019","format":false,"excerpt":"Reset indexes if index reindexing causes issues. All possible combinations for native indexes: \" bin\/magento indexer:reset design_config_grid; bin\/magento indexer:reset customer_grid; bin\/magento indexer:reset catalog_category_product; bin\/magento indexer:reset catalog_product_category; bin\/magento indexer:reset catalogrule_rule; bin\/magento indexer:reset catalog_product_attribute; bin\/magento indexer:reset cataloginventory_stock; bin\/magento indexer:reset catalog_product_price; bin\/magento indexer:reset catalogrule_product; bin\/magento indexer:reset catalogsearch_fulltext; Reference:https:\/\/mirasvit.com\/knowledge-base\/magento-2-reindex-error-locked.html","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26239,"url":"http:\/\/bangla.sitestree.com\/?p=26239","url_meta":{"origin":17034,"position":2},"title":"Reindex Magento data using PHP (Shell) and Command Line #Root","author":"Author-Check- Article-or-Video","date":"April 20, 2021","format":false,"excerpt":"You can go to the shell folder, and run the following to reindex everything php indexer.php --reindexall Magento 2 has similar command line features. php bin\/magento indexer:reindex --- To reindex individually php yourmagentofolder\/shell\/indexer.php -reindex catalog_product_attribute php yourmagentofolder\/shell\/indexer.php -reindex catalogsearch_fulltext php yourmagentofolder\/shell\/indexer.php -reindex catalog_category_flat php yourmagentofolder\/shell\/indexer.php -reindex cataloginventory_stock php yourmagentofolder\/shell\/indexer.php -reindex\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15984,"url":"http:\/\/bangla.sitestree.com\/?p=15984","url_meta":{"origin":17034,"position":3},"title":"Upgrade magento from 2.3.1 to 2.3.2","author":"Sayed","date":"August 19, 2019","format":false,"excerpt":"Upgrade Magento from 2.3.1 to 2.3.2 From 2.3.0 to 2.3.2 should also work; from some other earlier versions may or may not work.. A very similar approach worked for me (Note: I have no interest to work in the industry with Magento). Also, after upgrade, check the error log and\/or\u2026","rel":"","context":"In &quot;Magento 2&quot;","block_context":{"text":"Magento 2","link":"http:\/\/bangla.sitestree.com\/?cat=1907"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14846,"url":"http:\/\/bangla.sitestree.com\/?p=14846","url_meta":{"origin":17034,"position":4},"title":"Learn some CentOS Linux : Redhat Linux","author":"Sayed","date":"June 29, 2019","format":false,"excerpt":"This is mostly about Centos Linux. However, this also shows commands related to how to install Magento 2 on LEMP (E for Nginx Web-server). Some PHP related stuff are there as well. LEMP + CentOS + Magento 2 : VM Image or one click install: I did not see readily\u2026","rel":"","context":"In &quot;Magento 2&quot;","block_context":{"text":"Magento 2","link":"http:\/\/bangla.sitestree.com\/?cat=1907"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":76369,"url":"http:\/\/bangla.sitestree.com\/?p=76369","url_meta":{"origin":17034,"position":5},"title":"Solution that worked for the issue: Your current session has been expired. for Magento2","author":"sayedjustetc","date":"November 17, 2024","format":false,"excerpt":"Solution that worked for the issue: Your current session has been expired. for Magento2 cat shell-scripts\/temp.sh# fix misc issues, can be routine sudo php bin\/magento maintenance:enable#sudo rm -rf var\/cache\/#sudo rm -rf generated\/sudo chmod +x bin\/magentosudo php bin\/magento setup:upgrade#sudo php bin\/magento setup:static-content:deploy -fsudo php bin\/magento setup:di:compilesudo php bin\/magento indexer:reindexsudo php bin\/magento\u2026","rel":"","context":"In &quot;Root&quot;","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/17034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17034"}],"version-history":[{"count":3,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/17034\/revisions"}],"predecessor-version":[{"id":17038,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/17034\/revisions\/17038"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17034"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}