Sync Failed issue

Hello @balinjfoley,

Thanks for reaching out.

I’m sorry that you are experiencing issues with the synchronization of products in your store.

As a first step, please make sure that you are using the latest versions of both WooCommerce and Square plugins.

Next, kindly check the troubleshooting tips about?Sync Issues?and see if this resolves the issue?

If the above troubleshooting steps do not help, please share your?System Status Report?that you can find via?WooCommerce > Status. Select?Get system report?and Copy for support. Once you’ve done that, you can paste it via?https://gist.github.com/?and send the link here.

Thanks!

I’ve updated the plugins and ran the updates but it still seems some products aren’t syncing correctly. I got around it by deleting the products in square then resyncing them from Woo, but will I have to do that each time I add a new variation from Woo?

Here’s the link from the system status: https://github.com/BalinF/square-sync/new/main

` WordPress Environment

WordPress address (URL): https://espireclothing.com.au
Site address (URL): https://espireclothing.com.au
WC Version: 8.6.1
REST API Version: ? 8.6.1
WC Blocks Version: ? 11.8.0-dev
Action Scheduler Version: ? 3.7.1
Log Directory Writable: ?
WP Version: 6.4.3
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: – Server Environment

Server Info: LiteSpeed
PHP Version: 8.1.27
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 3000
cURL Version: 7.87.0
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 10.6.17-MariaDB
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 8.4.0
WC Database Prefix: wpsq_
Total Database Size: 165.99MB
Database Data Size: 142.23MB
Database Index Size: 23.76MB
wpsq_woocommerce_sessions: Data: 0.14MB + Index: 0.01MB + Engine MyISAM
wpsq_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_actionscheduler_actions: Data: 10.81MB + Index: 4.35MB + Engine MyISAM
wpsq_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_actionscheduler_logs: Data: 7.48MB + Index: 6.27MB + Engine MyISAM
wpsq_berocket_termmeta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpsq_braapf_product_stock_status_parent: Data: 0.08MB + Index: 0.14MB + Engine MyISAM
wpsq_braapf_product_variation_attributes: Data: 1.04MB + Index: 0.39MB + Engine MyISAM
wpsq_braapf_term_taxonomy_hierarchical: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_braapf_variable_attributes: Data: 0.02MB + Index: 0.05MB + Engine MyISAM
wpsq_commentmeta: Data: 0.05MB + Index: 0.02MB + Engine MyISAM
wpsq_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpsq_e_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_e_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_e_submissions_actions_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_e_submissions_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_fbv: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_fbv_attachment_folder: Data: 0.03MB + Index: 0.06MB + Engine MyISAM
wpsq_jetpack_sync_queue: Data: 36.30MB + Index: 3.30MB + Engine MyISAM
wpsq_layerslider: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_layerslider_drafts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailchimp_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_automations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_automation_runs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_automation_run_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_automation_run_subjects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_automation_triggers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_automation_versions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_forms: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_log: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_mailpoet_newsletters: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wpsq_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_newsletter_templates: Data: 1.04MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_scheduled_tasks: Data: 0.07MB + Index: 0.02MB + Engine MyISAM
wpsq_mailpoet_scheduled_task_subscribers: Data: 0.14MB + Index: 0.09MB + Engine MyISAM
wpsq_mailpoet_segments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_settings: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_statistics_bounces: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_statistics_woocommerce_purchases: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_subscribers: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpsq_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_subscriber_segment: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_mailpoet_subscriber_tag: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_tags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_user_agents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_options: Data: 40.98MB + Index: 0.53MB + Engine MyISAM
wpsq_postmeta: Data: 18.01MB + Index: 5.56MB + Engine MyISAM
wpsq_posts: Data: 23.72MB + Index: 1.06MB + Engine MyISAM
wpsq_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
wpsq_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_termmeta: Data: 0.57MB + Index: 0.04MB + Engine MyISAM
wpsq_terms: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
wpsq_term_relationships: Data: 0.11MB + Index: 0.25MB + Engine MyISAM
wpsq_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpsq_trustindex_google_reviews: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_usermeta: Data: 0.16MB + Index: 0.02MB + Engine MyISAM
wpsq_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_admin_note_actions: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wpsq_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_orders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_orders_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_order_addresses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_order_operational_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_product_attributes_lookup: Data: 0.41MB + Index: 0.46MB + Engine MyISAM
wpsq_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_wc_product_meta_lookup: Data: 0.25MB + Index: 0.39MB + Engine MyISAM
wpsq_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfconfig: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpsq_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wffilemods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfhits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfknownfilelist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wflogins: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpsq_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
wpsq_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpsq_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wfstatus: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woocommerce_square_customers: Data: 0.42MB + Index: 0.39MB + Engine MyISAM
wpsq_woo_square_integration_deleted_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_woo_square_integration_logs: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wpsq_wpforms_payments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wpforms_payment_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wpforms_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wpf_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_wpf_meta_keys: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpsq_wpf_meta_values: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpsq_wpf_meta_values_bk: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpsq_yith_wcwl_lists: Data: 0.00MB + Index: 0.01MB + Engine MyISAM Post Type Counts

attachment: 2610
bafg: 6
blocks: 35
br_product_filter: 7
customize_changeset: 8
custom_css: 1
elementor_library: 8
mailpoet_page: 1
nav_menu_item: 46
page: 27
post: 6
product: 316
product_variation: 3250
revision: 2949
shop_order: 1
thegem_footer: 3
thegem_templates: 11
thegem_testimonial: 2
thegem_title: 2
tm_global_cp: 5
ux_template: 51
wpcf7_contact_form: 3
wpforms: 3
wp_global_styles: 1
yith_wcan_preset: 2 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (16)

Advanced Cron Manager: by BracketSpace – 2.5.2
Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.1
Autoptimize: by Frank Goossens (futtta) – 3.1.11
Contact Form 7: by Takayuki Miyoshi – 5.9
Easy Auto SKU Generator for WooCommerce: by Dan Zakirov – 1.2.0
Envato Market: by Envato – 2.0.11
FileBird Pro: by Ninja Team – 6.1
Jetpack: by Automattic – 13.2
MailPoet: by MailPoet – 4.45.0
Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.30
WooCommerce AJAX Products Filter: by BeRocket – 3.1.4.6
WooCommerce Square: by WooCommerce – 4.5.1
WooCommerce: by Automattic – 8.6.1
Widgets for Google Reviews: by Trustindex.io – 11.6
WP Super Cache: by Automattic – 1.12.0
Zakeke Interactive Product Designer: by Zakeke – 3.8.2 Inactive Plugins (8)

Advanced Product Fields for WooCommerce: by StudioWombat – 1.6.6
BEAF - Ultimate Before After Image Slider & Gallery: by Themefic – 4.5.5
Custom Product Tabs for WooCommerce: by Code Parrots – 1.8.5
Extra Product Options & Add-Ons for WooCommerce: by ThemeComplete – 6.3
Product Recommendation Quiz for eCommerce: by RevenueHunt – 2.2.6
Widget Options - Extended: by Widget Options Team – 5.0.1
WooSquare (Premium): by Wpexpertsio – 4.5.5
WPC Show Single Variations for WooCommerce: by WPClever – 2.3.6 Dropin Plugins (2)

advanced-cache.php: advanced-cache.php
maintenance.php: maintenance.php Settings

API Enabled: –
Force SSL: ?
Currency: AUD ($)
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 Woo.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: #5 - /store/
Cart: #330 - /cart-2/
Checkout: #331 - /checkout-2/
My account: #332 - /my-account-2/
Terms and conditions: ? Page not set Theme

Name: Flatsome
Version: 3.18.4
Author URL: https://uxthemes.com
Child Theme: ? – 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: ? 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/cart/mini-cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/order-received.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 Square

Environment: Production
Tokenization Enabled: –
Debug Mode: Off Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
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
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
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: customize-store
minified-js
new-product-management-experience
product-pre-publish-modal
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-03-13 00:04:43 +00:00
Options: ?
Notes: 132
Onboarding: completed MailPoet

Sending Method: MailPoet
Send all site's emails with: Default WordPress sending method
Task Scheduler method: Action Scheduler
Cron ping URL: https://espireclothing.com.au?mailpoet_router&endpoint=cron_daemon&action=ping Action Scheduler

Complete: 36,142
Oldest: 2024-02-10 03:13:49 +0000
Newest: 2024-03-12 03:12:11 +0000

Failed: 1,584
Oldest: 2023-04-20 04:40:04 +0000
Newest: 2024-03-05 10:00:16 +0000

Pending: 6
Oldest: 2024-03-12 03:13:53 +0000
Newest: 2024-03-13 01:02:27 +0000 Status report information

Generated at: 2024-03-12 03:14:20 +00:00
`

