Products disappearing from catalogue & search

[h_dawson]

Hi,

Our website has recently been upgraded to Magento 2.2.2 and since then we have had daily occurrences of products disappearing from the catalogue. The product is still live and can be found/purchased etc. via the URL, but is no longer visible on the front end in any of its categories or via the search bar. 

When this has happened there has been no changes in the back end, and the product looks normal in admin.

Has anyone else experienced this, and if so knows how to resolve it?

Thanks

[Manthan Dave]

Seems like you have issue of indexing database.

Do reindexing by running this command : php bin/magento indexer:reindex

Then after run php bin/magento cache:clean and php bin/magento cache:flush command

It will works , and display products at frontend

[kalyanchakri]

As @Manthan Dave suggested, the problem could be because of re-indexing. Run the reindex commands and clear cache.

Additionally, check the stock availability of the products and see if they are not allowed to show in catalog and search.

[msacco1986]

We have so many people from Magento and our agency looking into this issue for several months now and no one can figure out how to stop this from happening. It happens 15 -20 times a day. The products come back after we flush the cache but unless we are monitoring every category page 24 x  7 we have no idea that the products are missing. M2 has been such a disappointing experience. 

[gelanivishal]

Hello @msacco1986,

It was due to upgrading Magento version via git or others. Also, it is known as Magento 2.1.3/2.1.4/2.1.5 issue.

This is accurate solution.

We can easily add these two files on original Modules folder.

app\code\Modules\Catalog\etc\di.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
<preference for="Magento\Catalog\Model\Indexer\Category\Product\Action\Full" type="Modules\Catalog\Model\Indexer\Category\Product\Action\Full" />
</config>

app\code\Modules\Catalog\Model\Indexer\Category\Product\Action\Full.php

<?php 
namespace Modules\Catalog\Model\Indexer\Category\Product\Action;

/**
 * Class AbstractAction
 * @SuppressWarnings(PHPMD.CouplingBetweenObjects)
*/

class Full extends \Magento\Catalog\Model\Indexer\Category\Product\Action\Full {

    public function isRangingNeeded() {
        return false; // It was "True" as default setting.
    }
}

Then, we should run this command.

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

Finally, You will get products on our category page.

--
If my answer is useful, please Accept as Solution & give Kudos

[phabeeb]

Hi @gelanivishal,

I used this fix, but it didn't help. Products still disappear randomly from category pages, although they're accessible via direct URL. Reindexing brings them back, but then they disappear again.

Thanks.

[Criebox]

I'm using Magento 2.3 and the same issue is happening to me. Products disappear from the category. I can search the product through the search, but they come out of the category. I have to reindex or save the product again.

[kris_wen]

do you happen to have a solution yet? i'm facing the same issue

[Temporary_Fail]

Sometimes I have same problem with CE 2.3.1. Nobody knows solution, no one can help, no one cares...

[msacco1986]

We have had this issue for over a year now and M2 support has no clue how to fix it. Horrible.