• Resolved John Anderson

    (@andersjp)


    Hi

    I am using Woocommerce for the first time and hitting an issue.

    I have setup the sandbox in paypal, but all my orders appear as “on hold” within WooCommerce.

    The order note shows “Payment pending (paymentreview). Order status changed from Pending payment to On hold.”

    Is there an step I have missed out in the setup?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support fevered – a11n

    (@fevered)

    Hey there!

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status.
    Select “Get system report” and then “Copy for support”.  Once you’ve done that, paste it here in your response.

    Thread Starter John Anderson

    (@andersjp)

    
    ### WordPress Environment ###
    
    WordPress address (URL): http://79.170.44.111/jjsonlineescaperoom.com
    Site address (URL): http://79.170.44.111/jjsonlineescaperoom.com
    WC Version: 4.2.0
    REST API Version: ✔ 1.0.8
    WC Blocks Version: ✔ 2.5.16
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 1.2.3
    Log Directory Writable: ✔
    WP Version: 5.4.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: –
    Language: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.41 (Unix)
    PHP Version: 7.2.28
    PHP Post Max Size: 64 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.19.7
    NSS/3.44
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.1.27-MariaDB
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 4.2.0
    WC Database Prefix: wp_
    Total Database Size: 5.43MB
    Database Data Size: 3.83MB
    Database Index Size: 1.60MB
    wp_woocommerce_sessions: Data: 0.02MB + 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: 0.02MB + Index: 0.03MB + 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: 0.02MB + Index: 0.11MB + 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: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_groups_capability: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_groups_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_groups_group_capability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_groups_user_capability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_groups_user_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 2.44MB + Index: 0.03MB + Engine InnoDB
    wp_postmeta: Data: 0.14MB + Index: 0.11MB + Engine InnoDB
    wp_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + 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_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + 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.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + 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
    
    ### Post Type Counts ###
    
    attachment: 32
    booked_appointments: 38
    customize_changeset: 15
    nav_menu_item: 9
    page: 13
    post: 5
    product: 4
    revision: 15
    room: 6
    shop_order: 17
    wpcf7_contact_form: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ❌
    					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ✔
    
    ### Active Plugins (13) ###
    
    Redux Framework: by Team Redux – 3.6.18
    CMB2: by CMB2 team – 2.7.0
    Contact Form 7: by Takayuki Miyoshi – 5.1.9
    HandMade WooCommerce Order Status Control: by HandMade Connections – 1.3 – Installed version not tested with active version of WooCommerce 4.2.0
    WPBakery Page Builder: by Michael M - WPBakery.com – 5.6
    Restrict: by Restrict – 2.0.4 – Installed version not tested with active version of WooCommerce 4.2.0
    Slider Revolution: by ThemePunch – 5.4.8.2
    ThemeCube Core: by themecube – 2.0
    WooCommerce: by Automattic – 4.2.0
    WordPress Importer: by wordpressdotorg – 0.7
    WP-Cron Control: by Thorsten Ott
    Erick Hitter
    Automattic – 0.7.1
    
    WP Crontrol: by John Blackbourn & contributors – 1.8.5
    Smush: by WPMU DEV – 3.6.3
    
    ### Inactive Plugins (9) ###
    
    Akismet Anti-Spam: by Automattic – 4.1.6
    Booked: by Boxy Studio – 2.2.6
    Booked Add-On: Calendar Feeds: by Boxy Studio – 1.1.6
    Booked Add-On: Front-End Agents: by Boxy Studio – 1.1.16
    Booked Add-On: WooCommerce Payments: by Boxy Studio – 1.5.3 – Installed version not tested with active version of WooCommerce 4.2.0
    Booster for WooCommerce: by Pluggabl LLC – 5.0.0 – Installed version not tested with active version of WooCommerce 4.2.0
    Groups: by itthinx – 2.10.0
    Hello Dolly: by Matt Mullenweg – 1.7.2
    Jetpack by WordPress.com: by Automattic – 8.6.1
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: GBP (£)
    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: #490 - /shop/
    Basket: #491 - /cart/
    Checkout: #492 - /checkout/
    My account: #493 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Escape
    Version: 2.0
    Author URL: https://themeforest.net/user/themecube
    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: ✔
    
    ### Templates ###
    
    Overrides: escape/woocommerce/archive-product.php
    escape/woocommerce/cart/cart-empty.php
    escape/woocommerce/cart/cart.php version 3.5.0 is out of date. The core version is 3.8.0
    escape/woocommerce/cart/proceed-to-checkout-button.php
    escape/woocommerce/cart/shipping-calculator.php version 3.5.0 is out of date. The core version is 4.0.0
    escape/woocommerce/checkout/form-billing.php version 3.0.9 is out of date. The core version is 3.6.0
    escape/woocommerce/checkout/form-checkout.php
    escape/woocommerce/checkout/form-coupon.php
    escape/woocommerce/checkout/payment.php
    escape/woocommerce/content-product.php version 3.4.0 is out of date. The core version is 3.6.0
    escape/woocommerce/content-single-product.php version 3.4.0 is out of date. The core version is 3.6.0
    escape/woocommerce/loop/loop-start.php
    escape/woocommerce/myaccount/form-edit-account.php
    escape/woocommerce/myaccount/form-login.php version 3.5.0 is out of date. The core version is 4.1.0
    escape/woocommerce/myaccount/form-lost-password.php
    escape/woocommerce/myaccount/my-account.php
    escape/woocommerce/myaccount/my-address.php
    escape/woocommerce/notices/success.php version 3.5.0 is out of date. The core version is 3.9.0
    escape/woocommerce/order/order-details-customer.php
    escape/woocommerce/single-product/related.php version 3.0.0 is out of date. The core version is 3.9.0
    escape/woocommerce/single-product-reviews.php version 3.5.0 is out of date. The core version is 3.6.0
    
    Outdated Templates: ❌
    					
    					
    						Learn how to update
    
    ### Action Scheduler ###
    
    Pending: 25
    Oldest: 2020-06-07 15:41:13 +0100
    Newest: 2020-06-09 14:17:47 +0100
    
    

    Hi @andersjp

    Thanks so much for sending over that site status report! Based on those order notes, it sounds like you may have PayPal set up in Authorize mode. This mode allows you to get payment authorization for a charge, and then capture the charge later by changing the order status from On Hold to Processing

    Could you please go to WooCommerce > Settings, click on the Payments tab, and then open up your settings for PayPal. Then check to see if you have the Payment Action setting set to Authorize or Capture.

    If you have it set to Authorize, go ahead and change that to Capture and save, then test again.

    Let us know how that goes!

    Thread Starter John Anderson

    (@andersjp)

    Thanks, I tried changing the setting to capture and the same happens.

    Plugin Support Aashik P – a11n

    (@aashik)

    Hi there!

    I tried changing the setting to capture and the same happens.

    That’s interesting. Can you please share screenshots of:

    1. Order details page: WP Admin > WooCommerce > Orders > Edit the order on-hold > Send a screenshot of this page
    2. PayPal Settings displaying the payment action settings: WP Admin > WooCommerce > Settings > Payments > PayPal

    Please make sure that any personal information including emails, names etc are redacted.

    If you don’t already have a screenshot service installed, you can try https://snipboard.io or http://skitch.com/.

    Thread Starter John Anderson

    (@andersjp)

    Thanks:

    The screenshots they shared last has multiple personal details that are not redacted. Links removed.

    • This reply was modified 5 years, 11 months ago by Yui. Reason: link removed
    Plugin Support Aashik P – a11n

    (@aashik)

    Hello @andersjp

    There are multiple personal details that are not redacted in the screenshots. Please delete the screenshots.

    I see that you’re currently using sandbox mode for PayPal, and the order notes state the following:

    order note
    Link to image: https://d.pr/i/yd3TPr

    This is happening because you’ve enabled payment reviews for your test account.

    Please follow the steps below to prevent this from happening:

    1. Access https://developer.paypal.com/developer/accounts/
    2. Hover over the three dots next to the sandbox account linked to your site, and then click on view/edit account:

    edit account
    Link to image: https://d.pr/i/uUoHAE

    3. Click on Settings and then turn off payment reviews:

    payment review
    Link to image: https://d.pr/i/tjz3uz

    4. Make a new test order to confirm that everything is working as per your expectations.

    Thread Starter John Anderson

    (@andersjp)

    Thanks very much for your help, it is now working as expected.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Orders showing as on hold’ is closed to new replies.