Hi @balinjfoley

You should not have to delete and resync each time you add a new variation. Did you try to run a?manual sync?after adding a new variation instead of deleting it? More info: https://woo.com/document/woocommerce-square/sync-settings/#section-6

Additionally, please increase your PHP Post Max Size from 128 MB to 2 GB and PHP Time Limit from 300 to 1200.

If you have followed everything and the issue persists, then the issue might be more complex and could be due to a conflict with another plugin or theme. To rule this out, could you please perform a conflict test? Here is the guide on how to do a conflict test: https://woo.com/document/how-to-test-for-conflicts/

Let us know how that goes for you.

Hi,

I’ve tried running the sync with all plugins turned off but still not syncing correctly. I can only increase my post max size is maximum 512m and I’ve also increased the run time to 1200.

In regards to syncing, I have Woo setup as the system of record using variant products that all have unique SKU’s, so this should be creating new vairents in Square once I have made them in Woo?

Is there anything else I can try to fix this? It just keeps popping up as an error “sync failed”.

?? hey @balinjfoley

Thank you for reaching back, with further details on this.

I’ve tried running the sync with all plugins turned off but still not syncing correctly.

Let’s investigate further. As a next step, make sure logging is enabled: Enable to save debug messages to the?WooCommerce?>?Status?>?Logs?page.

