• Resolved donkiely

    (@donkiely)


    We are having the frequent disconnection problem between Square and WooCommerce. I see other discussions of this (notably here and here), but these both identify Securi as the culprit, which we don’t use. Instead, we use the paid version of Wordfence. Weirdly, I use that same combination on two other sites, and don’t have this problem. The disconnection happens typically every month or two, but sometimes both more and less often.

    Is there a setting I need to change in Wordfence to solve this problem? I’ve scanned the options, but don’t see an obvious equivalent to the Securi Automatic Secret Keys Updater feature that could be causing the problem.

    (We also use Autoptimize, but the Also optimize shop cart/ checkout? option is already disabled.)

    I don’t see any Woo fatal error logs.

    Thanks!!!
    Don

    Woo System Status:

    WordPress Environment
    
    WordPress address (URL): [redacted]
    Site address (URL): [redacted]
    WC Version: 7.3.0
    REST API Version: ✔</img> 7.3.0
    WC Blocks Version: ✔</img> 9.1.5
    Action Scheduler Version: ✔</img> 3.4.0
    Log Directory Writable: ✔</img>
    WP Version: 6.1.1
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ✔</img>
    Language: en_US
    External object cache: –
    
    Server Environment
    
    Server Info: Apache
    PHP Version: 7.4.33
    PHP Post Max Size: 256 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 7.66.0
    OpenSSL/1.1.1q-fips
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.39-42-log
    Max Upload Size: 256 MB
    Default Timezone is UTC: ✔</img>
    fsockopen/cURL: ✔</img>
    SoapClient: ✔</img>
    DOMDocument: ✔</img>
    GZip: ✔</img>
    Multibyte String: ✔</img>
    Remote Post: ✔</img>
    Remote Get: ✔</img>
    
    Database
    
    WC Database Version: 7.3.0
    WC Database Prefix: jZV_
    Total Database Size: 27.81MB
    Database Data Size: 23.91MB
    Database Index Size: 3.90MB
    jZV_woocommerce_sessions: Data: 1.23MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_order_items: Data: 0.05MB + Index: 0.02MB + Engine MyISAM
    jZV_woocommerce_order_itemmeta: Data: 1.12MB + Index: 0.26MB + Engine MyISAM
    jZV_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_actionscheduler_actions: Data: 0.09MB + Index: 0.05MB + Engine MyISAM
    jZV_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    jZV_actionscheduler_logs: Data: 0.06MB + Index: 0.04MB + Engine MyISAM
    jZV_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_comments: Data: 0.22MB + Index: 0.08MB + Engine MyISAM
    jZV_gf_draft_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_gf_entry: Data: 0.08MB + Index: 0.02MB + Engine MyISAM
    jZV_gf_entry_meta: Data: 0.22MB + Index: 0.23MB + Engine MyISAM
    jZV_gf_entry_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_gf_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    jZV_gf_form_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_gf_form_view: Data: 0.08MB + Index: 0.04MB + Engine MyISAM
    jZV_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    jZV_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_options: Data: 2.56MB + Index: 0.09MB + Engine MyISAM
    jZV_postexpirator_debug: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    jZV_postmeta: Data: 1.51MB + Index: 0.79MB + Engine MyISAM
    jZV_posts: Data: 0.87MB + Index: 0.10MB + Engine MyISAM
    jZV_sgs_log_events: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    jZV_sgs_log_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    jZV_stream: Data: 0.04MB + Index: 0.04MB + Engine MyISAM
    jZV_stream_meta: Data: 0.10MB + Index: 0.10MB + Engine MyISAM
    jZV_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    jZV_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    jZV_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    jZV_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_usermeta: Data: 0.07MB + Index: 0.03MB + Engine MyISAM
    jZV_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    jZV_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
    jZV_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    jZV_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wc_customer_lookup: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    jZV_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wc_order_product_lookup: Data: 0.05MB + Index: 0.05MB + Engine MyISAM
    jZV_wc_order_stats: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
    jZV_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    jZV_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    jZV_wc_product_meta_lookup: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
    jZV_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    jZV_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    jZV_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wfblockediplog: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    jZV_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wfconfig: Data: 2.60MB + Index: 0.01MB + Engine MyISAM
    jZV_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wffilemods: Data: 5.51MB + Index: 0.61MB + Engine MyISAM
    jZV_wfhits: Data: 0.95MB + Index: 0.11MB + Engine MyISAM
    jZV_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wfissues: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    jZV_wfknownfilelist: Data: 4.11MB + Index: 0.19MB + Engine MyISAM
    jZV_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wflogins: Data: 0.35MB + Index: 0.07MB + Engine MyISAM
    jZV_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    jZV_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    jZV_wfnotifications: Data: 0.06MB + Index: 0.01MB + Engine MyISAM
    jZV_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wfstatus: Data: 0.12MB + Index: 0.05MB + Engine MyISAM
    jZV_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_woocommerce_square_customers: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
    jZV_wpgmza: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wpgmza_circles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wpgmza_maps: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wpgmza_polygon: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wpgmza_polylines: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wpgmza_rectangles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_wsal_metadata: Data: 0.56MB + Index: 0.34MB + Engine MyISAM
    jZV_wsal_occurrences: Data: 0.73MB + Index: 0.16MB + Engine MyISAM
    jZV_wsal_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_yoast_indexable: Data: 0.12MB + Index: 0.04MB + Engine MyISAM
    jZV_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
    jZV_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    jZV_yoast_primary_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    jZV_yoast_seo_links: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    jZV_yoast_seo_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    
    Post Type Counts
    
    attachment: 85
    custom_css: 1
    nav_menu_item: 19
    owm-weather: 1
    page: 29
    post: 41
    product: 40
    product_variation: 144
    revision: 220
    shop_order: 354
    wp_global_styles: 1
    wpcode: 2
    wpforms: 1
    
    Security
    
    Secure connection (HTTPS): ✔</img>
    Hide errors from visitors: ✔</img>
    
    Active Plugins (27)
    
    ManageWP - Worker: by GoDaddy – 4.9.16
    Gravity Forms: by Gravity Forms – 2.6.9
    Akismet Anti-Spam: by Automattic – 5.0.2
    Autoptimize: by Frank Goossens (futtta) – 3.1.4
    Enable Media Replace: by ShortPixel – 4.0.2
    Widget for Social Page Feeds: by Milap Patel – 6.1
    Genesis Blocks: by StudioPress – 1.5.3
    Genesis Connect for WooCommerce: by StudioPress – 1.1.1
    Site Kit by Google: by Google – 1.92.0
    Easy HTTPS (SSL) Redirection: by Tips and Tricks HQ – 1.9.1
    WPCode Lite: by WPCode – 2.0.6
    Mai Theme Engine: by MaiTheme.com – 1.13.2
    Map Block for Google Maps: by WebFactory Ltd – 1.32
    OWM Weather: by Uwe Jacobs – 5.6.12
    PublishPress Future: by PublishPress – 2.8.3
    Salt Shaker: by Nagdy – 1.3.2
    TablePress: by Tobias Bäthge – 2.0.3
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 2.22.25.0
    
    Weather Atlas Widget: by Yu Media Group d.o.o. – 1.2.1
    WooCommerce Checkout Manager: by QuadLayers – 6.4.1
    WooCommerce Gravity Forms Product Add-Ons: by Element Stark – 3.3.26
    WP Menu Cart: by WP Overnight – 2.13.0
    WooCommerce Square: by WooCommerce – 3.4.2
    WooCommerce: by Automattic – 7.3.0
    Wordfence Security: by Wordfence – 7.8.2
    Yoast SEO: by Team Yoast – 19.14
    WP Super Cache: by Automattic – 1.9.2
    
    Inactive Plugins (3)
    
    Atomic Blocks - Gutenberg Blocks Collection: by atomicblocks – 2.9.0
    SiteGround Optimizer: by SiteGround – 7.2.9
    SiteGround Security: by SiteGround – 1.3.8
    
    Dropin Plugins (1)
    
    advanced-cache.php: advanced-cache.php
    
    Settings
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: ✔</img>
    Enforce Approved Product Download Directories: –
    Order datastore: WC_Order_Data_Store_CPT
    
    WC Pages
    
    Shop base: #309 - /shop/
    Cart: #310 - /cart/
    Checkout: #311 - /checkout/
    My account: #312 - /my-account/
    Terms and conditions: ❌</img> Page not set
    
    Theme
    
    Name: Mai Lifestyle Pro
    Version: 1.3.0
    Author URL: https://maitheme.com/
    Child Theme: ✔</img>
    Parent Theme Name: Genesis
    Parent Theme Version: 3.4.0
    Parent Theme Author URL: https://www.studiopress.com/
    WooCommerce Support: ✔</img>
    
    Templates
    
    Overrides: /home/customer/www/[redacted]/public_html/wp-content/plugins/mai-theme-engine/templates/woocommerce/content-product-cat.php
    /home/customer/www/[redacted]/public_html/wp-content/plugins/mai-theme-engine/templates/woocommerce/content-product.php
    /home/customer/www/[redacted]/public_html/wp-content/plugins/mai-theme-engine/templates/woocommerce/loop/loop-end.php
    /home/customer/www/[redacted]/public_html/wp-content/plugins/mai-theme-engine/templates/woocommerce/loop/loop-start.php
    
    Square
    
    Environment: Production
    Tokenization Enabled: –
    Debug Mode: Off
    
    Admin
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-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: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ✔</img> Next scheduled: 2023-01-22 20:52:26 -09:00
    Options: ✔</img>
    Notes: 116
    Onboarding: completed
    
    Action Scheduler
    
    Complete: 270
    Oldest: 2022-12-22 12:56:13 -0900
    Newest: 2023-01-22 08:13:19 -0900
    
    Pending: 2
    Oldest: 2023-01-22 11:34:31 -0900
    Newest: 2023-01-25 17:53:36 -0900
    
    Status report information
    
    Generated at: 2023-01-22 09:02:09 -09:00
    `
Viewing 5 replies - 1 through 5 (of 5 total)
  • Roxy

    (@roxannestoltz)

    Hi @donkiely ,

    Thanks for reaching out!

    We are having the frequent disconnection problem between Square and WooCommerce. I see other discussions of this (notably here and here), but these both identify Securi as the culprit, which we don’t use. Instead, we use the paid version of Wordfence.

    Have you tried disabling the Wordfence plugin to see if this makes any noticeable difference?

    If not, I would recommend, as a first step, deactivating this plugin temporarily to see if this resolves the issue.

    Weirdly, I use that same combination on two other sites, and don’t have this problem. The disconnection happens typically every month or two, but sometimes both more and less often

    Are there any plugins used on this site (encountering the disconnect issue) that the other two sites do not have installed/active?

    Since this could be caused by a plugin conflict, if the issue persists after disabling Wordfence, you can try reviewing your list of installed plugins on the site with the disconnect issue, and deactivating those that are not active on the other two sites, to see if you can identify the culprit.

    Please let us know how this goes!

    Thread Starter donkiely

    (@donkiely)

    Thanks, but that is not a viable solution. It would mean turning off all of our security protections potentially for multiple months, including our web application firewall, 2FA, etc. In this day and age, that is not feasible.

    And the other main website–the third is not very active–has a nearly completely different set of features and plugins. Just about the only thing in common is WooCommerce, so I hope that deactivating Woo is not necessary! 🙂

    How else can we figure out what is going on?

    Thanks,
    Don

    Roxy

    (@roxannestoltz)

    Hi @donkiely ,

    Security plugins, such as Wordfence could force Square tokens to expire periodically for security reasons, which can cause Square to always disconnected in the background intermittently. Usually by disconnecting and reconnecting Square, it creates a new token, and it resumes working.

    Have you tried to reach out to Wordfence support, asking if they can see if there is any default function within the plugin that causes the tokens to expire, and if so, if there is any way to bypass this?

    Please let us know how this goes!

    Roxy

    (@roxannestoltz)

    Just to add – you can reach out to Wordfence support in their dedicated forum. Below is a direct link:

    https://wordpress.org/support/plugin/wordfence/

    Alternatively, since you mentioned using their paid version, you can contact their support here.

    Hope this helps!

    Thread Starter donkiely

    (@donkiely)

    Thanks, Roxy! I’ll reach out to Wordfence and will report back.

    Don

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Frequent Disconnections – Wordfence’ is closed to new replies.