Okay
  Public Ticket #3542161
Massive loading issue in B2B King
Closed

Comments

  •  4
    Joost started the conversation

    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.


  •  1,904
    WebWizards replied

    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

  •  4
    Joost replied

    Unfortunately it doesn't work. The problem is still there.

    Attached files:  Schermafbeelding 1.png
      Schermafbeelding 2.png
      Schermafbeelding 3.png

  •  1,904
    WebWizards replied

    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');
    


  •  4
    Joost replied

    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:  Schermafbeelding.png

  •  1,904
    WebWizards replied

    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,

  •  4
    Joost replied

    No problem. I can create a login for you. How can I share the login with you? Can I email it to you?

  •  1,904
    WebWizards replied

    Yes, please use our email at [email protected] - if you create an account on your site using this email, we will be notified directly.

  •  4
    Joost replied

    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!!!

  •  1,904
    WebWizards replied

    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