Our new products are no longer showing on their respective category pages on the frontend.
I have checked lots of items on the admin:
General->Status = Enabled
General->Visibility = Catalog,Search
Inventory->Qty > 0
Inventory->Stock Availability = In Stock
Websites = assigned to website
Catgories = assigned to their respective categories.
Whereas new products are visible on the homepage in New Arrivals Block.
I have already run all the required commands as below:
php bin/magento setup:upgrade
php bin/magento setup:di:compile
php bin/magento setup:static-content:deploy -f
php bin/magento indexer:reset
php bin/magento indexer:reindex
php bin/magento cache:flush
php bin/magento cache:clean
sudo chmod -R 777 pub/ var/ generated/
php bin/magento cron:run
I have also checked table in database "inventory_stock_1"
and data is properly updated in this table as well.
Also checked below and there is no value as working:
update Magento.indexer_state set status='invalid' where status ='working'
But still, the front end category view shows the only older products and not our newly uploaded products.
Kindly help to resolve this issue as soon as possible.