Version 2.0.0 causes blank category pages

Thank you for brining this to my attention. I am not seeing blank this on my end when I test. The plugin code does not have ‘page’, ‘attachment’, or ‘new-arrivals’ anywhere in it. But it is designed to manipulate the query to hide discontinued products if opted for.

I am actually having the opposite problem in some of my tests. Discontinued products are not being hidden from an archive page.

Were you able to run the data updater?

I would be grateful if you would help me work through issues to get 2.0 up to speed.

Hi I have the same problem, after update to version 2 , in the product category nothing is showing. In some cases where we have out of stock product in the category, it only shows the out of stock products in the categories. other product not showing up. It also has conflict with WordPress product filters widget when you applied specific filter from products attributes where you have defined on Woocommerce, it shows out of stock products. It seems it is related to existed conflict between your plugin and the queries and filters in Woocommerce. I did not put check mark to hide discontinued product.

The other problem is that it does not replace the price or out of stock text with discontinued text. in the product page and in the category page.

• This reply was modified 3 weeks, 6 days ago by ehsanfarhangi.

Thank you for looking into this)

“Discontinued Products data update complete. Thank you.”

Using the Storefront theme with only Query Monitor, WC and Discontinued Products active, all category pages display no products.

Main Query:
With DP activated:

SELECT SQL_CALC_FOUND_ROWS wpjk_posts.ID
FROM wpjk_posts
LEFT JOIN wpjk_term_relationships
ON (wpjk_posts.ID = wpjk_term_relationships.object_id)
LEFT JOIN wpjk_term_relationships AS tt1
ON (wpjk_posts.ID = tt1.object_id)
WHERE 1=1
AND ( wpjk_posts.ID NOT IN (
SELECT object_id
FROM wpjk_term_relationships
WHERE term_taxonomy_id IN (7) )
AND wpjk_term_relationships.term_taxonomy_id IN (208)
AND tt1.term_taxonomy_id IN (45) )
AND ((wpjk_posts.post_type = ‘product’
AND (wpjk_posts.post_status = ‘publish’
OR wpjk_posts.post_status = ‘private’)))
GROUP BY wpjk_posts.ID
ORDER BY wpjk_posts.menu_order ASC, wpjk_posts.post_title ASC
LIMIT 0, 12

Rows: 0

With DP deactivated:

SELECT SQL_CALC_FOUND_ROWS wpjk_posts.ID
FROM wpjk_posts
LEFT JOIN wpjk_term_relationships
ON (wpjk_posts.ID = wpjk_term_relationships.object_id)
WHERE 1=1
AND ( wpjk_posts.ID NOT IN (
SELECT object_id
FROM wpjk_term_relationships
WHERE term_taxonomy_id IN (7) )
AND wpjk_term_relationships.term_taxonomy_id IN (45) )
AND ((wpjk_posts.post_type = ‘product’
AND (wpjk_posts.post_status = ‘publish’
OR wpjk_posts.post_status = ‘private’)))
GROUP BY wpjk_posts.ID
ORDER BY wpjk_posts.menu_order ASC, wpjk_posts.post_title ASC
LIMIT 0, 12

Rows: 6

With DP 1.1.5:

SELECT SQL_CALC_FOUND_ROWS wpjk_posts.ID
FROM wpjk_posts
LEFT JOIN wpjk_term_relationships
ON (wpjk_posts.ID = wpjk_term_relationships.object_id)
WHERE 1=1
AND wpjk_posts.ID NOT IN (397,378,339,332,325,315,305,223)
AND ( wpjk_posts.ID NOT IN (
SELECT object_id
FROM wpjk_term_relationships
WHERE term_taxonomy_id IN (7) )
AND wpjk_term_relationships.term_taxonomy_id IN (45) )
AND ((wpjk_posts.post_type = ‘product’
AND (wpjk_posts.post_status = ‘publish’
OR wpjk_posts.post_status = ‘private’)))
GROUP BY wpjk_posts.ID
ORDER BY wpjk_posts.menu_order ASC, wpjk_posts.post_title ASC
LIMIT 0, 12

Rows: 6

I’m seeing exact same thing on 2 different sites after updating.

Categories and Attribute pages showing zero results.

Thank you all very much for your input. When you have time and if it is not too much trouble can you update to 2.0.1 and test, and let me know your results?

After many years of neglect i would really like to get this plugin up and running again and your input has been very helpful already ??

That did not fix it either but it did fix other bugs I found. Now 2.0.2 fixes the empty category pages.

Hi, The issue with product query has been resolved on version 2.0.2 thank you so much.

The other problem is that in the archive category page and in the shop page, it does not replace the “price” or “out of stock” text with discontinued text. Still out of stock text shows instead of discontinued., above add to cart button.

Regards,

HI, There is also problem with search bar, when you search products it will not show any product in the search result page.

I deactive the plugin and search result working, but when plugin active it is not working.

Yes, category pages are working now, but not search.

@ehsanfarhangi Please start a new thread for the text replacement issue.

Edit: Started new topic

I lost side widget areas and top fields on my page after upgrading. Deactivating the plugin returned the missing items. Flatsome theme and version 2.0.2.

• This reply was modified 3 weeks, 4 days ago by MrNetland.
• This reply was modified 3 weeks, 4 days ago by MrNetland.

@beknetland and others— You need to start a new topic with these separate issues, please.

Hello I am back. Sorry for the wait. I was out of town last week. I will work on all of these. Thank you again for your help and for your patients.

Hey Everyone could you please update to 2.0.3 and confirm that the search page is no longer empty?

Yes! Categories and search are working on my site now. Thank you!