Once you’ve done that, you can paste the logs here or into our https://quickforget.com/ service and send that secret link here.

In regards to syncing, I have Woo setup as the system of record using variant products that all have unique SKU’s, so this should be creating new vairents in Square once I have made them in Woo?

The plugin will send updated information from WooCommerce to Square whenever you make a change to a synced product via manual edit in WooCommerce, import, or API.

Note: Square allows one category per product, so if your synced product has multiple categories or sub-categories in WooCommerce, only the first category in alphabetical order will be sent to Square without any consideration for whether it is a parent or child category.

Further details can be found in the documentation section, linked here, for your convenience.

We await your response to better assist you.

So after further testing I have got a new product to sync correctly and when adding new variants in via woo they update and appear in Square but I have over 100 products and I’m not sure why they arent doing the same thing. Bellow is the link to the logs

https://quickforget.com/s/18a28890dcdfd57a82e5ad9e39adb385e821f2095beb1d96

Thank you for reaching back, with further data on this, @balinjfoley.

While investigating the logs, it appears the majority of the products return a code: 200 (OK, in human language).

For the 10 instances returning a code: 400 (something is up, in human language), it appears:

• 9 out of 10 are due to “Item variation names may not be edited if they use item options (requested name “kids Tee”, actual name “2, Whiskey”).”
• 1 out of 10 is due to “Item variation names may not be edited if they use item options (requested name “Cycling socks – Small, Black”, actual name “Small, Black”).”

Sounds like re-creating them could solve this.

I hope this is helpful! Please let us know how it goes, and if you have any further questions or concerns.
We will be happy to help you further.

• This reply was modified 8 months, 2 weeks ago by anastas10s. Reason: typo

So by re-creating them, do you mean by deleting them in square and letting them sync into square with a manual sync?

?? hi @balinjfoley

Pretty much, yeah. Allow me to expand further. We’ve established that:

• sync is working as expected
• new products are syncing
• issue(s) discovered with products including “kids Tee”, or “Cycling socks – Small, Black”, in their item variation names

Therefore, as a next step, feel free to test with:

• deleting the affected products in Square
• retire them in WooCommerce (as they might already be in orders)
• create them anew, while making sure they comply with sync requirements
• make sure they sync with code: 200

I hope this is helpful! Please let us know if you have any further questions or concerns.
We will be happy to help you further.

Hi,

so to be clear when you say “comply with sync requirements” does that mean having a unique SKU for each varient in a variable product and how do I know exactly that it syncs with code 200?

Also when syncing into square, the ones that have worked have come up without any varient names, is there something I can adjust so that happens? Photo bellow to show what I mean.

 Item

Reporting category

Sold by

Stock

Available to sell

Price

Default vendor

 [test sync woo to square new product] Kids Honey Pot Design

Kids

ea

2

 2

$130.00/ea



 [test sync woo to square new product] Kids Honey Pot Design

ea

1

 1

$130.00/ea



 [test sync woo to square new product] Kids Honey Pot Design

ea

1

 1

$130.00/ea



 The HoneyPot Design

Hoodies

ea

7

 7

$140.00 - $170.00/ea



 The HoneyPot Design

ea

1

 1

$165.00/ea



 The HoneyPot Design

ea

1

 1

$140.00/ea



 The HoneyPot Design

ea

1

 1

