search

woocommerce / woocommerce-paypal-payments

https://wordpress.org/plugins/woocommerce-paypal-payments/
GNU General Public License v2.0
63 stars 48 forks source link

Subscription Payments Stuck On Pending #1357

Closed CWConnection closed 1 year ago

CWConnection commented 1 year ago

Describe the Bug

Several of our April monthly subscriptions are remaining "On Hold". They are pending and should have processed on the renewal dates. These are automatic monthly subscriptions that seem to be stuck in pending but should of renewed in April. We are concerned we will not receive these payments . ### To Reproduce
  1. Go to '…'
  2. Click on '…'
  3. Scroll down to …'
  4. See error

Screenshots

On Hold Subscriptions April Pending April_Pending ### Expected Behavior We expect for these automatic subscriptions to go through to paypal on the monthly renewal date ### Actual Behavior They are remaining "On Hold" "Pending" ### Environment

Additional Details

I didn’t build our site, however I have stepped in to maintain the site. I do not know all the ways everything was set up so I must admit I'm a tad but confused with some of the backend. However we use ShowIt and I did a system check on our website. It currently says that Woocommerce support is not declared and that the Woocommerce account is not connected, However no errors show under the WooCommerce PayPal Payments report section. We have a functioning online store so I'm not sure if this error message in the report has anything to do with our current issue of subscriptions pending.
System status ``` ` ### WordPress Environment ### WordPress address (URL): https://christianwomenconnection.org Site address (URL): https://christianwomenconnection.org WC Version: 7.6.1 REST API Version: ✔ 7.6.1 WC Blocks Version: ✔ 9.8.5 Action Scheduler Version: ✔ 3.5.4 Log Directory Writable: ✔ WP Version: 6.2 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: ✔ ### Server Environment ### Server Info: Apache PHP Version: 8.0.28 PHP Post Max Size: 100 MB PHP Time Limit: 3600 PHP Max Input Vars: 10000 cURL Version: 7.74.0 OpenSSL/1.1.1n SUHOSIN Installed: – MySQL Version: 5.7.41-44-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: 7.6.1 WC Database Prefix: wp_ Total Database Size: 95.34MB Database Data Size: 79.14MB Database Index Size: 16.20MB wp_woocommerce_sessions: Data: 0.17MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.38MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 1.02MB + Index: 0.14MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 1.02MB + Index: 0.09MB + Engine InnoDB wp_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_connection_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_no_cookie_data: Data: 0.16MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_sfw: Data: 1.52MB + Index: 1.52MB + Engine InnoDB wp_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.14MB + Index: 0.09MB + Engine InnoDB wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gf_entry: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wp_gf_entry_meta: Data: 0.36MB + Index: 0.53MB + Engine InnoDB wp_gf_entry_notes: Data: 0.13MB + Index: 0.03MB + Engine InnoDB wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_gf_form_meta: Data: 0.17MB + Index: 0.00MB + Engine InnoDB wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 2.09MB + Index: 0.06MB + Engine InnoDB wp_postmeta: Data: 2.52MB + Index: 2.97MB + Engine InnoDB wp_posts: Data: 1.52MB + Index: 0.50MB + Engine InnoDB wp_redirection_404: Data: 1.02MB + Index: 0.05MB + Engine InnoDB wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_sib_model_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_sib_model_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_um_followers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_um_groups_members: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_um_metadata: Data: 1.52MB + Index: 3.41MB + Engine InnoDB wp_usermeta: Data: 4.50MB + Index: 4.02MB + Engine InnoDB wp_users: Data: 0.31MB + Index: 0.30MB + Engine InnoDB wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wp_wc_order_stats: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfconfig: Data: 4.02MB + Index: 0.00MB + Engine InnoDB wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wffilemods: Data: 9.52MB + Index: 0.00MB + Engine InnoDB wp_wfhits: Data: 1.02MB + Index: 0.09MB + Engine InnoDB wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfknownfilelist: Data: 4.52MB + Index: 0.00MB + Engine InnoDB wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wflogins: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfls_role_counts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfstatus: Data: 0.11MB + Index: 0.09MB + Engine InnoDB wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfwafconfig: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wml_entries: Data: 16.52MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_debug_events: Data: 21.55MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_action_history: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yoast_indexable: Data: 0.08MB + Index: 0.09MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.05MB + Index: 0.03MB + Engine InnoDB ### Post Type Counts ### acf-field: 4 acf-field-group: 1 attachment: 141 custom_css: 1 nav_menu_item: 32 page: 39 post: 19 product: 26 product_variation: 67 shop_order: 357 shop_order_refund: 31 shop_subscription: 34 tec_tc_ticket: 2 um_activity: 2257 um_directory: 2 um_form: 3 wp_global_styles: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (30) ### Gravity Forms: by Gravity Forms – 2.7.5 Advanced Custom Fields PRO: by WP Engine – 6.1.6 WP Sheet Editor - Custom Tables: by WP Sheet Editor – 1.2.6 Anti-Spam by CleanTalk: by СleanTalk – 6.9.2 Flexible Checkout Fields: by WP Desk – 3.5.7 Flexible Shipping: by Octolize – 4.21.1 Gravity Forms Coupons Add-On: by Gravity Forms – 3.1 Gravity Forms Mailchimp Add-On: by Gravity Forms – 5.2.0 Gravity Forms Partial Entries Add-On: by Gravity Forms – 1.7 Gravity Forms PayPal Checkout Add-On: by Gravity Forms – 2.5 Mailchimp for WooCommerce: by Mailchimp – 2.8.3 MG Redirect After Registration: by Megan Garwood – 0.1.4 Redirection: by John Godley – 5.3.10 Showit Customizations: by K Design Co – 1.0.0 Showit Core: by Showit – 3.7.3 Ultimate Member: by Ultimate Member – 2.6.0 Ultimate Member - Followers: by Ultimate Member – 2.2.6 Ultimate Member - Groups: by Ultimate Member – 2.3.0 Ultimate Member - Social Activity: by Ultimate Member – 2.2.7 Ultimate Member - User Locations: by Ultimate Member – 1.0.6 Ultimate Member - WooCommerce: by Ultimate Member – 2.3.1 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.23.3 Import Export WordPress Users and WooCommerce Customers: by WebToffee – 2.3.9 WooCommerce PayPal Payments: by WooCommerce – 2.0.4 WooCommerce Subscriptions: by WooCommerce – 4.5.1 WooCommerce: by Automattic – 7.6.1 Wordfence Security: by Wordfence – 7.9.2 Yoast SEO: by Team Yoast – 20.6 WP Mail Log: by WPVibes – 1.1 WP Mail SMTP: by WP Mail SMTP – 3.8.0 ### Inactive Plugins (4) ### Newsletter, SMTP, Email marketing and Subscribe forms by Sendinblue: by Sendinblue – 3.1.60 Ultimate Member - MailChimp: by Ultimate Member – 2.4.0 Ultimate Member - Profile Completeness: by Ultimate Member – 2.2.3 WooCommerce Shipping & Tax: by WooCommerce – 2.2.4 ### Dropin Plugins (2) ### advanced-cache.php: advanced-cache.php object-cache.php: Memcached Redux ### Must Use Plugins (5) ### Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0 WP Engine Cache Plugin: by WP Engine – 1.1.2 WP Engine Seamless Login Plugin: by WP Engine – 1.6.0 WP Engine Security Auditor: by wpengine – 1.0.10 WP Engine System: by WP Engine – 5.0.1 ### 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) subscription (subscription) variable (variable) variable subscription (variable-subscription) 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: – Enforce Approved Product Download Directories: ✔ Order datastore: WC_Order_Data_Store_CPT ### WC Pages ### Shop base: #31 - /store/ Cart: #25 - /cart/ Checkout: #26 - /checkout/ My account: #27 - /my-account/ Terms and conditions: #193 - /terms-of-service/ ### Theme ### Name: Showit Version: 1.0 Author URL: https://showit.co/ Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ❌ Not declared ### Templates ### Overrides: – ### Subscriptions ### WCS_DEBUG: ✔ No Subscriptions Mode: ✔ Live Subscriptions Live URL: https://christianwomenconnection.org Subscription Statuses: trash: 1 wc-active: 5 wc-on-hold: 19 wc-cancelled: 9 WooCommerce Account Connected: ❌ No Report Cache Enabled: ✔ Yes Cache Update Failures: ✔ 0 failure ### Store Setup ### Country / State: United States (US) — Indiana ### Subscriptions by Payment Gateway ### Advanced Card Processing: trash: 1 wc-active: 5 wc-cancelled: 6 wc-on-hold: 19 PayPal: wc-cancelled: 3 ### Payment Gateway Support ### PayPal: refunds products subscriptions subscription_cancellation subscription_suspension subscription_reactivation subscription_amount_changes subscription_date_changes subscription_payment_method_change subscription_payment_method_change_customer subscription_payment_method_change_admin multiple_subscriptions Advanced Card Processing: refunds products subscriptions subscription_cancellation subscription_suspension subscription_reactivation subscription_amount_changes subscription_date_changes subscription_payment_method_change subscription_payment_method_change_customer subscription_payment_method_change_admin multiple_subscriptions ### WooCommerce PayPal Payments ### Onboarded: ✔ Shop country code: US WooCommerce currency supported: ✔ Advanced Card Processing available in country: ✔ Pay Later messaging available in country: ✔ Webhook status: ✔ Vault enabled: ✔ Logging enabled: ✔ Reference Transactions: – Used PayPal Checkout plugin: – Tracking enabled: ✔ ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: block-editor-feature-enabled minified-js new-product-management-experience product-variation-management settings Daily Cron: ✔ Next scheduled: 2023-05-08 16:59:42 -04:00 Options: ✔ Notes: 89 Onboarding: completed ### Action Scheduler ### Canceled: 1 Oldest: 2023-04-11 18:37:11 -0400 Newest: 2023-04-11 18:37:11 -0400 Complete: 334 Oldest: 2023-04-08 01:00:56 -0400 Newest: 2023-05-08 02:17:06 -0400 Failed: 2 Oldest: 2023-04-13 16:03:58 -0400 Newest: 2023-04-26 12:44:18 -0400 Pending: 6 Oldest: 2023-05-08 07:43:19 -0400 Newest: 2023-06-03 22:36:28 -0400 ### Status report information ### Generated at: 2023-05-08 02:34:03 -04:00 ` ```
InpsydeNiklas commented 1 year ago

@CWConnection The renewals remaining in "Pending payment" is expected in this case as the connected merchant account is not enabled for Reference Transactions.

The Vaulting feature in the PayPal Payments extension requires that your PayPal account has Reference Transactions enabled. You can find more information on this in the documentation available at https://woocommerce.com/document/woocommerce-paypal-payments/#subscriptions-faq

For any questions, I suggest contacting the support team from here: https://woocommerce.com/document/woocommerce-paypal-payments/#get-help Thanks!