Public Ticket #3542161

Massive loading issue in B2B King

Closed
Comments
8 Tickets 6
Joost started the conversation 3 years ago on December 13, 2023 at 12:05am

There is a new massive loading issue when creating a dynamic rule. Initially, when loading the page, it takes 10+ seconds and makes 25000 queries to the DB. But when clicking on "For who" (next to "rule type"). The page loads infinitely.

Please fix this, we discovered this issue when migrating our website from woocommerce-b2b to your plugin. We are now stuck in the migrating process because we can't make the rules.


2,762
KingsPlugins replied 3 years ago on December 13, 2023 at 7:57am

Hi there,


The issue you described is usually caused by a large number of products or customers, and the page/ browser / server is not able to retrieve and display all.


To solve this, please try to go to B2BKing -> Settings -> Other and enable these settings:

5254359363.png


Enabling these usually resolves it as it replaces the dropdowns with user / product ID boxes. 


Kind regards,

Stefan

2,762
KingsPlugins replied 3 years ago on December 13, 2023 at 8:27pm

Hmm, does the shop have a large number of tags? This might be it as we recently added a feature to select dynamic rules by tag.

Please try adding this PHP code snippet to disable this:

add_filter('b2bking_dynamic_rules_show_tags','__return_false');


8 Tickets 6
Joost replied 3 years ago on December 14, 2023 at 4:19pm

Unfortunately, this is not the solution either. We have 0 tags, more than 8,000 products and just over 300 customers.

It is strange that with the dynamic rules the users dropdown is still there even though we have the 'Dynamic rules: replace users dropdown' option enabled.

Attached files:

2,762
KingsPlugins replied 3 years ago on December 14, 2023 at 11:32pm

Unfortunately I'm not really sure what else it could be.

Is it possible to share a temporary backend login to the site with us? (or to a staging clone site?) 

That would be the best way I could look into this directly to troubleshoot and get it resolved for you as soon as possible,

8 Tickets 6
Joost replied 3 years ago on December 16, 2023 at 3:54pm

I had created a login for you and when I checked it, it turned out that there was no problem with that login. Further investigation revealed that the problem was caused by the Query Monitor plugin. We have disabled it and the problem is now solved.

Thank you very much for your help!!!

2,762
KingsPlugins replied 3 years ago on December 16, 2023 at 10:41pm

Hi again,

I understand then that the issue is resolved. Glad to hear that!

If I can still help with anything, please let me know at any time,


Kind regards,

Stefan

Sign In