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

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.

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.

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.

• This reply was modified 3 years ago by 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