• Resolved hal8

    (@hal8)


    Hi

    I have a client site which uses the Square plugin to sync their shop and WooCommerce website.

    They have recently tried to Sync the two but have informed me the sync gets stuck at 93% and doesn’t ever change. I have tried today and had the same result.

    Below is the System status:

    `
    ### WordPress Environment ###
    
    WordPress address (URL): https://boutiqueginshack.co.uk
    Site address (URL): https://boutiqueginshack.co.uk
    WC Version: 7.4.0
    REST API Version: ✔</img> 7.4.0
    WC Blocks Version: ✔</img> 9.4.3
    Action Scheduler Version: ✔</img> 3.5.4
    Log Directory Writable: ✔</img>
    WP Version: 6.1.1
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ✔</img>
    Language: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 8.0.27
    PHP Post Max Size: 32 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 16384
    cURL Version: 7.84.0
    OpenSSL/1.1.1p
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.32
    Max Upload Size: 32 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.4.0
    WC Database Prefix: dhgin_
    Total Database Size: 94.31MB
    Database Data Size: 68.10MB
    Database Index Size: 26.21MB
    dhgin_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    dhgin_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    dhgin_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    _mig_dhgin_actionscheduler_actions: Data: 0.11MB + Index: 0.11MB + Engine InnoDB
    _mig_dhgin_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    _mig_dhgin_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    _mig_dhgin_actionscheduler_logs: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    _mig_dhgin_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    _mig_dhgin_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    _mig_dhgin_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    _mig_dhgin_options: Data: 0.27MB + Index: 0.03MB + Engine InnoDB
    _mig_dhgin_postmeta: Data: 0.23MB + Index: 0.27MB + Engine InnoDB
    dhgin_actionscheduler_actions: Data: 12.02MB + Index: 14.50MB + Engine InnoDB
    dhgin_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_actionscheduler_logs: Data: 8.02MB + Index: 6.03MB + Engine InnoDB
    dhgin_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    dhgin_db7_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_litespeed_crawler: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_litespeed_crawler_blacklist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_litespeed_img_optm: Data: 0.20MB + Index: 0.14MB + Engine InnoDB
    dhgin_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    dhgin_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    dhgin_options: Data: 12.03MB + Index: 0.23MB + Engine InnoDB
    dhgin_postmeta: Data: 6.13MB + Index: 1.97MB + Engine InnoDB
    dhgin_posts: Data: 4.39MB + Index: 0.19MB + Engine InnoDB
    dhgin_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_rank_math_analytics_gsc: Data: 0.23MB + Index: 0.41MB + Engine InnoDB
    dhgin_rank_math_analytics_inspections: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    dhgin_rank_math_analytics_objects: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_rank_math_internal_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    dhgin_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_term_relationships: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
    dhgin_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    dhgin_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    dhgin_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    dhgin_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    dhgin_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
    dhgin_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    dhgin_wfconfig: Data: 1.33MB + Index: 0.00MB + Engine InnoDB
    dhgin_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wffilemods: Data: 14.55MB + Index: 0.00MB + Engine InnoDB
    dhgin_wfhits: Data: 0.11MB + Index: 0.05MB + Engine InnoDB
    dhgin_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    dhgin_wfknownfilelist: Data: 6.52MB + Index: 0.00MB + Engine InnoDB
    dhgin_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    dhgin_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    dhgin_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    dhgin_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    dhgin_wfstatus: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
    dhgin_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    dhgin_wpsdb_alter_statements: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 514
    mc4wp-form: 2
    nav_menu_item: 13
    page: 13
    post: 2
    product: 164
    product_variation: 169
    revision: 221
    shop_order: 11
    testimonials: 14
    wp_global_styles: 2
    wpcf7_contact_form: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ✔</img>
    Hide errors from visitors: ✔</img>
    
    ### Active Plugins (19) ###
    
    Advanced Custom Fields PRO: by WP Engine – 6.0.7
    Better Search Replace: by WP Engine – 1.4.2
    Contact Form 7: by Takayuki Miyoshi – 5.7.4
    Contact Form CFDB7: by Arshid – 1.2.6.5
    Jetpack: by Automattic – 11.8.4
    Kraken Image Optimizer: by Karim Salman – 2.6.8
    LiteSpeed Cache: by LiteSpeed Technologies – 5.3.2
    MC4WP: Mailchimp for WordPress: by ibericode – 4.9.1
    PW WooCommerce Bulk Edit Pro: by Pimwick
    LLC – 2.347
    
    Safe SVG: by 10up – 2.0.3
    Rank Math SEO: by Rank Math – 1.0.108
    Simple Custom Post Order: by Colorlib – 2.5.6
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.22.24
    
    WooCommerce Min/Max Quantities: by WooCommerce – 2.4.25
    WooCommerce Name Your Price: by Kathy Darling – 3.3.9
    WooCommerce Square: by WooCommerce – 3.5.0
    WooCommerce Table Rate Shipping: by WooCommerce – 3.0.40
    WooCommerce: by Automattic – 7.4.0
    Wordfence Security: by Wordfence – 7.9.0
    
    ### Inactive Plugins (0) ###
    
    
    ### Must Use Plugins (4) ###
    
    Bedrock Autoloader: by Roots – 1.0.3
    Register Theme Directory: by Roots – 1.0.0
    theme-functions.php: by  –
    walkers.php: by  –
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: GBP (£)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    variation (variation)
    
    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: –
    Enforce Approved Product Download Directories: ✔</img>
    Order datastore: WC_Order_Data_Store_CPT
    
    ### WC Pages ###
    
    Shop base: #539 - /shop/
    Basket: #8 - /basket/
    Checkout: #9 - /checkout/
    My account: #10 - /my-account/
    Terms and conditions: #36 - /terms-and-conditions/
    
    ### Theme ###
    
    Name: Boutique Gin Shack
    Version: 10.x-dev
    Author URL: https://davehallett.net
    Child Theme: ❌</img> – 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: ✔</img>
    
    ### Templates ###
    
    Overrides: gin/resources/views/woocommerce/archive-product.blade.php
    gin/resources/views/woocommerce/cart/cart.blade.php version 3.8.0 is out of date. The core version is 7.4.0
    gin/resources/views/woocommerce/content-product.blade.php
    gin/resources/views/woocommerce/content-single-product.blade.php
    gin/resources/views/woocommerce/single-product/related.blade.php
    gin/resources/views/woocommerce/single-product.blade.php
    gin/resources/views/woocommerce/taxonomy-product-cat.blade.php
    gin/resources/views/woocommerce/taxonomy-product-tag.blade.php
    
    Outdated Templates: ❌</img>
    					
    					
    						Learn how to update
    
    ### Pimwick Plugins ###
    
    PW WooCommerce Bulk Edit Pro: License key: PW-63073c9e1c122
    Result: success
    Cached: 2023-02-21
    
    
    ### Square ###
    
    Environment: Production
    Tokenization Enabled: –
    Debug Mode: Off
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    new-product-management-experience
    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
    product-variation-management
    settings
    
    Daily Cron: ✔</img> Next scheduled: 2023-02-22 08:19:00 +00:00
    Options: ✔</img>
    Notes: 51
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 44,889
    Oldest: 2023-01-21 15:40:15 +0000
    Newest: 2023-02-21 14:53:22 +0000
    
    Failed: 28
    Oldest: 2022-07-31 14:11:17 +0100
    Newest: 2023-02-21 13:27:22 +0000
    
    In-progress: 1
    Oldest: –
    Newest: –
    
    Pending: 15
    Oldest: 2023-02-21 14:53:31 +0000
    Newest: 2023-02-27 18:13:44 +0000
    
    
    ### Name Your Price ###
    
    Version: 
    Template overrides: –
    
    ### Status report information ###
    
    Generated at: 2023-02-21 14:53:44 +00:00
    `

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hi @hal8

    Thanks for reaching out!

    I understand that you are unable to finish the sync between WooCommerce and Square and gets stuck at 93%.

    If you could please provide the fatal error logs (if any) under WooCommerce > Status > Logs.

    Thread Starter hal8

    (@hal8)

    Hi @xue28

    Thanks for your reply. Yes thats correct regarding Square getting stuck at 93%.

    In the Status logs, the latest one (22/02/23), is quite bit but there doesn’t seem to be any errors (that I can see).

    Hi @hal8

    Thanks for checking the status logs.

    Can you please try to switch to the default Storefront theme and only WooCommerce and Square plugins are enabled, then try to run a sync and see if this works?

    If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

    If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

    Let us know how it goes!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Square sync gets stuck at 93%’ is closed to new replies.