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.