cancel
Showing results for 
Search instead for 
Did you mean: 

Products disappearing from catalogue & search

Products disappearing from catalogue & search

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

24 REPLIES 24

Re: Products disappearing from catalogue & search

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

if issue solved,Click Kudos & Accept as Solution

Re: Products disappearing from catalogue & search

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.

Re: Products disappearing from catalogue & search

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. 

Re: Products disappearing from catalogue & search

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

Re: Products disappearing from catalogue & search

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.

Re: Products disappearing from catalogue & search

Re: Products disappearing from catalogue & search

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

Re: Products disappearing from catalogue & search

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

Re: Products disappearing from catalogue & search

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