PluginUs.Net - Business Tools for WooCommerce and WordPress

[realize your idea - make your dreams come true]

Support Forum

You need to log-in to create request (topic) to the support

Columns filter keeps disappearing

The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page please
If you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.

Hi. I have problems with columns filters disappearing.  I have SEO enabled, because I need this functionality.

Ajax and ajaxify are off. With these settings enabled, I can filter category and filter is still visible, but when I go to SEO category created by plugin - category plugin is not visible anyway, hence I believe it's seo option.

Unfortunately I can't share access to shop due to laws, can I be pointed somehow direction?

My settings:  https://pasteboard.co/dbkS0IEQI2g5.jpg

I did a conflict test with Health Check & Troubleshooting and it turns out categories didnt show up because of perfect brands by quadlayers. I'll try other brands plugin, hopefully yith

I did quick test with other plugin, installed yith brands plugin, created 3 brands and now when I open seo category, categories plugins are visible but brands arent (but the taxonomy is good, the brands should be visible). sorry, i just noticed there's an edit button.

Since I can't edit anymore, I noticed with query monitor that when any of these 2 plugin brands are enabled, then I get slow query warning which is as follows (I have 36 products per page set):

I don't have any price filter enabled.

Spoiler

SELECT min( FLOOR( price_meta.meta_value + 0.0) ) as min_price, max( CEILING( price_meta.meta_value + 0.0) )as max_price
FROM wp_posts
LEFT JOIN wp_postmeta as price_meta
ON wp_posts.ID = price_meta.post_id
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_relationships AS tt1
ON (wp_posts.ID = tt1.object_id)
LEFT JOIN wp_term_relationships AS tt2
ON (wp_posts.ID = tt2.object_id)
WHERE wp_posts.post_type = 'product'
AND wp_posts.post_status = 'publish'
AND price_meta.meta_key IN ('_price')
AND price_meta.meta_value > ''
AND ( wp_term_relationships.term_taxonomy_id IN (273,274,275,288,304,499,503,2114,2115)
AND tt1.term_taxonomy_id IN (67,69,71,72,73,113,114,116,120,167,175,269,272,273,274,275,276,277,278,279,280,281,283,287,288,289,290,291,292,293,294,295,297,301,302,303,304,306,307,308,309,310,311,312,313,314,372,374,375,376,377,379,380,381,382,383,388,389,390,395,396,415,425,483,484,485,487,499,503,512,560,562,573,574,594,595,710,715,716,717,757,766,775,1494,1514,1515,1516,1545,1548,1564,1565,1566,1567,1788,2006,2007,2032,2033,2034,2035,2036,2037,2038,2039,2040,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117)
AND tt2.term_taxonomy_id IN (67,69,71,72,73,113,114,116,120,167,175,269,272,273,274,275,276,277,278,279,280,281,283,287,288,289,290,291,292,293,294,295,297,301,302,303,304,306,307,308,309,310,311,312,313,314,372,374,375,376,377,379,380,381,382,383,388,389,390,395,396,415,425,483,484,485,487,499,503,512,560,562,573,574,594,595,710,715,716,717,757,766,775,1494,1514,1515,1516,1545,1548,1564,1565,1566,1567,1788,2006,2007,2032,2033,2034,2035,2036,2037,2038,2039,2040,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117) )

WOOF_HELPER::get_filtered_price

