Reindex issue, seller do not appear

[clemence_benharbon]

Hello,

When I create a new account for a new seller it do not appear on magento.

The main issue for not appearing the customers on the admin is reindexing issue.

I have tried to done reindexing many times but indexing is not working.

Any idea why and how to fix it?

thanks

Sharon

[Bhanu Periwal]

Hi @clemence_benharbon 

Try to run below query with database:

update magento.indexer_state set status=‘invalid’ where status =‘working’

Note: Please take backup of table indexer_state first then run query.

It may help you!
Problem Solved? Please click on 'Kudos' & Accept as Solution!

[clemence_benharbon]

Hi @Bhanu Periwal 

Thanks.

I  have tried the mentioned way to resolve caching issue.

But issue is not resolved by this method and also the site mode is also not changing to production.

Any idea why?

thanks

Sharon