EXTREMELY Slow Checkout Problem Identified

Theme and Plugin Support

EXTREMELY Slow Checkout Problem Identified Open

Viewing 7 reply threads
  • Author
    Posts
    • #92312
      photographybb
      Participant

      Hello!

      I am having a problem with very slow checkouts on the checkout page for digital items that have a ZERO dollar price (free). I have narrowed down the problem to the WCMp plugin because when I disable the plugin, free item checkout is fast.

      Also, when I assign a free item to a vendor who has MANY unpaid commissions (since all of their products have been free), the checkout is extremely slow. If I temporarily remove that vendor from being assigned to that product, and keep the product with no assigned vendor, then the checkout is very fast again.

      So this leads me to believe there is some problem either because of the zero dollar commission calculation, or there is a problem with the large number of unpaid order statuses for that vendor (since their products are free), or there is a problem because that vendor has many orders in the system.

      We do have other vendors that sell paid products, and those commissions, calculations, and order processing speed and status are all working quickly and properly.

      How can we resolve the slow checkout for vendors with free products, unpaid zero dollar commissions, and many orders at zero dollars in unpaid status?

      Lastly, when I go into an unpaid order to view the unpaid commission, there are several error warnings as shown in the attached screenshot.

      Thank you!

    • #92347

      Hi @photographybb, I tried to recreate the issue on our end, didn’t face any such difficultly.

      Can you please create a starting site and share the admin and ftp access so we can inspect the issue in your site.

    • #92389
      photographybb
      Participant

      Hi Moumita,

      Thank you very much for having a look. I cannot setup a starting site, but I can check anything you would like me to check and I can make code modifications if you provide the code and tell me where to try inserting it.

      This seems to be a problem that at least two other users are having in this thread where you responded here:
      https://wc-marketplace.com/support-forum/topic/disabling-commission-calculations-about-performance/#post-90418

      I am having the exact same problem. If the vendor has thousands of orders that are “unpaid” because the commissions are zero dollars, the system is too slow (upwards of 30 seconds to checkout on any of their free products). If the vendor only has a few sales, the checkout for their free products are fast. If I remove the vendor from being assigned to the product, the free checkout is very fast also.

      The problem is when a vendor has many unpaid orders. Any new free checkouts of their free products take a long long time to process.

      As with the other user in the link I provided above, the bulk “Mark as paid” feature does not work when trying to mark unpaid commissions as paid.

      Is there a way to automatically mark ZERO dollar commissions as automatically paid? This would seem to solve the checkout delays problem.

      Thank you for all of your help! It is highly appreciated!

      Dave

    • #92395

      @photographybb, we need to debug your site, as for now we are not sure what is causing this issue on your site.

      So, a staging site is always recommended, you may use some plugin like https://wordpress.org/plugins/wp-staging/

      For the other query “Is there a way to automatically mark ZERO dollar commissions as automatically paid? This would seem to solve the checkout delays problem.”, can you share the commission page scrrenshot so I can help you out.
      The Mark as paid should work if the vendor has set at least Payment mode as “Bank Transfer”.

    • #92565
      photographybb
      Participant

      I’ve been able to delete all of these transactions that were set to unpaid, and yes, I can manually mark them as paid if I change the vendor’s method of payment to Bank Transfer. However, some vendors may not like this since they want their free products to be free, but their paid products to be paid via PayPal.

      So, is there a function or script that I can insert somewhere into my website so that FREE products that generate zero-dollar commissions are AUTOMATICALLY marked as PAID?

      Thank you again for all of your help!

      Dave

    • #92608

      Dave, as this required custom code, hence this will need some time.

      Kindly provide them some time.

    • #92742

      Hi, in order to make all 0 commission as paid, add this code to the function.php of the current active theme .

      /**************************  Paid if commission is 0 *******************************/
      add_action( 'init', 'commission_paid' );
      function commission_paid(){
       $default_args = array(
                 'post_type' => 'dc_commission',
                 'post_status' => array('publish', 'private'),
                 'posts_per_page' => -1,
                 'fields' => 'ids',
      
                 'meta_query' => array(
                         'relation' => 'AND',
                         array(
                             'key' => '_paid_status',
                             'value' => 'unpaid',
                             'compare' => '=',
                         ),
                         array(
                             'key' => '_commission_total',
                             'value' => 0,
                             'compare' => '=',
                         )
                 )
       );
       $data = get_posts( $default_args );
       foreach ($data as $key => $value) {
         update_post_meta( $value,'_paid_status', 'paid' );
       }
      }
      Copy

      Please note, as we are not able to recreate this issue on our end, hence first create a staging site and then add this code there. Run some test there, if everything is okay in a staging site, only add the code in the live site.

    • #92929
      photographybb
      Participant

      This worked perfectly thank you! The site speed is much faster and zero commissions are automatically being marked as paid.

      Thank you for your help!

Viewing 7 reply threads

Please LOGIN to reply to this topic

COVID-19 Outbreak: WCMp team is supporting business affected by coronavirus

Read the Message Buy at Slashed Price