Category listings not working after upgrade to magento 2.1.3

[mikosan42]

After upgrading from m2.1.1 to m2.1.3 the category pages, which are accessible [shop-url]/[categoryname].html are empty.

Preconditions

1. m2.1.1 had theme SM_market v2.3.0 installed; m2.1.3 SM_market v2.5.2
2. Products and Cetegories were defined and produced expected results (listing)

Steps to reproduce

1. Go to https://devl.kouki.ch
2. Under "Kategorien" select "Wäschetransport" --> nothing. Category contains 165 products.

Expected result

1. Listing of the products in the Category

Actual result

1. Empty page with title

[erfanimani]

Needs more info or there's an issue with the theme you're using. 2.1.3 category pages work fine on default Magento here.

[mrdevries]

We're in de midst of debugging something like this with a multi-store with 15 websites. We found out that some (most) products don't have their prices indexed in catalog_product_index_price.

Can you check by running SELECT * FROM `catalog_product_index_price` WHERE `customer_group_id` = 0 AND `website_id` = 1; on your database? If all your products are in a category this should return the same amount of records as you have products.

The story continues...

[mikosan42]

Nope - prices are not null (see attached output). Update: if I create a separate page, using a widget like this: {{widget type="Magento\CatalogWidget\Block\Product\ProductsList" title="Products" products_count="200" template="product/widget/content/grid.phtml" conditions_encoded="a:1:[i:1;a:4:[s:4:`type`;s:50:`Magento|CatalogWidget|Model|Rule|Condition|Combine`;s:10:`aggregator`;s:3:`all`;s:5:`value`;s:1:`1`;s:9:`new_child`;s:0:``;]]”}} I get a correct product listing (although ugly). But when I call the category Page (Products>Categories>[Category]>Search Engine Optimization>URL Key, I get an empty page with nothing but the title… Thank you - Michael

On 09 Jan 2017, at 09:32, Marco de Vries ***@***.***> wrote: We're in de midst of debugging something like this with a multi-store with 15 websites. We found out that some (most) products don't have their prices indexed in catalog_product_index_price. Can you check by running SELECT * FROM `catalog_product_index_price` WHERE `customer_group_id` = 0 AND `website_id` = 1; on your database? If all your products are in a category this should return the same amount of records as you have products. The story continues... — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#8063 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AXzh0kw8cI3htucvngDSFzuMRASNXDJ9ks5rQfCZgaJpZM4Lc1bY>.

KOSCHINSKY CONSULTING Michael Koschinsky Hochwachtstrasse 28D CH-8400 Winterthur Mail: michael@koschinsky.com <mailto:michael@koschinsky.com> Http://koschinsky.com <http://photo.koschinsky.com/> Voice: +41 79 404 93 22

[veloraven]

@mikosan42 thank you for your feedback.
Please provide detailed steps to reproduce: without links to external resources and with exact steps you did during upgrade.

[scher200]

@mrdevries I ran your query and 50% of my product seemed not to be indexed..
What did you do to fix it?

[mrdevries]

@scher200 in our case it was actually quite simple once you see it (like many cases). There were a lot of bundled products on all websites but most of the referenced simple products were only added to the main website. The prices of those simple products were not indexed and in turn, the bundled products not shown in the category.

[veloraven]

According to contributor guide, tickets without response for two weeks should be closed.
If this issue still reproducible please feel free to create the new one: format new issue according to the Issue reporting guidelines: with steps to reproduce, actual result and expected result and specify Magento version.