Hi,
We have an issue where items are not showing as out of stock on the product category page when they go out of stock, they are showing as out of stock on the product page but not the category pages without a manual re index through SSH.
All cron jobs look to be setup correctly but some updates such as the above aren't being displayed and we have lots of items still showing as in stock but when clicked on they load the product page which shows the item is out of stock.
I have checked the cron job status's and quite a few have 'working (2060 in backlog)' or similar which I think it causing the issue of them not working when ran on schedule:
Title | Status | Update On | Schedule Status | Schedule Updated |
+----------------------+--------+-----------+---------------------------+---------------------+
| Amasty Feed Products | Ready | Schedule | working (18 in backlog) | 2020-12-10 17:53:13 |
| Amasty Feed Rule | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:43 |
| Amasty Product Label | Ready | Schedule | working (1 in backlog) | 2020-12-10 14:20:35 |
| Amasty Product Label | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:43 |
| Catalog Product Rule | Ready | Schedule | idle (1 in backlog) | 2020-12-13 22:57:02 |
| Catalog Rule Product | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:32 |
| Catalog Search | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:42 |
| Category Products | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:31 |
| Customer Grid | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:28 |
| Design Config Grid | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:17 |
| Inventory | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:37 |
| Product Categories | Ready | Schedule | working (2060 in backlog) | 2020-12-10 14:20:33 |
| Product EAV | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:36 |
| Product Price | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:40 |
| Smart Label Product | Ready | Schedule | idle (0 in backlog) | 2020-12-13 23:08:43 |
| Smart Product Label | Ready | Schedule | idle (15 in backlog) | 2020-12-10 14:20:36
(copied text as screenshots won't upload in post for some reason)
I have tried
php bin/magento indexer:reset
and then
php bin/magento indexer:reindex
but running:
php bin/magento indexer:status
still shows the same results.
Any ideas how to clear this down for each of the jobs with something in the backlog?
Thanks.
