• Resolved lsjl1

    (@lsjl1)


    I have several woocommerce stores.
    Only this store has a lot of orders with pending payment status.
    Please help me check the cause

    The page I need help with: [log in to see the link]

Viewing 15 replies - 1 through 15 (of 16 total)
  • Hi, @lsjl1!

    To start, can you please clarify for us, for these orders where the status is Pending payment, are you still receiving the funds in PayPal?

    Next, can you please share a copy of your System Status Report with us? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it into your reply here.

    If you’re not comfortable sharing that information in a public forum, you can also contact us at WooCommerce.com > My Account > Support and share your full System Status Report with us there. You may need to create an account before you can access that page.

    In your request, please share :

    • Your site’s full System Status Report
    • A screenshot of an example order where the status is pending payment; please make sure the screenshot includes as much information as possible, especially the order notes on the right. If you don’t already have a screenshot service installed, you can use https://snipboard.io
    • A link to this thread
    Thread Starter lsjl1

    (@lsjl1)

    No receiving the funds in PayPal

    Thread Starter lsjl1

    (@lsjl1)

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.silverholder.com
    Site address (URL): https://www.silverholder.com
    WC Version: 5.4.1
    REST API Version: ? 5.4.1
    WC Blocks Version: ? 5.1.0
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 2.3.1
    Log Directory Writable: ?
    WP Version: 5.7.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: ?
    
    ### Server Environment ###
    
    Server Info: nginx/1.18.0
    PHP Version: 7.4.20
    PHP Post Max Size: 50 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.70.0
    OpenSSL/1.0.2u
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.34-log
    Max Upload Size: 50 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 5.4.1
    WC Database Prefix: wp7v_
    Total Database Size: 127.41MB
    Database Data Size: 67.10MB
    Database Index Size: 60.31MB
    wp7v_woocommerce_sessions: Data: 0.48MB + Index: 0.02MB + Engine InnoDB
    wp7v_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp7v_woocommerce_order_items: Data: 1.52MB + Index: 0.31MB + Engine InnoDB
    wp7v_woocommerce_order_itemmeta: Data: 8.52MB + Index: 9.03MB + Engine InnoDB
    wp7v_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp7v_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp7v_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp7v_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_actionscheduler_actions: Data: 0.36MB + Index: 0.47MB + Engine InnoDB
    wp7v_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_actionscheduler_logs: Data: 0.30MB + Index: 0.20MB + Engine InnoDB
    wp7v_bwfan_abandonedcarts: Data: 0.20MB + Index: 0.09MB + Engine InnoDB
    wp7v_bwfan_automationmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_bwfan_automations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_bwfan_contact_automations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_bwfan_logmeta: Data: 0.48MB + Index: 0.11MB + Engine InnoDB
    wp7v_bwfan_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp7v_bwfan_message_unsubscribe: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp7v_bwfan_syncrecords: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp7v_bwfan_taskmeta: Data: 0.23MB + Index: 0.03MB + Engine InnoDB
    wp7v_bwfan_tasks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp7v_bwfan_task_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_bwf_actions: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp7v_bwf_action_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_bwf_contact: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
    wp7v_bwf_contact_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp7v_bwf_wc_customers: Data: 0.25MB + Index: 0.13MB + Engine InnoDB
    wp7v_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_comments: Data: 3.52MB + Index: 3.56MB + Engine InnoDB
    wp7v_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_options: Data: 1.52MB + Index: 0.06MB + Engine InnoDB
    wp7v_postmeta: Data: 33.56MB + Index: 35.13MB + Engine InnoDB
    wp7v_posts: Data: 2.52MB + Index: 1.22MB + Engine InnoDB
    wp7v_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_usermeta: Data: 3.52MB + Index: 4.03MB + Engine InnoDB
    wp7v_users: Data: 0.19MB + Index: 0.23MB + Engine InnoDB
    wp7v_vi_woo_orders_tracking_track_info: Data: 0.42MB + Index: 0.00MB + Engine InnoDB
    wp7v_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp7v_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp7v_wc_customer_lookup: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
    wp7v_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_wc_order_product_lookup: Data: 1.52MB + Index: 0.77MB + Engine InnoDB
    wp7v_wc_order_stats: Data: 1.52MB + Index: 0.61MB + Engine InnoDB
    wp7v_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp7v_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp7v_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_wfacp_stats: Data: 0.22MB + Index: 0.38MB + Engine InnoDB
    wp7v_wfco_connectormeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_wfco_connectors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_wfco_report_views: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp7v_wfocu_event: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
    wp7v_wfocu_event_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wp7v_wfocu_session: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp7v_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp7v_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp7v_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp7v_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp7v_yoast_indexable: Data: 1.52MB + Index: 0.95MB + Engine InnoDB
    wp7v_yoast_indexable_hierarchy: Data: 0.14MB + Index: 0.23MB + Engine InnoDB
    wp7v_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp7v_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp7v_yoast_prominent_words: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
    wp7v_yoast_seo_links: Data: 0.17MB + Index: 0.14MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 382
    blocks: 14
    custom_css: 1
    featured_item: 8
    nav_menu_item: 11
    oembed_cache: 3
    page: 86
    post: 9
    product: 7
    product_variation: 4
    shop_coupon: 24
    shop_order: 6188
    shop_order_refund: 96
    wfacp_checkout: 1
    wfocu_funnel: 2
    wfocu_offer: 2
    wpcf7_contact_form: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (13) ###
    
    Contact Form 7: by Takayuki Miyoshi – 5.4.1
    Judge.me Product Reviews for WooCommerce: by Judge.me – 1.3.11
    MemcacheD Is Your Friend: by Jeffrey Schutzman - - uses code from Ryan Boren
    Denis de Bernardy
    Matt Martz
    Mike Schroder
    Scott Taylor – 2.0.0
    
    PixelYourSite PRO: by PixelYourSite – 8.3.8
    TrackingMore - WooCommerce Tracking: by TrackingMore – 1.0.7
    WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.2
    WooCommerce: by Automattic – 5.4.1
    AeroCheckout: Custom WooCommerce Checkout Pages: by WooFunnels – 2.8.0
    Yoast SEO Premium: by Team Yoast – 16.6
    Yoast SEO: by Team Yoast – 16.6
    WP Mail SMTP: by WPForms – 2.9.0
    WP Rocket: by WP Media – 3.9.0.4
    WPJAM BASIC: by Denis – 5.7.9
    
    ### Inactive Plugins (1) ###
    
    WooCommerce PayPal Payments: by WooCommerce – 1.3.2
    
    ### Dropin Plugins (2) ###
    
    advanced-cache.php: advanced-cache.php
    object-cache.php: object-cache.php
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: ?
    
    ### WC Pages ###
    
    Shop base: #56 - /shop/
    Cart: #55 - /cart/
    Checkout: #54 - /checkout/
    My account: #53 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Flatsome Child
    Version: 3.0
    Author URL: 
    Child Theme: ?
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.13.3
    Parent Theme Author URL: https://www.uxthemes.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/terms.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product-cat.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome-child/woocommerce/emails/customer-completed-order.php
    flatsome-child/woocommerce/emails/customer-processing-order.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php version - is out of date. The core version is 3.0.0
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    flatsome/woocommerce/content-product_cat.php
    
    Outdated Templates: ?
    					
    					
    						Learn how to update
    
    ### Action Scheduler ###
    
    Complete: 1,226
    Oldest: 2021-06-25 05:44:52 +0000
    Newest: 2021-06-30 07:36:55 +0000
    
    Pending: 1
    Oldest: 2021-06-30 07:57:56 +0000
    Newest: 2021-06-30 07:57:56 +0000
    
    ### Status report information ###
    
    Generated at: 2021-06-30 15:57:28 +08:00
    
    Thread Starter lsjl1

    (@lsjl1)

    Plugin Support Niall a11n

    (@wpniall)

    Hi @lsjl1,

    Thanks for sharing the System Status Report and screenshot of the Orders page.

    I had a closer look at your site’s checkout page, and noticed there are a few errors on the page:

    WP.org PP Checkout Too many orders with pending payment status - silverholder.com checkout
    Link to image: https://d.pr/i/xDW8U3

    These errors suggest there is a plugin or theme conflict on this site, which might explain why there are payment errors on this site but not your other sites.
    ??
    The best way to determine if there is a conflict is to:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem

    If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

    Please let us know how that goes or if you still have problems with pending payments.

    Thread Starter lsjl1

    (@lsjl1)

    The error has been restored. I need 1 week to confirm that there will be no orders with pending payment status.

    Plugin Support Sol J. a11n

    (@solstudioim)

    That sounds a great plan @lsjl1

    Oh I forgot to mention that as Cara previously mentioned as well, could you please open one of those pending orders, and take the screenshot?

    Here is an example of the screenshot we’re looking for:


    Link to image: https://d.pr/i/HNbk3q

    Look forward to your reply.

    Thread Starter lsjl1

    (@lsjl1)

    There are still many pending payment orders
    This is screenshot→ https://snipboard.io/ILkeTY.jpg

    Plugin Support Niall a11n

    (@wpniall)

    Hi @lsjl1,

    Thanks for the screenshot. The empty Order notes section suggests to me that there was a PHP-related error when the customer checkout out the product, which might explain why the transaction went through to PayPal but did not register in WooCommerce.

    Can you please confirm if you managed to run the conflict test?

    Also, do you see any fatal-errors log from July 6th, 2021 (2021-07-06) by selecting it from the dropdown menu at WooCommerce > Status > Logs, which is the same date as Order #8696?

    Thread Starter lsjl1

    (@lsjl1)

    This is a screenshot→https://snipboard.io/nRmt3b.jpg

    2021-07-08T00:01:20+00:00 WARNING Failed to capture order. PayPal API response: [UNPROCESSABLE_ENTITY] The requested action could not be performed, semantically incorrect, or failed business validation. https://developer.paypal.com/docs/api/orders/v2/#error-INSTRUMENT_DECLINED

    Plugin Support Saravanan S, a11n

    (@simplysaru)

    Hi @lsjl1,

    Thanks for the screenshot and log detail. The error seems to be either due to an invalid card being used or due to a failure to validate your business entity.

    Could you log in to Paypal using your business account and check if there are pending errors or actions that you need to complete?

    Thread Starter lsjl1

    (@lsjl1)

    I can log in to business account paypal.

    How do I check for errors?
    Are there any guidelines or tips?

    Thread Starter lsjl1

    (@lsjl1)

    I have 5 woocommerce stores, using the same PayPal account.Only this store has a lot of orders with a pending payment status. All others are normal

    Hi @lsjl1. OK, at this point, I think it would be good if you contacted our support team directly. Can you do that by going to https://woocommerce.com/my-account/create-a-ticket/? That will allow us to get more information that wouldn’t be appropriate for a public forum, such as login credentials for the site that isn’t working. Thanks! I’ll mark this thread as resolved since we’ll continue this conversation via email instead.

    Thread Starter lsjl1

    (@lsjl1)

    After reinstalling wordpress, the problem has been solved.

    Can this topic be removed for privacy reasons?

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘Too many orders with pending payment status’ is closed to new replies.