opz

Hello Andre,

90% of times we search by the customer email or by the order ID.

Anything else you suggested is above our knowledge. We are not familiar with MySQL or databases.

This topic is to address the issue and ask for an expert to fix it by custom work or if it’s a woocommerce issue, maybe with the plugin update in the future.

-A

Hello Igor,

Here is some information.

1.

### WordPress Environment ###

WordPress address (URL): 
Site address (URL): 
WC Version: 6.2.2
REST API Version: ? 6.2.2
WC Blocks Version: ? 6.7.3
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.1.0
Log Directory Writable: ?
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: –

### Server Environment ###

Server Info: nginx/1.21.3
PHP Version: 7.4.25
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 15000
cURL Version: 7.68.0
OpenSSL/1.1.1i

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.12-MariaDB-1:10.5.12+maria~focal
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.2.2
WC Database Prefix: wp_
Total Database Size: 21829.45MB
Database Data Size: 18135.02MB
Database Index Size: 3694.43MB
wp_woocommerce_sessions: Data: 50.02MB + Index: 1.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.17MB + Engine InnoDB
wp_woocommerce_order_items: Data: 29.56MB + Index: 11.52MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 376.95MB + Index: 214.50MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + 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.03MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 12.05MB + Index: 17.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: 10.02MB + Index: 8.03MB + Engine InnoDB
wp_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_campaigns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_referralmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_referrals: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_sales: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_visits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwfan_abandonedcarts: Data: 326.89MB + Index: 11.80MB + Engine InnoDB
wp_bwfan_automationmeta: Data: 1.05MB + Index: 0.03MB + Engine InnoDB
wp_bwfan_automations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bwfan_broadcast: Data: 2.31MB + Index: 0.03MB + Engine InnoDB
wp_bwfan_contact_automations: Data: 25.56MB + Index: 33.08MB + Engine InnoDB
wp_bwfan_contact_note: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwfan_conversions: Data: 2.52MB + Index: 3.81MB + Engine InnoDB
wp_bwfan_engagement_tracking: Data: 1687.98MB + Index: 1046.61MB + Engine InnoDB
wp_bwfan_engagement_trackingmeta: Data: 2694.00MB + Index: 109.70MB + Engine InnoDB
wp_bwfan_fields: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_bwfan_field_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bwfan_form_feeds: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bwfan_import_export: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bwfan_link_triggers: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_bwfan_logmeta: Data: 5156.95MB + Index: 198.44MB + Engine InnoDB
wp_bwfan_logs: Data: 70.59MB + Index: 53.13MB + Engine InnoDB
wp_bwfan_message: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwfan_message_unsubscribe: Data: 2.52MB + Index: 10.09MB + Engine InnoDB
wp_bwfan_syncrecords: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_bwfan_taskmeta: Data: 1811.28MB + Index: 11.03MB + Engine InnoDB
wp_bwfan_tasks: Data: 8.02MB + Index: 11.08MB + Engine InnoDB
wp_bwfan_task_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwfan_templates: Data: 123.58MB + Index: 4.55MB + Engine InnoDB
wp_bwfan_terms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwf_ab_experiments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwf_actions: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_bwf_action_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwf_contact: Data: 56.59MB + Index: 32.16MB + Engine InnoDB
wp_bwf_contact_fields: Data: 25.56MB + Index: 77.44MB + Engine InnoDB
wp_bwf_contact_meta: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
wp_bwf_conversion_tracking: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_bwf_funnelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bwf_funnels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwf_optin_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bwf_wc_customers: Data: 13.52MB + Index: 6.03MB + Engine InnoDB
wp_commentmeta: Data: 1.52MB + Index: 0.70MB + Engine InnoDB
wp_comments: Data: 535.00MB + Index: 371.78MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 20.03MB + Index: 1.09MB + Engine InnoDB
wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 4395.45MB + Index: 1090.52MB + Engine InnoDB
wp_posts: Data: 137.23MB + Index: 42.69MB + Engine InnoDB
wp_snippets: 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_trackship_shipment: Data: 23.56MB + Index: 53.28MB + Engine InnoDB
wp_trackship_shipment_meta: Data: 150.44MB + Index: 0.25MB + Engine InnoDB
wp_trackship_shipping_provider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wacv_abandoned_cart_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wacv_cart_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wacv_email_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wacv_guest_info_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + 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: 14.55MB + Index: 12.06MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 1.52MB + Index: 1.02MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 35.58MB + Index: 35.05MB + Engine InnoDB
wp_wc_order_stats: Data: 23.55MB + Index: 21.39MB + 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_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.47MB + 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.03MB + Engine InnoDB
wp_wfacp_stats: Data: 11.52MB + Index: 21.06MB + Engine InnoDB
wp_wfco_connectormeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wfco_connectors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wfco_report_views: Data: 0.14MB + Index: 0.27MB + Engine InnoDB
wp_wfob_stats: Data: 13.52MB + Index: 24.06MB + Engine InnoDB
wp_wfocu_event: Data: 40.56MB + Index: 41.58MB + Engine InnoDB
wp_wfocu_event_meta: Data: 69.61MB + Index: 0.00MB + Engine InnoDB
wp_wfocu_session: Data: 13.52MB + Index: 13.06MB + Engine InnoDB
wp_woocommerce_bis_activity: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_bis_notifications: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_woocommerce_bis_notificationsmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woo_shippment_provider: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_entries: Data: 13.52MB + Index: 1.52MB + Engine InnoDB
wp_wpforms_entry_fields: Data: 5.52MB + Index: 4.55MB + Engine InnoDB
wp_wpforms_entry_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 39.58MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_indexable: Data: 76.55MB + Index: 59.63MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 12.41MB + Index: 14.42MB + 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.20MB + Index: 0.13MB + Engine InnoDB
wp_zorem_email_sms_log: Data: 9.52MB + Index: 20.61MB + Engine InnoDB