$165.00/ea



 The HoneyPot Design

ea

1

 1

$170.00/ea



 The HoneyPot Design

ea

1

 1

$170.00/ea



 The HoneyPot Design

ea

1

 1

$155.00/ea



 The HoneyPot Design

Hi @balinjfoley,

so to be clear when you say “comply with sync requirements” does that mean having a unique SKU for each varient in a variable product

We were referring to the specific criteria that need to be met for successful syncing. This includes having a unique SKU for each variant in a variable product, as you correctly pointed out.

how do I know exactly that it syncs with code 200?

This is a standard HTTP status code that indicates a successful HTTP request. In the context of syncing, this means that the sync operation was successful. You can check this in the logs that you enabled earlier.

Also when syncing into square, the ones that have worked have come up without any varient names, is there something I can adjust so that happens? Photo bellow to show what I mean.

There seems to be a discrepancy between how WooCommerce and Square handle variant names. WooCommerce allows for more detailed variant names, while Square has certain limitations.

Unfortunately, there’s no workaround for this. You might need to adjust the variant names manually in Square after the sync.

I hope this clarifies your concern. If you have any other questions, feel free to ask.

Thanks for the clarification, is there a way I can check which exact products are syncing with the correct code and which ones are not? I have roughly 100 products so it will be painful to have to check them all manually.

Thanks!

Hi @balinjfoley,

To check which products are syncing with the correct code, you can refer to the logs that you enabled earlier. In these logs, each sync operation is recorded along with its status code. A status code of 200 indicates a successful sync, while other codes signal different issues.

You will need to look for lines in the log that mention the product SKU and the status code. For example, a line like “Synced product with SKU XYZ, status code: 200” would indicate that the product with SKU XYZ has been successfully synced.

While this method still involves manual checking, it’s far less time-consuming and error-prone than checking each product individually in Square or WooCommerce.

I understand that this process can be a bit tedious with a large number of products, but it’s currently the most accurate way to identify which products are having issues with syncing.

I hope this clarifies your concern. If you have any other questions, feel free to ask.

Hey there,

So I’m working through and I’ve eliminated any code 400s I’ve had related to products by deleting and re-syncing them into Square. But this last one I don’t understand which product its related to. Can you help me identify this?

2024-03-24T04:35:06+00:00 NOTICE Response Response code: 400 message: headers: Array ( [0] => HTTP/2 400 [date] => Sun, 24 Mar 2024 04:35:06 GMT [content-type] => application/json [content-length] => 146 [cf-ray] => 8693f3cf2e7da820-SYD [cf-cache-status] => DYNAMIC [content-encoding] => gzip [strict-transport-security] => max-age=631152000; includeSubDomains; preload [vary] => Origin, Accept-Encoding [square-version] => 2023-07-20 [x-content-type-options] => nosniff [x-download-options] => noopen [x-envoy-decorator-operation] => /v2/catalog/** [x-frame-options] => SAMEORIGIN [x-permitted-cross-domain-policies] => none [x-speleo-traceid] => CDN-648bf5aa-2a2a-476d-ae76-ff49a0a29793 [x-sq-dc] => aws [x-sq-region] => us-west-2 [x-xss-protection] => 1; mode=block [set-cookie] => __cf_bm=LAXNJ6.xF.GbxkRPpI2gk9WC9emYFzNqkg_LR_Csm8Q-1711254906-1.0.1.1-sd60CSo81xk.6MsFbJLjh2vdMfdFklfjedxwK.L9tKGyr0_8F7QExKUWW9nn0yubdOaujLso.iOcwmArbZslLQ; path=/; expires=Sun, 24-Mar-24 05:05:06 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None [server] => cloudflare ) body: Array ( [0] => Square\Models\Error Object ( [category:Square\Models\Error:private] => INVALID_REQUEST_ERROR [code:Square\Models\Error:private] => BAD_REQUEST [detail:Square\Models\Error:private] => Expected ItemVariation to have 3 Item Option Values, got 0 [field:Square\Models\Error:private] => ) ) CONTEXT: {“_legacy”:true} 2024-03-24T04:35:06+00:00 NOTICE Failed step cycle: update_matched_products (26.71s) – [BAD_REQUEST] Expected ItemVariation to have 3 Item Option Values, got 0 CONTEXT: {“_legacy”:true} 2024-03-24T04:35:06+00:00 NOTICE [BAD_REQUEST] Expected ItemVariation to have 3 Item Option Values, got 0 CONTEXT: {“_legacy”:true}