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

attributes disappear

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.
12

Hello

Yes, that seems to be the problem.

I did a check and it has to do with visibility taxonomy. I've temporarily disabled this. Try generating the file again. It should now be over 14000.

 

Thanks, it did generate all products but problem persists.

File updated!!!

Products and Variants: 14020

Results:

host311022.xce.pl/moda/?LSCWP_CTRL=before_optm

 

There's one more thing I'd wish to report, I have price filter set to off but these 2 slow queries show up on category/filter pages. both take 0,3s (10x longer than other slowest queries)

 

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)
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 (1532)
AND tt1.term_taxonomy_id IN (1532) )
  1. WOOF_HELPER::get_filtered_price()
Plugin: woocommerce-products-filter10.2658
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)
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 (1532)
AND tt1.term_taxonomy_id IN (1532) )

Hello

Please try this option Advanced->Option - https://share.pluginus.net/image/i20240829121429.png

There's no such option, especially under Advanced=>Options. https://imgur.com/a/Hs4EM6Z

And what about initial problem - all filters keep disappearing. Earlier guessing didn't help: https://host311022.xce.pl/moda/?LSCWP_CTRL=before_optm

Hello

This option is only available when Turbo mode is disabled.

I don't understand, are you just guessing whole time?

  1. First you said it's not plugin fault, but theme.
  2. Created staging with default theme and you give me few"solutions", none worked.
  3. The problem is still unsolved, it would be easiest if you simply opened staging website, told me what changes you made and case closed.

 

So far:

  1. Disabled most plugins that can interfere, inclucing litespeed cache
  2. Using default theme
  3. Did steps you mentioned
  4. Set $limit = apply_filters("woof_turbo_mode_products_limit", 20000);

Result:

Products and Variants: 14020

But there are 15 019 products in total

 

And what's most important: filters still keep disappearing.

Try: https://host311022.xce.pl/moda/

Hello

I never wrote anywhere that the problem is in the theme

I immediately assumed that not enough products were being formed, and all this time this reason was being solved (no guesses). This is the first thing to check.

you give me few"solutions", none worked.  - It works! Now the file is generated correctly

But there are 15 019 products in total - https://share.pluginus.net/image/i20241015140129.png

Also, to display (count) products on the category page, the product must be marked along the entire category chain - https://share.pluginus.net/image/i20241015140658.png AND https://share.pluginus.net/image/i20241015140724.png - fix this and update the search file

If I disable"Show count" then"Hide empty terms" is forced to"No". I don't care count, but Hide empty terms is a must - I don't see reason to show 20 unavailable colours.

 

the product must be marked along the entire category chain

- Main cat

--Cat 2

---Cat 3

----Cat 4 <= product is here

 

do you mean it has to be marked on EVERY single category (4 categories) to make it work?

- count is not needed

- hide empty terms is necessary

Hello

I don't see reason to show 20 unavailable colours.  - I also don't see the point in this setting

do you mean it has to be marked on EVERY single category (4 categories) to make it work?  - yes, that is, the product must have a marked category hierarchy (parent category)

- count is not needed  -  Yes of course, but if there is no correct calculation the plugin will not detect empty terms

12