PayPal account not Synced with WooCommerce

  • Resolved jfteamvision123199

    (@jfteamvision123199)


    3 years ago

    My team’s client built this website herself, so we are not familiar with how all the plugins were set up. But we recently helped the client change the name of their URL, we hide their shop pages because she wants to only receive donations via the Paypal donation button that we embedded to the home page, and the woocommerce plugin has been updated to the most recent version. We also renew the PayPal API keys and plugged them back into the Payments tab, but we still can’t see the transactions on the “Orders” tab.

    What we see on the “orders” page is “When you receive a new order, it will appear here.” with a “Learn more about orders” button and a “tools for your store” table. When I click on the “Learn more about orders” button, it directs me to download Woocommerce, but we already are using woocommerce? I need help, I don’t normally do this type of troubleshooting.

    There is an Action Required: Deactivate PayPal Checkout message, but I’m not sure if this will help.

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

Viewing 12 replies - 1 through 12 (of 12 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @jfteamvision123199,

    When you mention the “Orders” tab do you mean the Orders section under WordPress dashboard > WooCommerce > Orders?

    If so, orders will appear on that page when you’ve set up a store with the cart and checkout pages. You can read more on configuring settings and setting up a store here: https://woocommerce.com/document/configuring-woocommerce-settings/.

    Could you please share a copy of your site’s System Status so we can have a look at your setup?

    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.

    Thanks!

    Thread Starter jfteamvision123199

    (@jfteamvision123199)

    Hi @rainfallnixfig
    Thank you for your reply.

    Yes, we don’t see the order history when we go to WordPress dashboard > WooCommerce > Orders. We did up until a couple of weeks ago. Are you saying that I need to rebuild their shop pages and we’ll see the orders, again? We do have the cart and check out page set up from when we had an active shop, but links to these pages were taken off the site, because we only want to have people click on the PayPal embeded donation button and donate. We are not selling anything.

    Here’s the system status:

    
### WordPress Environment ###

WordPress address (URL): https://savinghawaiisforests.org
Site address (URL): https://savinghawaiisforests.org
WC Version: 5.8.0
REST API Version: ? 5.8.0
WC Blocks Version: ? 5.9.1
Action Scheduler Version: ? 3.3.0
WC Admin Version: ? 2.7.2
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.2.34
PHP Post Max Size: 100 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 7.79.1
OpenSSL/1.1.1l

SUHOSIN Installed: –
MySQL Version: 5.7.26-29-log
Max Upload Size: 100 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.6.0
WC Database Prefix: wp_8vvnzztwcm_
Total Database Size: 39.09MB
Database Data Size: 35.96MB
Database Index Size: 3.13MB
wp_8vvnzztwcm_woocommerce_sessions: Data: 13.07MB + Index: 0.70MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_downloadable_product_permissions: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_order_items: Data: 0.06MB + Index: 0.03MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_order_itemmeta: Data: 0.34MB + Index: 0.23MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_actionscheduler_actions: Data: 0.05MB + Index: 0.13MB + Engine InnoDB
wp_8vvnzztwcm_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_8vvnzztwcm_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_8vvnzztwcm_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_8vvnzztwcm_commentmeta: Data: 1.00MB + Index: 0.11MB + Engine MyISAM
wp_8vvnzztwcm_comments: Data: 0.43MB + Index: 0.11MB + Engine MyISAM
wp_8vvnzztwcm_fm_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_field_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_nf_objectmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_nf_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_nf_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_ninja_forms_fav_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_ninja_forms_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_options: Data: 6.08MB + Index: 0.09MB + Engine InnoDB
wp_8vvnzztwcm_pms_member_subscriptions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_pms_payments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_postmeta: Data: 8.98MB + Index: 1.00MB + Engine MyISAM
wp_8vvnzztwcm_posts: Data: 4.94MB + Index: 0.15MB + Engine MyISAM
wp_8vvnzztwcm_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_revslider_css_bkp: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_slides_bkp: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_usermeta: Data: 0.22MB + Index: 0.14MB + Engine MyISAM
wp_8vvnzztwcm_users: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_8vvnzztwcm_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_8vvnzztwcm_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_8vvnzztwcm_wc_download_log: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_8vvnzztwcm_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_8vvnzztwcm_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_8vvnzztwcm_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_8vvnzztwcm_wc_product_meta_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8vvnzztwcm_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_8vvnzztwcm_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_8vvnzztwcm_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

attachment: 416
cs_template: 1
cs_user_templates: 1
custom_css: 1
envira: 3
nav_menu_item: 15
nf_sub: 12
page: 18
pms-subscription: 1
post: 6
product: 20
product_variation: 57
revision: 401
shop_order: 2
shop_order_refund: 24
soliloquy: 1
wpcf7_contact_form: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (21) ###

Akismet Anti-Spam: by Automattic – 4.1.12
Better Search Replace: by Delicious Brains – 1.3.4
WordPress Backup & Security Plugin - BlogVault: by Backup by BlogVault – 4.58
Classic Editor: by WordPress Contributors – 1.6
Code Snippets: by Code Snippets Pro – 2.14.1
Contact Form 7: by Takayuki Miyoshi – 5.4.1
Contact Widgets: by GoDaddy – 1.7.0
Cornerstone: by Themeco – 5.3.3
Envira Gallery: by Envira Gallery Team – 1.9.3
Really Simple SSL: by Really Simple Plugins – 4.0.15
Slider Revolution: by ThemePunch – 6.4.11
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.62

WooCommerce PayPal Payments Advanced Gateway: by WooCommerce – 1.24.9
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3
Braintree for WooCommerce Payment Gateway: by WooCommerce – 2.6.1
WooCommerce Menu Cart: by Jeremiah Prummer
Ewout Fernhout – 2.10.1

WooCommerce Payments: by Automattic – 3.2.3
WooCommerce PayPal Payments: by WooCommerce – 1.6.1
WooCommerce: by Automattic – 5.8.0
WP Rollback: by Impress.org – 1.7.1
WP Engine Automated Migration: by WPEngine – 4.55

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

object-cache.php: APCu Object Cache

### Must Use Plugins (1) ###

System Plugin: by  – 4.14.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: –

### WC Pages ###

Shop base: #163 - /shop/
Cart: #164 - /cart/
Checkout: #165 - /checkout/
My account: ? Page not set
Terms and conditions: ? Page not set

### Theme ###

Name: X
Version: 8.3.3
Author URL: https://theme.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: ?

### Templates ###

Overrides: x/woocommerce/single-product/tabs/tabs.php
x/woocommerce/single-product-reviews.php

### Subscriptions ###

WCS_DEBUG: ? No
Subscriptions Mode: ? Live
Subscriptions Live URL: https://savinghawaiisforests.org
Subscription Statuses: –
WooCommerce Account Connected: ? No

### Store Setup ###

Country / State: United States (US) — Hawaii

### Payment Gateway Support ###

PayPal Standard: subscriptions
gateway_scheduled_payments
subscription_payment_method_change_customer
subscription_cancellation
subscription_suspension
subscription_reactivation
products
refunds

PayPal Reference Transactions Enabled: ? No
PayPal Advanced: products
refunds

PayPal Checkout: products
refunds
subscriptions
subscription_cancellation
subscription_reactivation
subscription_suspension
multiple_subscriptions
subscription_payment_method_change_customer
subscription_payment_method_change_admin
subscription_amount_changes
subscription_date_changes

PayPal: refunds

### Braintree (PayPal) ###

Environment: Production
Tokenization Enabled: ?
Debug Mode: Save to Log

### WooCommerce PayPal Payments ###

Onboarded: Yes
Shop country code: US
PayPal card processing available in country: Yes
Pay Later messaging available in country: Yes
Vault enabled: No

### Action Scheduler ###

Complete: 73
Oldest: 2021-10-20 15:59:25 -1000
Newest: 2021-11-05 13:18:54 -1000

Failed: 1
Oldest: 2019-10-06 04:21:23 -1000
Newest: 2019-10-06 04:21:23 -1000

### Status report information ###

Generated at: 2021-11-05 13:19:07 -10:00
    Plugin Support Stuart Duff – a11n

    (@stuartduff)

    Automattic Happiness Engineer

    Hey @jfteamvision123199,

    Looking at the website of https://savinghawaiisforests.org/ I see this donate button on the homepage.

    ![screenshot](https://d.pr/i/lgfGsK+)
    **Image Link:** https://d.pr/i/lgfGsK

    When inspecting that particular button it does not seem to integrate or originate from the WooCommerce plugin hence you would not see any orders in WooCommerce related to that after using it.

    The sites system report shows the site for some reason has multiple PayPal Plugins installed, none of which seem to relate to that button on the homepage, however.

    
WooCommerce PayPal Payments Advanced Gateway: by WooCommerce – 1.24.9
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3
Braintree for WooCommerce Payment Gateway: by WooCommerce – 2.6.1
WooCommerce PayPal Payments: by WooCommerce – 1.6.1

    The first step in diagnosing this would be to check on the site to ascertain exactly what the PayPal button is displaying on the homepage and figure out where that’s originating from.

    I’d also look to see what has changed on the site in the past two weeks as your client by the looks of how many PayPal plugins are installed may have been changing lots of elements.

    Thread Starter jfteamvision123199

    (@jfteamvision123199)

    Hi @stuartduff
    But shouldn’t she still be able to see her order history? According to the client, she was able to see all the activity happening on her PayPal account from the Woocommerce order tab on the dashboard up until a few weeks ago. Shouldn’t it be synced if we entered the Paypal API credentials in the Woocommerce Payments section? The checkout, cart, and shop pages were just hidden on the site.

    Also, the PayPal donation button was rendered on PayPal, and embedded on the site, so it is not connected with Woocommerce. Does that mean that if we can sync the PayPal order transaction activity on the Woocommerce dashboard, it won’t show the donation transactions because it came from the donation button that was created on PayPal?

    But I think she was still able to see the donation transactions through that PayPal button come before it disappeared.

    Abiola Ogodo

    (@oaoyadeyi)

    @jfteamvision123199

    Even if the API is entered through the WooCommerce backend, it’s not enabled for donations but for product checkout.

    Since the button was directly embedded from Paypal, it can’t be tracked via WooCommerce.

    To start collecting donations via Paypal trackable via WooCommerce, we recommend checking out this plugin: https://woocommerce.com/products/donation-product-for-woocommerce/

    Thread Starter jfteamvision123199

    (@jfteamvision123199)

    Hi @oaoyadeyi
    Thank you for the clarification. But if the API key is plugged in, shouldn’t we still see all the order transactions from the past, before we hide the shop pages? Right now, we do not see any order history. I’m referring to when people were able to buy things from the website, not the Paypal donation button on the home page.

    Plugin Support nicw.a11n

    (@nicw)

    Hi @jfteamvision123199

    Indeed, you should not have lost any orders previously placed through the checkout page on the site, unless at some point in the last two weeks the data stored by WooCommerce was removed.

    Since the site appears to have gone through recent changes, this may have been the case?

    Possibly your client has a backup taken before these changes were made, so that you can compare what you see now with what was actually in place a few weeks ago?

    Thread Starter jfteamvision123199

    (@jfteamvision123199)

    Hi @nicw
    It could be. We did change the URL name back in June, but I’m not sure how that might relate to why we don’t see the orders anymore. We did update the Woocommerce plugin to the latest version, and it was a big update since no one on their team maintains the site. The only time the plugins get updated is when the client calls us to add pages or troubleshoot an issue (and there are like months in between each time they call us). We do have one backup from when the woocommerce was synced with PayPal, but because we changed the URL name after we made the backup, we can’t restore it for free.

    We also made new PayPal API credentials because we thought that was the issue, plugged them in, and still do not see our orders. We are at a loss. It would be great if someone had a solution for this. Is there a way to restore the woocommerce data?

    We understand if the donations might not show up in the order history, but the client really wants to have the previous orders on here.

    Mirko P.

    (@rainfallnixfig)

    Hi @jfteamvision123199,

    Thanks for getting back to us.

    Have you set a time frame to retain orders under WooCommerce > Settings > Accounts & Privacy > Personal data retention?


    Link to image: https://i.imgur.com/fRTByOG.png

    Can you also check if these orders are still stored in the database? Orders live in the wp_8vvnzztwcm_posts table where post_type = 'shop_order'. To get a list of your orders, run this SQL query: Select * from wp_8vvnzztwcm_posts where post_type='shop_order'

    If you see orders in the database, then you can run a database update and check if they’re back on the Orders page. You could also perform conflict testing, just in case the issue is due to a conflicting theme or plugin.

    Keep us posted on this!

    • This reply was modified 3 years ago by Mirko P.. Reason: changed image
    Thread Starter jfteamvision123199

    (@jfteamvision123199)

    Hi @rainfallnixfig
    I tried setting the time frame as you have suggested, cleared my browser cache and still don’t see the order history.

    I am not sure how to run a SQL query to find this information. Can someone please walk me through this? We also don’t feel comfortable changing anything about a plugin. I do basic web maintenance, we would need to ask our programmer vendor, which costs money.

    In the Woocommerce status, I do see this:
    wp_8vvnzztwcm_posts: Data: 4.94MB + Index: 0.15MB + Engine MyISAM

    Mirko P.

    (@rainfallnixfig)

    Hi @jfteamvision123199,

    Thanks for getting back to us.

    Your wp_8vvnzztwcm_posts table shows there is some data stored there related to orders. However, I would not touch or access the database if you are not quite sure how to proceed as it could cause more damage to your site.

    I would recommend reaching out to a local web developer or one of the official WooCommerce partners who can help look into this.

    What is relatively safe to do is to first make a full backup and then run a database update from WooCommerce > Status > Tools to see if this fixes the issue. Also, as previously suggested, you might want to try running a conflict test as often plugin or theme conflicts could cause these unwanted behaviors.

    You can find a more detailed explanation on how to do a conflict test here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/.

    Thanks.

    Mirko P.

    (@rainfallnixfig)

    Hello there,

    We’ve not seen any activity on this thread for a while, so I’m marking this thread as resolved. Please feel free to open a new topic if you have any other questions.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘PayPal account not Synced with WooCommerce’ is closed to new replies.