### Post Type Counts ###

attachment: 860
blocks: 5
custom_css: 2
customize_changeset: 6
elementor_library: 19
nav_menu_item: 8
oembed_cache: 16
page: 49
post: 1
postman_sent_mail: 250
product: 21
product_variation: 37
redirect_rule: 8
revision: 1736
shop_coupon: 15762
shop_order: 190248
shop_order_refund: 4783
wacv_email_template: 3
wfacp_checkout: 4
wfob_bump: 6
wfocu_funnel: 5
wfocu_offer: 10
wpforms: 3

### Security ###

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

### Active Plugins (32) ###

AffiliateWP: by Sandhills Development
LLC – 2.9.1

AffiliateWP - Affiliate Portal: by Sandhills Development
LLC – 1.1.2

Advanced Shipment Tracking Pro: by zorem – 1.9
Classic Editor: by WordPress Contributors – 1.6.2
WooCommerce Clone Orders: by Vibe Agency – 1.3.1
Code Snippets: by Code Snippets Pro – 2.14.3
WooFunnels Funnel Builder Pro: by BuildWooFunnels – 2.0.1
WooFunnels Funnel Builder: by BuildWooFunnels – 2.0.1
Loco Translate: by Tim Whitlock – 2.5.8
Members: by MemberPress – 3.1.7
Metorik Helper: by Metorik – 1.5.1
PixelYourSite PRO: by PixelYourSite – 8.6.9
PixelYourSite Super Pack: by PixelYourSite – 3.0.4
Post SMTP: by Post SMTP – 2.0.24
Safe Redirect Manager: by 10up – 1.10.1
Safe SVG: by 10up – 1.9.10
SMS for WooCommerce: by zorem – 1.5.5
TrackShip for WooCommerce: by TrackShip – 1.3.3
WooCommerce Dynamic Pricing & Discounts: by RightPress – 2.4.3
WPC Frequently Bought Together for WooCommerce (Premium): by WPClever – 4.2.0.2
WooCommerce Back In Stock Notifications: by WooCommerce – 1.3.1
WooCommerce Stripe Gateway: by WooCommerce – 6.2.0
WooCommerce Notification Premium: by Andy Ha (villatheme.com) – 1.4.2.2
WooCommerce PayPal Payments: by WooCommerce – 1.7.0 (update to version 1.7.1 is available)
WooCommerce Photo Reviews Premium: by VillaTheme – 1.1.5.4
WooCommerce: by Automattic – 6.2.2 (update to version 6.4.1 is available)
Yoast SEO: by Team Yoast – 18.2
Autonami Marketing Automations Connectors: by WooFunnels – 2.0.4
Autonami Marketing Automations Pro: by WooFunnels – 2.0.7
Autonami Marketing Automations For WordPress: by BuildWooFunnels – 2.0.8
WP Rocket: by WP Media – 3.10.8
WPForms: by WPForms – 1.7.2.2

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

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

