cancel
Showing results for 
Search instead for 
Did you mean: 

Product is not visible after reindexing

Product is not visible after reindexing

Hi,

 

Can anyone help me regarding this issue??  After reindexer command--

 

Catalog Search index process unknown error:
{"error":{"root_cause":[{"type":"resource_already_exists_exception","reason":"index [magento2_product_1_v6957/rMQZpd26TJ-LgLX6hOn_qw] already exists","index_uuid":"rMQZpd26TJ-LgLX6hOn_qw","index":"magento2_product_1_v6957"}],"type":"resource_already_exists_exception","reason":"index [magento2_product_1_v6957/rMQZpd26TJ-LgLX6hOn_qw] already exists","index_uuid":"rMQZpd26TJ-LgLX6hOn_qw","index":"magento2_product_1_v6957"},"status":400}

 

 It is showing on product listing page. "We can't find products matching the selection."

http://appassociates.ebizontech.biz/goyen-valves/goyen-dresser-nut-valves.html

 

I have tried all below solution & all thing is fine ---

1st reason:- Please check the following for your products
a) Product is out of stock
b) Product status is Disabled
c) Product visibility does not include Catalog
d) Product is not assigned to that particular website

2nd Reason:- Indexing Issue
Go to your root directory via terminal and run ===>> php bin/magento indexer:reindex

3rd Reason:- Maybe one of the product is stuck via indexing
Go to the database and search for "indexer_state" table. Manually set status = "working" to "valid"/"invalid"

or run ===>> update magento.indexer_state set status='invalid' where status ='working'

 

Thanks in advance,

Ritika