cancel
Showing results for 
Search instead for 
Did you mean: 

Select query show product sku but some product not showing in front end

Select query show product sku but some product not showing in front end

Hi Guys,

 

I have created a magento 2 plugin for product searching, My plugin filter product by sku and after filter when i check sql query by using 

$subject->getSelect() 

show more sku/products but front end not sowing all product that is showing in sql.

Even I have cross checked all product are instock/enable and same as showing product these is no difference bitween them.

If I open those product by direct url, those product show but does not show in filter.

Any one have idea where I need to check the issue or any one let me know after sql which step magento 2 for showing products

 

Thanks

1 REPLY 1

Re: Select query show product sku but some product not showing in front end

There may be additional filters applied after your's. I would try grabbing collecting right from the block and checking the select query to make sure it has not been modified.