0.0834
SELECT min( FLOOR( price_meta.meta_value + 0.0) ) as min_price, max( CEILING( price_meta.meta_value + 0.0) )as max_price
FROM wp_posts
LEFT JOIN wp_postmeta as price_meta
ON wp_posts.ID = price_meta.post_id
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_relationships AS tt1
ON (wp_posts.ID = tt1.object_id)
LEFT JOIN wp_term_relationships AS tt2
ON (wp_posts.ID = tt2.object_id)
WHERE wp_posts.post_type = 'product'
AND wp_posts.post_status = 'publish'
AND price_meta.meta_key IN ('_price')
AND price_meta.meta_value > ''
AND ( wp_term_relationships.term_taxonomy_id IN (273,274,275,288,304,499,503,2114,2115)
AND tt1.term_taxonomy_id IN (67,69,71,72,73,113,114,116,120,167,175,269,272,273,274,275,276,277,278,279,280,281,283,287,288,289,290,291,292,293,294,295,297,301,302,303,304,306,307,308,309,310,311,312,313,314,372,374,375,376,377,379,380,381,382,383,388,389,390,395,396,415,425,483,484,485,487,499,503,512,560,562,573,574,594,595,710,715,716,717,757,766,775,1494,1514,1515,1516,1545,1548,1564,1565,1566,1567,1788,2006,2007,2032,2033,2034,2035,2036,2037,2038,2039,2040,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117)
AND tt2.term_taxonomy_id IN (67,69,71,72,73,113,114,116,120,167,175,269,272,273,274,275,276,277,278,279,280,281,283,287,288,289,290,291,292,293,294,295,297,301,302,303,304,306,307,308,309,310,311,312,313,314,372,374,375,376,377,379,380,381,382,383,388,389,390,395,396,415,425,483,484,485,487,499,503,512,560,562,573,574,594,595,710,715,716,717,757,766,775,1494,1514,1515,1516,1545,1548,1564,1565,1566,1567,1788,2006,2007,2032,2033,2034,2035,2036,2037,2038,2039,2040,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117) )

 

 

 

Otherwise normal query is:

 

Spoiler
SELECT wp_posts.ID
FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_relationships AS tt1
ON (wp_posts.ID = tt1.object_id)
WHERE 1=1
AND ( wp_term_relationships.term_taxonomy_id IN (67,69,71,72,73,113,114,116,120,167,175,269,272,273,274,275,276,277,278,279,280,281,283,287,288,289,290,291,292,293,294,295,297,301,302,303,304,306,307,308,309,310,311,312,313,314,372,374,375,376,377,379,380,381,382,383,388,389,390,395,396,415,425,483,484,485,487,499,503,512,560,562,573,574,594,595,710,715,716,717,757,766,775,1494,1514,1515,1516,1545,1548,1564,1565,1566,1567,1788,2006,2007,2032,2033,2034,2035,2036,2037,2038,2039,2040,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117)
AND tt1.term_taxonomy_id IN (388)
AND wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (29,22) ) )
AND wp_posts.post_type = 'product'
AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC

hello

Please paste your license key here - https://share.pluginus.net/image/i20230222134241.png -> https://share.pluginus.net/image/i20230222134511.png

You can't provide access to the site, but can you provide a link to the issue?

This is a request to get a price range.

https://share.pluginus.net/image/i20240327121347.png this setting should solve it(if requested again)

Thanks for prompt reply. I decided to use attributes as brands based on your recommendations.

Regarding price slider, I got it enabled and SQL queries price only when brands were active. I opened new ticket with other questions to don't mix stuff. Thanks again

boomer, I can't make new topic with error"Maximum is reached for today!".

 

Here you can see kid's toys shop catalogs structure:

https://freeimage.host/i/Jj0gz9p

Products have attributes such as age and gender. Based on that, I want to create SEO friendly categories, for example gift guide for 3 year old boy. These pages will have index and follow, so far so good, I figured it out. Some problems I'm facing:

  • Some of the pages shouldn't be indexed by google (I prefer not to use robots to block), they should have noindex tag. I use woof_seo_do_index hook, however it doesn't work. I disable other plugins and still no action, I try with

 

add_filter('woof_seo_do_index', function ($do_index, $curr_url, $request_data) {

$do_index=true; //or false, whatever. none work
return $do_index;
}, 10, 3);

I'm checking on SEO friendly url page generated by plugin.

  • I want to also add a category description and display it inside woocommerce_before_shop_loop hook. However since filter pages are dynamically generated, Rank Math won't help me here. I thought about using snippets, echo based on URI but then it will slow down the page. Easiest way would be to display text from"Meta description" field entered in SEO URL Request, but I couldn't find any information, can you guide me on it too? It should be simple since the text is already displayed in Meta box. Thanks

 

 

Hello

1 woof_seo_do_index - this only works for search result pages  Please  drop  me  exact  link to  the  issue

2 In this case you need code customization.  file - wp-content\plugins\woocommerce-products-filter\ext\url_request\classes\seo.php