Too many orders with pending payment status
-
I have several woocommerce stores.
Only this store has a lot of orders with pending payment status.
Please help me check the causeThe page I need help with: [log in to see the link]
-
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
No receiving the funds in PayPal
### 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
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:
Link to image: https://d.pr/i/xDW8U3These 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.
The error has been restored. I need 1 week to confirm that there will be no orders with pending payment status.
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/HNbk3qLook forward to your reply.
There are still many pending payment orders
This is screenshot→ https://snipboard.io/ILkeTY.jpgHi @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?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
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?
I can log in to business account paypal.
How do I check for errors?
Are there any guidelines or tips?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.
After reinstalling wordpress, the problem has been solved.
Can this topic be removed for privacy reasons?
- The topic ‘Too many orders with pending payment status’ is closed to new replies.