We can't find products matching the selection

Question

I just updated to 2.3.0 and when I try to open any category page -> instead of filters I am 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?

Reindex & clear cache – simonthesorcerer Feb 27 '19 at 15:43 — simonthesorcerer, Feb 27 '19 at 15:43
i tried, it's not solving – Duddy Woody Feb 27 '19 at 15:44 — Duddy Woody, Feb 27 '19 at 15:44

score 12 · Answer 1 · answered Nov 12 '20 at 19:58

i was facing this challenge and was almost frustrated when i finally got how to fix it. For me I used this

i used the code below to view the table

sql command select *
from catalog_eav_attribute cea 
join eav_attribute ea
  on ea.attribute_id = cea.attribute_id 
  and backend_type in ('text', 'varchar')
where 
  cea.is_filterable = 1

and Set is_filterable to 0 to allow category pages to load.

update catalog_eav_attribute cea 
join eav_attribute ea
  on ea.attribute_id = cea.attribute_id 
  and backend_type in ('text', 'varchar')
set cea.is_filterable = 0
where 
  cea.is_filterable = 1

Reindex/Refresh Cache

magento indexer:reindex
magento cache:clean
magento cache:flush

i got the solution from this link, it was a very helpful solution....thank you doublesharp best solution ever

much appreciated this saved me! – SR_Magento Oct 03 '21 at 17:36 — SR_Magento, Oct 03 '21 at 17:36
Working perfectly Magento2.4.2 Thank you! – Hafiz Arslan Jun 06 '22 at 08:32 — Hafiz Arslan, Jun 06 '22 at 08:32
worked for in 2.4.2, thank you – shafiq Feb 21 '23 at 15:32 — shafiq, Feb 21 '23 at 15:32

score 8 · Answer 2 · answered Feb 23 '21 at 14:05

8

In my case I tried to re-index but noticed the index failed for esatic search:

Catalog Search index exception: Could not ping search engine: No alive nodes found in your cluster

i resolved by running:

sudo systemctl restart elasticsearch

php bin/magento indexer:reindex

php bin/magento cache:flush

answered Feb 23 '21 at 14:05

David Bayley

81
1
2

worked for me. sudo systemctl restart elasticsearch will work – VishalParkash Mar 23 '21 at 04:22
this is it ! Make sure that elasticsearch is running and that magento connects to it (you may test it here: Admin -> Store -> Configuration -> Catalog -> Catalog -> Catalog Search) – Fabianus Jul 10 '23 at 19:25

score 6 · Answer 3 · edited Jun 23 '20 at 19:18

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.

Work for me ! I had an error message with this particular table. — Nico2P, Oct 12 '22 at 10:21

score 4 · Accepted Answer · edited Mar 26 '21 at 10:22

4

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.

Edit:

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.

edited Mar 26 '21 at 10:22

swarup260

28
5

answered Sep 21 '19 at 07:27

mbernt - mediarox

474
2
7

Where is "Stores" ? Edit: He means "Shops" – Black Jun 23 '20 at 15:41

score 1 · Answer 5 · edited Aug 19 '19 at 16:40

1

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

edited Aug 19 '19 at 16:40

Nadeem0035

1,227
12
19

answered May 29 '19 at 08:27

Anil Kumar

11
1
2

Does not fix it for me. – Black Jun 23 '20 at 15:39
me too. I guess the elasticsearch have problem – huykon225 Feb 06 '21 at 13:34

score 1 · Answer 6 · edited Oct 23 '20 at 07:42

1

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

edited Oct 23 '20 at 07:42

Hardik Patel

63
1
11

answered Sep 01 '20 at 08:44

islam sobhi

11
2

score 1 · Answer 7 · answered Mar 03 '23 at 14:01

1

This may sound silly but make sure that both of these are set:

Quantity > 0

Stock Status: In Stock

It may be trivial, but knowing that you must explicitly set "In Stock" even though you've set Qty to a number higher than 0 can save much time.

answered Mar 03 '23 at 14:01

jakubplus

111
1

Yes, this happened to me, as Magento 2 noob I spent an enormous amount of time trying to figure it out! Because there is no error in the logs. – Duke Jun 19 '23 at 12:16

score 0 · Answer 8 · answered Feb 27 '19 at 18:43

0

In Category Enable Anchor in Display Setting.

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

And then reindex it. Hope it will work.

answered Feb 27 '19 at 18:43

Satish Gumudavelly

78
1
4

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

score 0 · Answer 9 · answered Sep 07 '21 at 17:30

0

On version 2.4.2 if there's an error with your elastic search or if it's not running, then no categories will show. Fix it and run upgrade, di:compile, clear cache again.

answered Sep 07 '21 at 17:30

Timothy Nong

1

We can't find products matching the selection

9 Answers9

Linked