regalguy
Forum Replies Created
-
Forum: Plugins
In reply to: [Google for WooCommerce] 2.6.1 Broke DatalayerI can share with you the drop in GA data for Friday vs other days? Is that what you need?
Forum: Plugins
In reply to: [Google for WooCommerce] 2.6.1 Broke DatalayerHi Guys,
I left it a long time to test the new updates released. Unfortunately even the latest version 2.6.6 still breaks Google Analytics recording data.
I updated Friday morning, by Saturday morning it was clear GA was down massively on data. So I’ve reverted to 2.6.0 again as i need the stats for my Google Ads spend to track conversions.
So clearly whatever was added/removed/changed on 2.6.1 has caused this issue.
I can setup a staging site to look into but i don’t think you’ll be able to test GA with that? Would i need to set it up as a new property on GA and provide you access to that too?
Thanks
Forum: Plugins
In reply to: [Google for WooCommerce] 2.6.1 Broke DatalayerSorry, to clarify. the GTM plugin works fine, my site stopped recording data when i updated this plugin. So logic would dictate the issue is with THIS plugin. I have no doubt GTM will point the finger in this direction. Is there someone i can talk to who can actually help? 2nd or 3rd line support would be much appreciated.
Forum: Plugins
In reply to: [Google for WooCommerce] 2.6.1 Broke DatalayerReally!? That’s the plugin that adds the tags to the site! Disabling that will definitely not fix the issue! ??
Forum: Plugins
In reply to: [Google for WooCommerce] 2.6.1 Broke DatalayerHi, i need to know 2.6.2 fixes the issues as i will lose a lot of money if it doesn’t work. I need the tracking data for the Google Ads i run, without the data the ads don’t perform correctly so not only do i waste money advertising but i also lose revenue.
Forum: Plugins
In reply to: [Google for WooCommerce] 2.6.1 Broke DatalayerHi,
I can setup a staging site but how can we test tag manager on the staging site? I don’t know how to do that.
There are no fatal logs related to this.
Status report:
WordPress Environment WordPress address (URL): https://www.regaldog.co.uk<br>Site address (URL): https://www.regaldog.co.uk<br>WC Version: 8.6.1<br>REST API Version: ? 8.6.1<br>WC Blocks Version: ? 11.8.0-dev<br>Action Scheduler Version: ? 3.7.1<br>Log Directory Writable: ?<br>WP Version: 6.4.3<br>WP Multisite: –<br>WP Memory Limit: 2 GB<br>WP Debug Mode: –<br>WP Cron: –<br>Language: en_GB<br>External object cache: ? Server Environment Server Info: Apache/2.4.58 (Debian)<br>PHP Version: 8.2.16<br>PHP Post Max Size: 100 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 10000<br>cURL Version: 7.64.0<br>OpenSSL/1.1.1n SUHOSIN Installed: –<br>MySQL Version: 10.4.33-MariaDB-1:10.4.33+maria~deb10-log<br>Max Upload Size: 100 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database WC Database Version: 8.6.1<br>WC Database Prefix: 475_<br>Total Database Size: 2906.90MB<br>Database Data Size: 2268.66MB<br>Database Index Size: 638.24MB<br>475_woocommerce_sessions: Data: 3.02MB + Index: 0.05MB + Engine InnoDB<br>475_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>475_woocommerce_order_items: Data: 6.52MB + Index: 2.52MB + Engine InnoDB<br>475_woocommerce_order_itemmeta: Data: 1620.72MB + Index: 53.17MB + Engine InnoDB<br>475_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>475_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_woocommerce_shipping_zone_locations: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>475_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_woocommerce_payment_tokens: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>475_woocommerce_payment_tokenmeta: Data: 0.16MB + Index: 0.19MB + Engine InnoDB<br>475_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_actionscheduler_actions: Data: 57.59MB + Index: 61.34MB + Engine InnoDB<br>475_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_actionscheduler_logs: Data: 35.38MB + Index: 33.19MB + Engine InnoDB<br>475_afwc_campaigns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_afwc_commission_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_afwc_hits: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>475_afwc_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_afwc_payout_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_afwc_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>475_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_atum_product_data: Data: 0.19MB + Index: 0.16MB + Engine InnoDB<br>475_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_bv_ip_store: Data: 0.28MB + Index: 0.16MB + Engine InnoDB<br>475_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_commentmeta: Data: 2.47MB + Index: 4.55MB + Engine InnoDB<br>475_comments: Data: 41.56MB + Index: 40.66MB + Engine InnoDB<br>475_cp_calculated_fields_form_discount_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_cp_calculated_fields_form_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_cp_calculated_fields_form_revision: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>475_cp_calculated_fields_form_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_cuw_campaigns: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>475_cuw_offers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_cuw_stats: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>475_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB<br>475_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>475_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_fpd_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_fpd_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_gla_budget_recommendations: Data: 0.19MB + Index: 0.14MB + Engine InnoDB<br>475_gla_merchant_issues: Data: 2.02MB + Index: 0.00MB + Engine InnoDB<br>475_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_hurrytimer_evergreen: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_jetpack_sync_queue: Data: 0.03MB + Index: 0.06MB + Engine InnoDB<br>475_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_mclean_refs: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>475_mclean_scan: Data: 0.13MB + Index: 0.02MB + Engine InnoDB<br>475_options: Data: 6.13MB + Index: 0.27MB + Engine InnoDB<br>475_postmeta: Data: 138.66MB + Index: 268.53MB + Engine InnoDB<br>475_posts: Data: 17.27MB + Index: 9.61MB + Engine InnoDB<br>475_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_sbi_feed_caches: Data: 3.02MB + Index: 0.02MB + Engine InnoDB<br>475_sbi_instagram_feeds_posts: Data: 0.11MB + Index: 0.11MB + Engine InnoDB<br>475_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_sbi_instagram_posts: Data: 5.52MB + Index: 0.00MB + Engine InnoDB<br>475_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_termmeta: Data: 16.52MB + Index: 0.30MB + Engine InnoDB<br>475_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>475_term_relationships: Data: 0.19MB + Index: 0.16MB + Engine InnoDB<br>475_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>475_usermeta: Data: 123.61MB + Index: 40.33MB + Engine InnoDB<br>475_users: Data: 1.52MB + Index: 1.20MB + Engine InnoDB<br>475_viwec_clicked: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wcfm_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wc_customer_lookup: Data: 2.52MB + Index: 1.89MB + Engine InnoDB<br>475_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_wc_orders: Data: 7.52MB + Index: 9.86MB + Engine InnoDB<br>475_wc_orders_meta: Data: 37.56MB + Index: 75.47MB + Engine InnoDB<br>475_wc_order_addresses: Data: 5.52MB + Index: 7.03MB + Engine InnoDB<br>475_wc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>475_wc_order_coupon_lookup: Data: 0.45MB + Index: 0.53MB + Engine InnoDB<br>475_wc_order_operational_data: Data: 4.52MB + Index: 1.98MB + Engine InnoDB<br>475_wc_order_product_lookup: Data: 5.52MB + Index: 8.03MB + Engine InnoDB<br>475_wc_order_stats: Data: 3.52MB + Index: 3.36MB + Engine InnoDB<br>475_wc_order_tax_lookup: Data: 1.52MB + Index: 0.91MB + Engine InnoDB<br>475_wc_product_attributes_lookup: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>475_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_wc_product_meta_lookup: Data: 0.25MB + Index: 0.45MB + Engine InnoDB<br>475_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wc_revolut_customer: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_wc_revolut_orders: Data: 0.52MB + Index: 0.77MB + Engine InnoDB<br>475_wc_revolut_temp_session: Data: 19.55MB + Index: 0.33MB + Engine InnoDB<br>475_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_wfacp_stats: Data: 0.05MB + Index: 0.06MB + Engine InnoDB<br>475_wfob_stats: Data: 0.45MB + Index: 0.50MB + Engine InnoDB<br>475_wfocu_event: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>475_wfocu_event_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wfocu_session: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_woobe_history: Data: 0.39MB + Index: 0.30MB + Engine InnoDB<br>475_woobe_history_bulk: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_woocommerce_bundled_itemmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>475_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_woocommerce_exported_csv_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_woocommerce_gc_activity: Data: 0.05MB + Index: 0.06MB + Engine InnoDB<br>475_woocommerce_gc_cards: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>475_woocommerce_gc_cardsmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wpforms_entries: Data: 9.52MB + Index: 0.16MB + Engine InnoDB<br>475_wpforms_entry_fields: Data: 3.52MB + Index: 4.55MB + Engine InnoDB<br>475_wpforms_entry_meta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>475_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>475_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>475_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wpmailsmtp_debug_events: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>475_wpmailsmtp_emails_log: Data: 70.02MB + Index: 0.11MB + Engine InnoDB<br>475_wpmailsmtp_email_tracking_events: Data: 0.19MB + Index: 0.19MB + Engine InnoDB<br>475_wpmailsmtp_email_tracking_links: Data: 1.02MB + Index: 0.13MB + Engine InnoDB<br>475_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_wt_iew_action_history: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>475_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>475_yith_wcwl: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>475_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>475_yoast_indexable: Data: 1.52MB + Index: 0.34MB + Engine InnoDB<br>475_yoast_indexable_hierarchy: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>475_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>475_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>475_yoast_prominent_words: Data: 0.19MB + Index: 0.28MB + Engine InnoDB<br>475_yoast_seo_links: Data: 1.52MB + Index: 0.47MB + Engine InnoDB<br>475_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_bv_ip_store: Data: 0.23MB + Index: 0.14MB + Engine InnoDB<br>wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_options: Data: 0.22MB + Index: 0.03MB + Engine InnoDB<br>wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts amn_wpforms-lite: 2<br>attachment: 1889<br>blocks: 87<br>br_product_filter: 4<br>brb_collection: 2<br>bwg_gallery: 1<br>bwg_share: 1<br>carousels: 1<br>cartflows_flow: 2<br>cartflows_step: 5<br>custom_css: 10<br>customize_changeset: 8<br>cwginstocknotifier: 274<br>docs: 19<br>elementor_library: 110<br>epkb_post_type_1: 6<br>hurrytimer_countdown: 13<br>jetpack_migration: 2<br>jp_img_sitemap: 1<br>jp_sitemap: 1<br>jp_sitemap_master: 1<br>mc4wp-form: 1<br>mkb_faq: 1<br>nav_menu_item: 147<br>oembed_cache: 54<br>page: 121<br>post: 153<br>product: 226<br>product_variation: 640<br>sa_slider: 2<br>shop_coupon: 219<br>shop_order: 19147<br>shop_order_refund: 1210<br>sp_wps_shortcodes: 1<br>staticblocks: 95<br>thppopuptemplate: 1<br>tm_global_cp: 4<br>ux_template: 5<br>viwec_template: 16<br>vpc-config: 17<br>vpc-text-component: 4<br>wccaf: 2<br>wcccf: 6<br>wccpf: 2<br>wcct_countdown: 9<br>wcp_ruleset: 7<br>wcpa_pt_forms: 2<br>wcps: 1<br>wcst_trigger: 7<br>wfacp_checkout: 4<br>wfob_bump: 6<br>wfocu_funnel: 3<br>wfocu_offer: 3<br>woo-audit-log: 1119<br>wp_global_styles: 1<br>wp_navigation: 1<br>wp_template: 3<br>wpforms: 17<br>xlwcty_thankyou: 1 Security Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (50) Admin Menu Editor Pro: by Janis Elsts – 2.23.3<br>Affiliate For WooCommerce: by StoreApps – 7.7.0<br>ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.9.37.1<br>Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.2.2<br>Breeze: by Cloudways – 2.1.4<br>WooCommerce Checkout Upsell, Cross-sell and Order Bumps PRO: by Flycart – 1.4.5<br>Clearpay Gateway for WooCommerce: by Clearpay – 3.8.5<br>GTM4WP - A Google Tag Manager (GTM) plugin for WordPress: by Thomas Geiger – 1.20<br>Elementor: by Elementor.com – 3.20.0<br>XStore Core: by 8theme – 5.2.9<br>Facebook for WooCommerce: by Facebook – 3.1.10<br>Flexible Shipping PRO: by Octolize – 2.17.4<br>Flexible Shipping: by Octolize – 4.24.13<br>Gift Cards - Coupon Input: by SomewhereWarm – 1.0.3<br>Google Listings and Ads: by WooCommerce – 2.6.0<br>HurryTimer PRO: by Nabil Lemsieh – 2.11.2<br>Index WP MySQL For Speed: by Oliver Jones<br>Rick James – 1.4.15 Instagram Feed Pro Business: by Smash Balloon – 6.3.6<br>Jetpack: by Automattic – 13.2<br>Klarna Order Management for WooCommerce: by klarna<br>krokedil – 1.9.1 Klarna Payments for WooCommerce: by klarna – 3.4.1<br>Klaviyo: by Klaviyo<br>Inc. – 3.3.4 Perfmatters: by forgemedia – 2.2.5<br>Custom Estimated Delivery Date Format: by PluginHive – 1.0.1<br>PRO Elements: by PROElements.org – 3.19.3<br>Revolut Gateway for WooCommerce: by Revolut – 4.10.1<br>Sales Report By Country: by zorem – 1.5<br>TikTok: by TikTok – 1.2.4<br>UK Address Postcode Validation: by Ideal Postcodes – 3.4.3<br>Visual Products Configurator Custom Text Addon: by Orion – 3.2.1<br>Visual Products Configurator: by ORION – 7.6.3<br>VPC Color pattern: by Orion – 1.0.0<br>Estimated Delivery Date Plugin For WooCommerce: by PluginHive – 2.1.6<br>NextMove Lite - Thank You Page for WooCommerce: by XLPlugins – 2.18.1<br>WooCommerce Extended Coupon Features PRO: by Soft79 – 3.3.4<br>WooCommerce Cost of Goods: by SkyVerge – 2.13.0 (update to version 2.13.1 is available)<br>FOX - Currency Switcher Professional for WooCommerce: by realmag777 – 2.4.1.8<br>Woo Gift Cards: by Woo – 1.16.10<br>WooCommerce Photo Reviews Premium: by VillaTheme – 1.3.11<br>Woo Product Bundles: by Woo – 7.0.1<br>Product SKU Generator for WooCommerce: by SkyVerge – 2.5.0<br>WooCommerce - ShipStation Integration: by WooCommerce – 4.3.2 (update to version 4.3.9 is available)<br>Extra Product Options & Add-Ons for WooCommerce: by ThemeComplete – 6.4.4<br>WooCommerce: by Automattic – 8.6.1<br>Yoast SEO Premium: by Team Yoast – 20.8<br>Yoast SEO: by Team Yoast – 22.2<br>WP Mail SMTP Pro: by WP Mail SMTP – 4.0.2<br>WPForms Conversational Forms: by WPForms – 1.14.0<br>WPForms Zapier: by WPForms – 1.5.0<br>WPForms: by WPForms – 1.8.7.2 Inactive Plugins (2) BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 2.1.4.4<br>Global Shop Discount for WooCommerce Pro: by WPFactory – 1.9.5-dev Dropin Plugins (2) advanced-cache.php: advanced-cache.php<br>object-cache.php: Object Cache Pro (Drop-in) Must Use Plugins (2) Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.4.14<br>Object Cache Pro (MU): by Rhubarb Group – 1.20.2 Settings API Enabled: ?<br>Force SSL: ?<br>Currency: GBP (£)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: bundle (bundle)<br>external (external)<br>grouped (grouped)<br>pw gift card (pw-gift-card)<br>simple (simple)<br>variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br>visible (visible) Connected to Woo.com: ?<br>Enforce Approved Product Download Directories: –<br>HPOS feature screen enabled: ?<br>HPOS feature enabled: ?<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: ? WC Pages Shop base: #6 - /shop/<br>Basket: #7 - /cart/<br>Checkout: #8 - /checkout/<br>My account: #9 - /my-account/<br>Terms and conditions: #208 - /terms-and-conditions/ Theme Name: XStore Child<br>Version: 1.0<br>Author URL: https://8theme.com<br>Child Theme: ?<br>Parent Theme Name: XStore<br>Parent Theme Version: 9.2.9<br>Parent Theme Author URL: https://www.8theme.com<br>WooCommerce Support: ? Templates Overrides: xstore/woocommerce/archive-product.php<br>xstore/woocommerce/cart/cart-empty.php<br>xstore/woocommerce/cart/cart-shipping.php<br>xstore/woocommerce/cart/cart.php<br>xstore/woocommerce/cart/cross-sells.php<br>xstore/woocommerce/cart/mini-cart.php<br>xstore/woocommerce/cart/proceed-to-checkout-button.php<br>xstore/woocommerce/checkout/form-billing.php<br>xstore/woocommerce/checkout/form-checkout.php<br>xstore/woocommerce/checkout/form-shipping.php<br>xstore/woocommerce/checkout/review-order.php<br>xstore/woocommerce/checkout/thankyou.php<br>xstore/woocommerce/content-product-cat.php<br>xstore/woocommerce/content-product.php<br>xstore/woocommerce/content-single-product.php<br>xstore/woocommerce/content-widget-product.php<br>xstore/woocommerce/content-widget-reviews.php<br>xstore/woocommerce/global/breadcrumb.php<br>xstore/woocommerce/global/form-login.php<br>xstore/woocommerce/global/wrapper-end.php<br>xstore/woocommerce/global/wrapper-start.php<br>xstore/woocommerce/loop/loop-end.php<br>xstore/woocommerce/loop/loop-start.php<br>xstore/woocommerce/loop/no-products-found.php<br>xstore/woocommerce/loop/result-count.php<br>xstore/woocommerce/myaccount/dashboard.php<br>xstore/woocommerce/myaccount/form-login.php<br>xstore/woocommerce/myaccount/navigation.php<br>xstore/woocommerce/product-searchform.php<br>xstore/woocommerce/single-product/add-to-cart/simple.php<br>xstore/woocommerce/single-product/meta.php<br>xstore/woocommerce/single-product/product-image.php<br>xstore/woocommerce/single-product/related.php<br>xstore/woocommerce/single-product/tabs/tabs.php<br>xstore/woocommerce/single-product/title.php<br>xstore/woocommerce/single-product/up-sells.php<br>xstore/woocommerce/single-product-reviews.php<br>xstore/woocommerce/single-product.php Gift Cards Database Version: 1.16.10<br>Loopback Test: ?<br>Task Queueing Test: ? Product Bundles Database Version: 7.0.1<br>Loopback Test: ?<br>Template Overrides: – Klarna Payments Request Log No Klarna Payment errors: Klarna Countries Production Countries: AU AT BE DK FI FR DE GR IE IT NL NO PT ES SE CH GB<br>Test Countries: No countries selected Admin Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>product-virtual-downloadable<br>product-external-affiliate<br>product-grouped<br>product-linked<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field Daily Cron: ? Next scheduled: 2024-03-13 13:01:58 +00:00<br>Options: ?<br>Notes: 13<br>Onboarding: completed Action Scheduler Complete: 156,992<br>Oldest: 2024-02-11 08:00:06 +0000<br>Newest: 2024-03-13 08:00:04 +0000 Failed: 1,107<br>Oldest: 2022-07-21 15:17:04 +0100<br>Newest: 2024-03-11 09:45:04 +0000 Pending: 28<br>Oldest: 2024-03-13 08:01:32 +0000<br>Newest: 2024-03-20 00:05:04 +0000 Status report information Generated at: 2024-03-13 08:03:50 +00:00<br>
Thank you all for your Input. I’ve spent the day deleting all the extra backslashes I can find. Everything seems to be working much better now, product pages load lighting fast and all my products sync correctly to third parties.
Right, so going back to my orignal question:
“I’ve been having issues with slow product pages and integration to other services which sync product data. We’ve noticed the field “_wc_facebook_enhanced_catalog_attributes_size” has a size size of over 50MB.
It looks like it’s adding lots of garage data to the field such a loads of ‘\’ backslashes.”
Can you please help?
I don’t have a developer working with me. I’m trying to get some support for this plugin adding garbage data to my database
Hi,
Yes so “_wc_facebook_enhanced_catalog_attributes_size” is under “475_postmeta”
I find WP-Optimize to be pretty basic like all other DB cleaners, it just does the standard optimise tables, delete transients and trashed posts etc. Unless I’m missing an option for removing unnecessary records? What option would be to remove unnecessary?records?
Thanks
Thanks for your tips o optimising the database, i already do this daily. It is quite a large ecommerce store.
I’ve managed found the “_wc_facebook_enhanced_catalog_attributes_size” under X_postmeta table
Hi,
I was given the field name by a developer who has trouble syncing products with their plugin.
I did search the database for the field but couldn’t find it.
I don’t have any screenshots as i’m not sure how that field was found.
Please see system report below. Thank you
WordPress Environment WordPress address (URL): https://www.regaldog.co.uk
Site address (URL): https://www.regaldog.co.uk
WC Version: 7.8.2
REST API Version: ? 7.8.2
WC Blocks Version: ? 10.2.4
Action Scheduler Version: ? 3.5.4
Log Directory Writable: ?
WP Version: 6.2.2
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: –
Language: en_GB
External object cache: ? Server Environment Server Info: Apache/2.4.57 (Debian)
PHP Version: 8.1.20
PHP Post Max Size: 100 MB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.64.0
OpenSSL/1.1.1n SUHOSIN Installed: –
MySQL Version: 10.4.20-MariaDB-1:10.4.20+maria~buster-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: 7.8.2
WC Database Prefix: 475_
Total Database Size: 2897.79MB
Database Data Size: 2441.89MB
Database Index Size: 455.90MB
475_woocommerce_sessions: Data: 31.02MB + Index: 0.25MB + Engine InnoDB
475_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
475_woocommerce_order_items: Data: 5.52MB + Index: 1.52MB + Engine InnoDB
475_woocommerce_order_itemmeta: Data: 1233.69MB + Index: 43.14MB + Engine InnoDB
475_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
475_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_woocommerce_shipping_zone_locations: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
475_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
475_woocommerce_payment_tokenmeta: Data: 0.14MB + Index: 0.20MB + Engine InnoDB
475_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_actionscheduler_actions: Data: 46.16MB + Index: 47.33MB + Engine InnoDB
475_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_actionscheduler_logs: Data: 30.09MB + Index: 25.11MB + Engine InnoDB
475_afwc_campaigns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_afwc_commission_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_afwc_hits: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
475_afwc_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_afwc_payout_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_afwc_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
475_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_atum_product_data: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
475_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_bv_ip_store: Data: 0.28MB + Index: 0.16MB + Engine InnoDB
475_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_bwf_action_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_bwf_contact: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
475_bwf_wc_customers: Data: 1.52MB + Index: 0.20MB + Engine InnoDB
475_cleantalk_ac_log: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
475_cleantalk_connection_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_cleantalk_no_cookie_data: Data: 3.02MB + Index: 0.00MB + Engine InnoDB
475_cleantalk_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_cleantalk_sfw: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
475_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_cleantalk_wc_spam_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_commentmeta: Data: 2.48MB + Index: 4.53MB + Engine InnoDB
475_comments: Data: 33.56MB + Index: 32.66MB + Engine InnoDB
475_cp_calculated_fields_form_discount_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_cp_calculated_fields_form_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_cp_calculated_fields_form_revision: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
475_cp_calculated_fields_form_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_fpd_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_fpd_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_hurrytimer_evergreen: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_options: Data: 5.50MB + Index: 0.23MB + Engine InnoDB
475_postmeta: Data: 854.78MB + Index: 227.42MB + Engine InnoDB
475_posts: Data: 10.48MB + Index: 5.77MB + Engine InnoDB
475_po_plugins: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
475_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_sbi_feed_caches: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
475_sbi_instagram_feeds_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
475_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_sbi_instagram_posts: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
475_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_spbc_auth_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_spbc_backuped_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_spbc_backups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_spbc_bfp_blocked: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_spbc_firewall_data: Data: 4.52MB + Index: 3.52MB + Engine InnoDB
475_spbc_firewall_logs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
475_spbc_firewall__personal_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_spbc_firewall__personal_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_spbc_monitoring_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_spbc_scan_frontend: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_spbc_scan_links_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
475_spbc_scan_results: Data: 4.52MB + Index: 1.52MB + Engine InnoDB
475_spbc_scan_results_log: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
475_spbc_scan_signatures: Data: 0.13MB + Index: 0.05MB + Engine InnoDB
475_spbc_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_spbc_traffic_control_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_stock_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_termmeta: Data: 16.52MB + Index: 0.30MB + Engine InnoDB
475_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
475_term_relationships: Data: 0.19MB + Index: 0.13MB + Engine InnoDB
475_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
475_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_usermeta: Data: 109.56MB + Index: 33.48MB + Engine InnoDB
475_users: Data: 1.52MB + Index: 1.05MB + Engine InnoDB
475_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wcfm_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wc_customer_lookup: Data: 1.52MB + Index: 1.81MB + Engine InnoDB
475_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wc_order_coupon_lookup: Data: 0.34MB + Index: 0.41MB + Engine InnoDB
475_wc_order_product_lookup: Data: 4.52MB + Index: 5.86MB + Engine InnoDB
475_wc_order_stats: Data: 2.52MB + Index: 2.25MB + Engine InnoDB
475_wc_order_tax_lookup: Data: 1.52MB + Index: 0.72MB + Engine InnoDB
475_wc_product_attributes_lookup: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
475_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wc_product_meta_lookup: Data: 0.23MB + Index: 0.44MB + Engine InnoDB
475_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wfacp_stats: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
475_wfco_connectormeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wfco_connectors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wfco_report_views: Data: 0.06MB + Index: 0.08MB + Engine InnoDB
475_wfob_stats: Data: 0.45MB + Index: 0.50MB + Engine InnoDB
475_wfocu_event: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
475_wfocu_event_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wfocu_session: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_woobe_history: Data: 2.52MB + Index: 2.13MB + Engine InnoDB
475_woobe_history_bulk: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
475_woocommerce_gc_activity: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
475_woocommerce_gc_cards: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
475_woocommerce_gc_cardsmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wpforms_entries: Data: 8.52MB + Index: 0.13MB + Engine InnoDB
475_wpforms_entry_fields: Data: 3.52MB + Index: 4.34MB + Engine InnoDB
475_wpforms_entry_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
475_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
475_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
475_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpf_filters: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
475_wplc_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpmailsmtp_debug_events: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
475_wpmailsmtp_emails_log: Data: 0.30MB + Index: 0.06MB + Engine InnoDB
475_wpmailsmtp_email_tracking_events: Data: 1.02MB + Index: 0.03MB + Engine InnoDB
475_wpmailsmtp_email_tracking_links: Data: 1.02MB + Index: 1.02MB + Engine InnoDB
475_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wsal_metadata: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wsal_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wt_iew_action_history: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
475_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_yith_wcwl: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
475_yith_wcwl_lists: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
475_yoast_indexable: Data: 0.45MB + Index: 0.33MB + Engine InnoDB
475_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
475_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
475_yoast_prominent_words: Data: 0.19MB + Index: 0.28MB + Engine InnoDB
475_yoast_seo_links: Data: 1.50MB + Index: 0.31MB + Engine InnoDB
475_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + 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_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bv_ip_store: Data: 0.23MB + Index: 0.14MB + Engine InnoDB
wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 0.22MB + Index: 0.03MB + Engine InnoDB
wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_posts: Data: 0.02MB + Index: 0.06MB + 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.02MB + 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_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + 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.02MB + 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.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_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + 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_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts amn_wpforms-lite: 2
attachment: 1692
blocks: 85
br_product_filter: 4
brb_collection: 2
bwg_gallery: 1
bwg_share: 1
carousels: 1
cartflows_flow: 2
cartflows_step: 5
country_restriction: 1
custom_css: 8
customize_changeset: 9
cwginstocknotifier: 160
docs: 19
epkb_post_type_1: 6
hurrytimer_countdown: 8
jetpack_migration: 2
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
mc4wp-form: 1
mkb_faq: 1
nav_menu_item: 175
oembed_cache: 54
page: 97
post: 143
product: 192
product_variation: 644
sa_slider: 2
shop_coupon: 144
shop_order: 15746
shop_order_refund: 988
sp_wps_shortcodes: 1
thppopuptemplate: 1
tm_global_cp: 9
ux_template: 5
vpc-config: 15
vpc-text-component: 4
wccaf: 2
wcccf: 6
wccpf: 2
wcct_countdown: 9
wcp_ruleset: 7
wcpa_pt_forms: 2
wcps: 1
wcst_trigger: 7
wfacp_checkout: 4
wfob_bump: 6
wfocu_funnel: 3
wfocu_offer: 3
woo-audit-log: 1119
wp_global_styles: 1
wpforms: 13
xlwcty_thankyou: 1 Security Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (47) Admin Menu Editor Pro: by Janis Elsts – 2.20
Affiliate For WooCommerce: by StoreApps – 6.17.0
ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.9.31.1
Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 4.0.0
Breeze: by Cloudways – 2.0.26
Anti-Spam by CleanTalk: by СleanTalk – 6.12
Clearpay Gateway for WooCommerce: by Clearpay – 3.5.4
GTM4WP: by Thomas Geiger – 1.16.2
Facebook for WooCommerce: by Facebook – 3.0.26
Flexible Shipping PRO: by Octolize – 2.16.1
Flexible Shipping: by Octolize – 4.21.4
Gift Cards - Coupon Input: by SomewhereWarm – 1.0.2
HurryTimer PRO: by Nabil Lemsieh – 2.10.1
Index WP MySQL For Speed: by Oliver Jones
Rick James – 1.4.13 Instagram Feed Pro Business: by Smash Balloon – 6.2.4
Jetpack: by Automattic – 12.2.1
Kadence WooCommerce Email Designer: by Kadence WP – 1.5.11
Klaviyo: by Klaviyo
Inc. – 3.1.0 Perfmatters: by forgemedia – 2.1.3
Custom Estimated Delivery Date Format: by PluginHive – 1.0.1
Product Catalog Feed Pro by PixelYourSite: by PixelYourSite – 5.3.3
TikTok: by TikTok – 1.1.2
UK Address Postcode Validation: by Ideal Postcodes – 3.3.1
Upsell Order Bump Offer for WooCommerce Pro: by WP Swings – 2.1.4
Upsell Order Bump Offer for WooCommerce: by WP Swings – 2.2.3
Visual Products Configurator Custom Text Addon: by Orion – 3.2.1
Visual Products Configurator: by ORION – 7.5
VPC Color pattern: by Orion – 1.0.0
Estimated Delivery Date Plugin For WooCommerce: by PluginHive – 2.1.3
NextMove Lite - Thank You Page for WooCommerce: by XLPlugins – 2.16.0
WooCommerce Extended Coupon Features PRO: by Soft79 – 3.3.2
WooCommerce Cost of Goods: by SkyVerge – 2.13.0
WooCommerce Stripe Gateway: by WooCommerce – 7.4.1
WooCommerce Gift Cards: by WooCommerce – 1.16.3
WooCommerce Payments: by Automattic – 6.1.1
WooCommerce Photo Reviews Premium: by VillaTheme – 1.3.10
Product SKU Generator for WooCommerce: by SkyVerge – 2.4.8
WooCommerce - ShipStation Integration: by WooCommerce – 4.3.2 (update to version 4.3.7 is available)
Extra Product Options & Add-Ons for WooCommerce: by ThemeComplete – 6.3.2
WooCommerce: by Automattic – 7.8.2
Yoast SEO Premium: by Team Yoast – 20.8
Yoast SEO: by Team Yoast – 20.10
WP Mail SMTP Pro: by WP Mail SMTP – 3.8.1
WPForms Conversational Forms: by WPForms – 1.11.0
WPForms Zapier: by WPForms – 1.5.0
WPForms: by WPForms – 1.8.2.2
YITH WooCommerce Wishlist: by YITH – 3.22.0 Inactive Plugins (2) BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 2.1.3.2
Country Restrictions for WooCommerce: by Addify – 1.4.1 Dropin Plugins (2) advanced-cache.php: advanced-cache.php
object-cache.php: Object Cache Pro (Drop-in) Must Use Plugins (2) Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.4.11
Object Cache Pro (MU): by Rhubarb Group – 1.18.2 Settings API Enabled: ?
Force SSL: ?
Currency: GBP (£)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: bundle (bundle)
external (external)
grouped (grouped)
pw gift card (pw-gift-card)
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)
visible (visible) Connected to WooCommerce.com: ?
Enforce Approved Product Download Directories: –
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – WC Pages Shop base: #6 - /shop/
Basket: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #208 - /terms-and-conditions/ Theme Name: Flatsome Child
Version: 3.0
Author URL:
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.17.3
Parent Theme Author URL: https://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/rating.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 Gift Cards Database Version: 1.16.3
Loopback Test: ?
Task Queueing Test: ? Admin Enabled Features: activity-panels
analytics
product-block-editor
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page Disabled Features: core-profiler
minified-js
new-product-management-experience
product-variation-management
settings
async-product-editor-category-field Daily Cron: ? Next scheduled: 2023-07-04 13:01:58 +01:00
Options: ?
Notes: 11
Onboarding: completed WooCommerce Payments Version: 6.1.1
Connected to WPCOM: Yes
Blog ID: 142766104
Account ID: acct_1JrUPG2EitTUPaYz Action Scheduler Complete: 126,868
Oldest: 2023-03-28 17:21:47 +0100
Newest: 2023-07-04 14:00:03 +0100 Failed: 892
Oldest: 2022-07-21 15:17:04 +0100
Newest: 2023-06-29 14:00:09 +0100 Pending: 23
Oldest: 2023-07-04 14:00:03 +0100
Newest: 2023-07-08 08:00:04 +0100 Status report information Generated at: 2023-07-04 14:15:55 +01:00
`We’re having the same issue here for some orders. Worked fine with Stripe before. Is there something i can do to try and resolve this?
Our host won’t help with issues like this. Given that the error only occurs when the Plugin is active, they advise to seek assistance for the Plugin or use another plugin.
That’s brilliant! Thank you so much for the fast fix!
Hi Ryan,
I’m not 100% sure how i fixed it to be honest, i ended up using the position “woocommerce_after_checkout_billing_form” which randomly started appearing one day! If i remove that position it disappears though which is odd because it even disappears for the default theme.
Unfortunately i don’t have any more info than that.