Caching issue hiding all products from shop link

Anonymous

#193448

Whenever I add a lot of new products to my store, they disappear on the front end at the /shop link. It took me weeks to discover it had to do the search and filter caching. All I had to do was rebuild the cache for my main search and everything was peachy again. However, just today this strategy no longer works. Once I start the rebuild cache process I can see it working. Meaning products start repopulating on the /shop page. BUT once the caching reaches 100% they all disappear again. I need to find out if there is a limit on products, if it’s a recent woocommerce update affecting this or what. But bottom line is search and filter plugin.

Trevor

#193482

How do you add these products? Using a bulk import process/plugin, or manually in the editor, one product at a time?

Anonymous

#193524

This reply has been marked as private.

Anonymous

#193528

This reply has been marked as private.

Trevor

#193587

This reply has been marked as private.

Anonymous

#194237

This reply has been marked as private.

Trevor

#194347

Hi Lisa, what Hosting company are you using?

Anonymous

#194430

This reply has been marked as private.

Trevor

#194442

The first thing to do, before we try anything else, is to see if your hosting (WP Engine) is the issue.

There is a setting to override a ‘feature’ of WP Engine hosting, that truncates long SQL queries (which ours are). Edit the site wp-config.php file and add this at the top, after line 1 (on a new line 2):

define('WPE_GOVERNOR', false);

PLEASE DO NOT COPY code from the email you receive for this reply, as email systems sometimes alter the quote marks and encode some characters; instead copy it from the actual forum page.

(also see here for another related support note about this – https://support.searchandfilter.com/forums/topic/killed-query-errors-in-log/#post-64826)

[Author]

Posts