Magento 2.2.2 Products Not Showing Category and List Page

Question

I have a real hard time solving this issue.

The issue is products Not showing on front end Category Pages and Product Listing Pages after import via CSV -

Just shows We can't find products matching the selection.

However, if I go to the product in Admin and then RE-SAVE without Any changes - and clear cache that product

will show in front end - on product listing pages and category pages - and shows in Layered Navigation

One thing I noticed is that After resaving the product in Admin - it automatically is adding Color Black to the

product - even if I haven't selected it -

I then tested my import file by adding color Black to the products in the import file to check if they show on

front end - but this did not fix the issue

In the database table, I also noticed for the resaved products and after it adds Black to the color_value column

and color column 49

I tried to match these settings for the products which were not resaved in admin but again these still did not

show on the front end

I imported over 30000 via CSV - all

1.are showing in Admin

2. are showing under the correct categories in Admin

3. Can be seen on the front end by going direct to the product page itself

4. Tested with making products in stock with qty 10 and out of stock with qty 0 - both will not show in

product listing/category pages until they have been resaved in admin

5. Run reindex and cleared all caches

I have set Magento to Display out of Stock Products

The Qty for the products and is_in_stock values are set correctly after import and also the products are

enabled

I have tried to export the products which I have resaved and show in product listing pages and then match each

attribute for the import - however after import again the products NOT saved in Admin don't show on the front end

category and product listing pages.

Spent over 4 weeks on this and tried a lot of things and trial and error.

I checked the database table catalog_product_flat_1 and checked all attributes imported and compared the ones

showing on the front end and the ones which are not - and they made them identical however they still will not show

on front end unless the product has been resaved in the admin.

This is the same case when importing via another extension or application for Magento, for example, Firebear - this

the issue is happening whenever or whatever I use a CSV import.

Another issue is that if I resave the products and they then show on the front end - when I update those same

products via CSV import - the values for example price and qty and is_in_stock only change in admin and not

in front end - on product listing category pages - I then have to resave again and clear cache then the

updated changes are reflected on the front end

I am really stuck on

Answer 1

It seems that you have problems with Products and Categories URLs. Every product need an URL to be displayed in Frontend.

Your product was imported without URL. When you re-save that product, Magento will auto generate a new URL and it will be showed.

Conclusion: you have to add/update records into url_rewrite table in order to make your products presented in Frontend.