magento2
Pulling my hair out here trying to troubleshoot the reason why some new products aren't displaying on the frontend. I've checked the usual stock, weight, visibility, etc and have reindexed and recached plenty of times.
Can anyone think of anything else that could be causing this?
(Also, these products are counted in the result counts for searches, but not actually shown)
Update: products can be accessed directly via their URL/ID, but they aren't showing up in the categories/search results.
Go to admin > Stores > configuration > Catalog > Inventory > Stock Options
Set Display Out of Stock Products to NO
Check SQL statement to get totals count. Change method \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory::create from
public function create(array $data = array())
{
return $this->_objectManager->create($this->_instanceName, $data);
}
to
public function create(array $data = [])
{
$collection = $this->_objectManager->create($this->_instanceName, $data);
$sql = (string)$collection->getSelectCountSql();
$logger = $this->_objectManager->get(\Psr\Log\LoggerInterface::class);
$logger->alert($sql);
return $collection;
}
then refresh your product grid and find SQL statement in the log (.../var/log/debug.log).
Best Answer
A command I hadn't tried before fixed this:
In the past, I'd only used "reindex", but a reset was necessary in this case.