Square sync gets stuck at 93%

  • Resolved hal8

    (@hal8)


    3 years, 1 month ago

    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)
  • xue28 (woo-hc)

    (@xue28)

    3 years, 1 month ago

    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)

    3 years, 1 month ago

    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).

    xue28 (woo-hc)

    (@xue28)

    3 years, 1 month ago

    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.