Kinsta Must-use Plugins: by Kinsta Team – 2.3.4

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: bundle (bundle)
external (external)
grouped (grouped)
simple (simple)
variable (variable)
woosb (woosb)

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: #6 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Flatsome Child
Version: 3.1
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.14.3
Parent Theme Author URL: https://www.uxthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php

### Back In Stock ###

Database Version: 1.3.1
Loopback Test: ?

### WooCommerce PayPal Payments ###

Onboarded: ?
Shop country code: EE
WooCommerce currency supported: ?
PayPal card processing available in country: –
Pay Later messaging available in country: –
Webhook status: –
Vault enabled: ?
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: ?

### Action Scheduler ###

Complete: 39,090
Oldest: 2022-03-17 18:11:51 +0200
Newest: 2022-04-16 19:49:28 +0300

Failed: 9
Oldest: 2021-09-23 15:51:09 +0300
Newest: 2022-03-22 14:51:50 +0200

Pending: 6
Oldest: 2022-04-17 05:15:45 +0300
Newest: 2022-04-23 02:55:02 +0300

### Status report information ###

Generated at: 2022-04-16 19:52:08 +03:00

2.

2022-03-22T12:19:02+00:00 CRITICAL Uncaught Error: Call to a member function get_option() on null in /www/carmountcom_224/public/wp-content/plugins/funnel-builder-pro/modules/one-click-upsells/gateways/class-wfocu-gateway-integration-paypal-express-checkout.php:1318
Stack trace:
#0 /www/carmountcom_224/public/wp-content/plugins/funnel-builder-pro/modules/one-click-upsells/includes/class-wfocu-ajax-controller.php(1931): WFOCU_Gateway_Integration_Paypal_Express_Checkout->process_refund_offer(Object(Automattic\WooCommerce\Admin\Overrides\Order))
#1 /www/carmountcom_224/public/wp-includes/class-wp-hook.php(307): WFOCU_AJAX_Controller::refund_offer('')
#2 /www/carmountcom_224/public/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters('', Array)
#3 /www/carmountcom_224/public/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#4 /www/carmountcom_224/public/wp-admin/admin-ajax.php(187): do_action('wp_ajax_wfocu_a...')
#5 {main}
  thrown in /www/carmountcom_224/public/wp-content/plugins/funnel-builder-pro/modules/one-click-upsells/gateways/class-wfocu-gateway-integration-paypal-express-checkout.php on line 1318

2022-03-22T12:51:52+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /www/carmountcom_224/public/wp-includes/functions.php on line 642

I again resolved this problem. The theme i was using was from wordpress. I needed the full vesion of the theme from the homepage. Hopw this helps someone

I resolved the problem with Home icon button, but now im facing another problem. My shortcodes don’t work. When i try to use two columns and insert shortcodes, it just shows the shortcodes on the site. I have tried both visual and text editor.