• Resolved iAndrew

    (@iandrew)


    Any help or guidance is greatly appreciated.

    Issue:

    Customers are making product purchases using the configured Standard PayPal payment gateway. After successfully going through the PayPal check out process the client sees the order received summary page. The customer gets a payment confirmation from PayPal but nothing from WooCommerce.

    When I follow those steps, the shop owner nor the customer get a confirmation email from WooCommerce.

    But I see the order being created with the purchase and customer details and an IPN pending payment notification within the WooCommerce order page. If an order is done using other payment methods everybody gets notification emails without fail.

    I have installed an Email logging plug-in to see if anything is triggered when a PayPal transaction happens but nothing shows up. I also activated the PayPal debugging feature and it shows all details of the purchase reported back to WooCommerce (file provided)

    Troubleshooting steps performed to see if I could resolve the issue:

    – Deactivated every plugin (except WooCommerce)
    – Switched child theme to 2018 theme
    – Tried being logged in as a user
    – Tried purchasing a product as a non-logged in user
    – Confirmed I am not in sandbox mode for PayPal
    – Confirmed the Enable this email notification is ticked on for new orders
    – Added a new product to see if a new product would work
    – Confirmed PayPal Standard is enabled
    – Performed IPN troubleshooting steps from WooCommerce website (except PDT)

    Note:

    – When adding the query string to the end of domain name: ?wc-api=WC_Gateway_PayPal. I see PayPal IPN Request Failure
    – Here’s the WC log for a test purchase

    
    ### WordPress Environment ###
    
    Home URL: https://natureofmassage.mtwpsandbox.com
    Site URL: https://natureofmassage.mtwpsandbox.com
    WC Version: 3.4.5
    Log Directory Writable: ?
    WP Version: 4.9.8
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.2.9
    PHP Post Max Size: 128 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 1000
    cURL Version: 7.59.0
    OpenSSL/1.0.2k
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.40-84.0-log
    Max Upload Size: 128 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 3.4.5
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ?
    Total Database Size: 7.67MB
    Database Data Size: 5.85MB
    Database Index Size: 1.82MB
    wp_woocommerce_sessions: Data: 0.11MB + Index: 0.02MB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_order_itemmeta: Data: 0.08MB + Index: 0.09MB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
    wpf5_commentmeta: Data: 0.02MB + Index: 0.03MB
    wpf5_comments: Data: 0.02MB + Index: 0.08MB
    wpf5_links: Data: 0.02MB + Index: 0.02MB
    wpf5_options: Data: 1.09MB + Index: 0.02MB
    wpf5_postmeta: Data: 0.02MB + Index: 0.03MB
    wpf5_posts: Data: 0.02MB + Index: 0.06MB
    wpf5_termmeta: Data: 0.02MB + Index: 0.03MB
    wpf5_terms: Data: 0.02MB + Index: 0.03MB
    wpf5_term_relationships: Data: 0.02MB + Index: 0.02MB
    wpf5_term_taxonomy: Data: 0.02MB + Index: 0.03MB
    wpf5_usermeta: Data: 0.02MB + Index: 0.03MB
    wpf5_users: Data: 0.02MB + Index: 0.05MB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB
    wp_comments: Data: 0.06MB + Index: 0.09MB
    wp_links: Data: 0.02MB + Index: 0.02MB
    wp_options: Data: 0.30MB + Index: 0.06MB
    wp_postmeta: Data: 1.52MB + Index: 0.47MB
    wp_posts: Data: 0.47MB + Index: 0.06MB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB
    wp_terms: Data: 0.02MB + Index: 0.03MB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB
    wp_usermeta: Data: 0.06MB + Index: 0.03MB
    wp_users: Data: 0.02MB + Index: 0.05MB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
    wp_wpml_mails: Data: 1.52MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    attachment: 137
    ctct_forms: 1
    ctct_lists: 4
    custom_css: 1
    nav_menu_item: 20
    page: 25
    post: 4
    product: 11
    product_variation: 21
    revision: 104
    shop_order: 54
    slideshow: 6
    testimonial: 1
    wpcf7_contact_form: 1
    wpzoom: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (14) ###
    
    ManageWP - Worker: by ManageWP – 4.6.2
    Anti-spam: by webvitaly – 5.2
    Constant Contact Forms for WordPress: by Constant Contact – 1.3.7
    Contact Form 7: by Takayuki Miyoshi – 5.0.4
    Page Links To: by Mark Jaquith – 3.0.1
    Shortcodes Ultimate: by Vladimir Anokhin – 5.0.4
    Social Icons Widget by WPZOOM: by WPZOOM – 3.0.10
    SVG Support: by Benbodhi – 2.3.15
    Upgrade for Unattach & Re-Attach Media Attachments: by Laurence Bahiirwa – 1.1.0
    Woo Checkout Field Editor Pro: by ThemeHiGH – 1.2.8
    WooCommerce: by Automattic – 3.4.5
    WP Mail Logging: by Christian Z?ller – 1.8.4
    WP Rocket: by WP Media – 3.1.3.2
    Pretty Callouts Plugin: by Andrew Lopez – 1.0
    
    ### 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)
    
    ### WC Pages ###
    
    Shop base: #7 - /shop/
    Cart: #8 - /cart/
    Checkout: #9 - /checkout/
    My account: #10 - /my-account/
    Terms and conditions: #198 - /terms-conditions/
    
    ### Theme ###
    
    Name: Nature of Massage
    Version: 1.6.7
    Author URL: https://www.wpbyhand.com
    Child Theme: ?
    Parent Theme Name: Modena
    Parent Theme Version: 1.1.5
    Parent Theme Author URL: https://www.wpzoom.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: modena/woocommerce/archive-product.php
    modena/woocommerce/single-product.php
    

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    Thanks for listing out everything you’ve done so clearly!

    Can you please try the step related to switching to PDT to see if that works?

    If it doesn’t, then the next step is to check PayPal for IPN logs. Here’s how to do that:

    1. Go to the PayPal activity page and navigate to “payments received”
    2. Find the payment for order id (order id)
    3. Click on that transaction and on the resulting page, copy the transaction id: https://cld.wthms.co/1opVgw+
    4. Once you have that, click the “profile” icon then “Profile and Settings”:
    https://cld.wthms.co/kYE0l7
    https://cld.wthms.co/383fDi
    5. Click “My Selling Tools” then, the “update” link for the Instant payment notifications settings:
    https://cld.wthms.co/5WwIuZ
    6. Get a screenshot of what you see there, e.g.:
    https://cld.wthms.co/YMijQh
    7. Next, click on the link for the IPN History Page:
    https://cld.wthms.co/XIr6lx
    8. Select “last 28 days”, Paste the transaction id from step 3 into the transaction id field, then click search:
    https://cld.wthms.co/cM57AP
    9. Get a screenshot of the result, e.g.:
    https://cld.wthms.co/wkEsS3
    10. There may be more than one result. For each of the results, click the message id link:
    https://cld.wthms.co/XEb8vd
    11. Get a screenshot of that result, e.g.:
    https://cld.wthms.co/z7sn2j
    12. Also, copy/paste everything in the IPN Message text area into a response to this message
    13. Send us all of the screenshots that you have captured. You can upload to Dropbox or similar (but NOT Tinypic) and share the download link with us.

    If you prefer, send us a ticket via WooCommerce.com > Support, referencing this post and we’ll be happy to help you look into this.

    Thread Starter iAndrew

    (@iandrew)

    Hi Hannah!

    Thank you for the reply! I’ll be attempting the PDT step to see if that helps. If PDT doesn’t work, I will review the IPN logs.

    Thank you so much!

    Thread Starter iAndrew

    (@iandrew)

    Thank you Hannah for replying so promptly.

    Here’s an update:

    I went back to the sandbox and added the Payment Data Transfer (PDT) and voila it worked! However, I disabled the PDT and the new customer order email came through immediately and payment went to processing instead of pending payment.

    Then I went back to the production website and tested the check out process and now that works as expected, same as the sandbox.

    I wish there is something I can provide here to other potential individuals who face this problem, but I didn’t change a thing on my end. I may chalk this up to the PayPal account experiencing an issue.

    Sorry I couldn’t be of more help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘PayPal Standard’ is closed to new replies.