Return to previous page

Shop and search results broken after update … AGAIN

This topic has 16 replies, 3 voices, and was last updated 3 months, 1 week ago ago by Tony Rodriguez

pover

Participant

May 12, 2026 at 11:22

Hello,

After our monthly XStore update, we noticed that the search results on https://maanu.pl/ stopped working correctly.

For example, when a user types “szampon” in the search field and presses Enter, the search results page does not display products properly. The shop page also seems to be affected, even though everything worked correctly before the update.

A few months ago, I reported a very similar issue here:
https://www.8theme.com/topic/shop-and-search-results-broken-after-today-update/#post-462016

Could you please investigate and fix this issue permanently?
We would also appreciate clear instructions on how to handle or prevent the same issue after future XStore updates.

Best regards,

#470151 Copied

15 Answers

Andrew Mitchell

Support staff

May 12, 2026 at 11:54

Hello, pover,

Please update the plugin provided to you in the private content and check whether the issue persists

Best regards,
8Theme Team

Please contact administrator
for this information.

#470155 Copied

pover

Participant

May 12, 2026 at 12:44

Hello,

still nothing change. https://maanu.pl/?s=szampon&post_type=product&et_search=true&lang=pl

#470157 Copied

pover

Participant

May 12, 2026 at 14:14

Do you have any updates? its very important feature for our customers

#470168 Copied

pover

Participant

May 12, 2026 at 21:27

Dear Support,

Do you have any updates on this issue?

I downgraded the theme to version 9.7, and the search results started working again.

Best regards,

#470195 Copied

Andrew Mitchell

Support staff

May 13, 2026 at 06:50

Hello, pover,

In this case, we kindly ask you to provide us with access to the FTP and the domain control panel.

Best regards,
8Theme Team

#470207 Copied

pover

Participant

May 13, 2026 at 06:58

OK, please provide your email address so I can create a WP Admin account for you. We have 2FA enabled, so you will need to complete the verification process.

#470210 Copied

Andrew Mitchell

Support staff

May 13, 2026 at 12:21

We have provided the email address in the private content.

Best regards,
The 8Theme Team

Please contact administrator
for this information.

#470238 Copied

pover

Participant

May 13, 2026 at 20:09

The admin account has been created. Please change the password using the “Forgot password” option.

Please contact administrator
for this information.

#470257 Copied

Andrew Mitchell

Support staff

May 14, 2026 at 06:33

Hello, pover,
Thank you for your response. In addition to access to the admin panel, we also require FTP access.

Best regards,
8Theme Team

#470267 Copied

pover

Participant

May 14, 2026 at 06:44

Dear Support,

I have attached a one-time link to retrieve the password.

Please let me know what you plan to do with these credentials. Also, please keep in mind that this is production access to a live website where customers purchase products, so no changes should be made that could disrupt the website or the purchasing process.

Thank you.

Please contact administrator
for this information.

#470269 Copied

Andrew Mitchell

Support staff

May 14, 2026 at 18:16

Hello,
We have made some updates. Please check if the issue still persists.

Best regards,
The 8Theme Team

#470313 Copied

pover

Participant

May 14, 2026 at 20:48

It looks like the problem has been solved. Thank you.

Could you please provide the following information:

What caused the issue?
What exactly was changed to fix it?
How can we prevent this kind of issue after future theme/plugin updates?

#470315 Copied

Andrew Mitchell

Support staff

May 15, 2026 at 09:32

Hello, pover,

The issue was found in XStore’s custom product search SQL within the theme-functions.php file.
In the WPML-specific SKU search section, the SQL condition contained incorrect parenthesis grouping.
This malformed WHERE clause disrupted the product search query on the search results page, causing searches such as ?s=szampon&post_type=product&et_search=true&lang=pl to return no products.

What was changed to fix it?
The fix involved a one-line correction in the WPML SKU search condition.
The closing SQL fragment was changed from ") )" to ")".
This adjustment removed an extra closing parenthesis and restored the correct grouped condition:
OR ( sku_match AND current_language_match [AND stock_match] )

How you can prevent this issue after future updates?
– Keep any custom search fixes in a child theme or a small custom plugin instead of editing the parent theme directly.
– After each XStore or XStore Core update, re-test the following:
– Product search page
– SKU search
– WPML language-specific search
– Use a staging site before updating the production environment.
– Maintain a small regression checklist for:
– ?s=keyword&post_type=product&et_search=true
– The same query with lang=...
– In-stock / out-of-stock behavior
– If the parent theme file is updated again, compare theme-functions.php against your working version before deployment.

Best regards,
8Theme Team

#470341 Copied

pover

Participant

May 15, 2026 at 09:48

Thanks for the support! My topic “Shop and search results broken after update … AGAIN” has been successfully resolved.

#470343 Copied

Tony Rodriguez

Support staff

May 15, 2026 at 09:48

Dear pover,

It’s great having you in our WordPress & WooCommerce community!

Every insight you share helps us refine XStore and build tools that empower thousands of online store owners worldwide.

Leave Feedback →
(takes less than a minute)

Together, we grow stronger with every release.

Topic closed.
The 8Theme Team

#470344 Copied
Viewing 16 results - 1 through 16 (of 16 total)

The issue related to '‘Shop and search results broken after update … AGAIN’' has been successfully resolved, and the topic is now closed for further responses

Shop and search results broken after update … AGAIN

Explore our best WordPress WooCommerce Themes collection