products not showing in category on frontend Magento 2, but values are showing in category ()

[RikPowell]

Hi,

Our items are no longer showing for each category page on the frontend.

I have checked lots of items on the admin:

Enabled = yes
Product in website = yes
Product in category = yes
Stock status in stock = yes
Visibility = catalog, search

Reset index, Reindex and flush cache = yes

Website = https://www.theemporiumdirect.co.uk/

(item blocks such as New items, related items, upsell items are showing).

Any advise would be much appreciated!

Rik

[Manthan Dave]

Hi @RikPowell 

After reindexing also not showing your products ?

Because i have seen the link you have shared and on clicking on category page its showing products.

Give some more information on this so its help us to troubleshoot the issue

Hope it helps !

[RikPowell · Accepted solution]

@Manthan Dave 

Thanks for fast reply.

It is showing ok for you?

I am doing SSH:

php bin/magento indexer:reindex
php bin/magento cache:clean
php bin/magento cache:flush

Hopefully it will work.

Thank you and I will have a look once I clear my cache.

[Manthan Dave · Accepted solution]

Hi @RikPowell 

Yes it is showing to me on almost all the categories

Yes after doing reindexing and cache clean and cache flush please check in private/incognito window of the browser.

You will see all the products under categories

Hope it helps !

[RikPowell · Accepted solution]

Thanks, what appeared to work was SSH commands:

php bin/magento indexer:reindex
php bin/magento cache:clean
php bin/magento cache:flush

Thanks for support.

RP

[Towering Media]

Thanks, It was browser cache.

[Saurabh Mishra]

Hi,

I think you need to run all the command

php bin/magento setup:upgrade
php bin/magento setup:di:compile
php bin/magento setup:static-content:deploy -f
php bin/magento indexer:reindex
php bin/magento cache:flush
sudo chmod -R 777 pub/ var/ generated/

[infopantix9048]

Hello @RikPowell,

I think that your problem is related to the stock status. If you turn it off, the products will be displayed in the frontend.

Link: https://docs.magento.com/user-guide/configuration/catalog/inventory.html

Let me know if it works.

[officialra03ea]

Hi, I have tried everything but still products are not showing, Can you help?

[RikPowell]

The SSH commands worked on the old website. Ensure you have indexing active (Index Management) and have ran the SSH commands plus cleared your browser cache. I am not sure what else to advise you sorry. Does your server host offer any help for Magento websites? If yes open a ticket with them perhaps?