I just updated to 2.3.0 and when i try to open any category page -> instead of filters i'm getting "Compare products" and "My wishlist" + . instead of product list getting message "We can't find products matching the selection."

How can i solve/investigate this question???

  • 1
    Reindex & clear cache – simonthesorcerer Feb 27 '19 at 15:43
  • i tried, it's not solving – dukir Feb 27 '19 at 15:44

Depending on the version you upgraded from it might be a missing stock source/default. Can't check right now but you should find two menu entries under shops or system.


With Magento 2.3 a new feature called Multi Source Inventory was introduced. After an upgrade from a prior version you need to set a source and a default stock. So the settings I mentioned can be found under Stores > Inventory > Sources. Here you need to configure a source. Under Stores > Inventory > Stocks you need to apply default stock to your website.

It may also require a reindex.


In Category Enable Anchor in Display Setting.

 Enable Anchor Tag

In Attribute set Filter with Results in Use in Layered Navigation.


And then reindex it. Hope it will work.

  • No, it's not. These steps are dont, but not solve this – dukir Feb 28 '19 at 12:48

Run this command to fix the issue php bin/magento indexer:reindex


You have to recreate the inventory_Stock_1 view in Database. You can make it happen with an query (like this);

CREATE OR REPLACE VIEW inventory_stock_1 AS select distinct legacy_stock_status.product_id AS product_id, legacy_stock_status.website_id AS website_id, legacy_stock_status.stock_id AS stock_id, legacy_stock_status.qty AS quantity, legacy_stock_status.stock_status AS is_salable, product.sku AS sku from ( cataloginventory_stock_status legacy_stock_status join catalog_product_entity product on (( legacy_stock_status.product_id = product.entity_id )));

After that, you have to reindex Magento: php bin/magento indexer:reindex

Now all should be displayed and looks fine.

Hope it helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.