• Resolved debtalbot

    (@debtalbot)


    Screenshots above show the settings in WooCommerce with Square.

    WooCommerce Logs

    Woocommerce database update in progress (constantly)

    We have updated products in Square and they are not syncing into WooCommerce.

    What is the best way to manage these failed, canceled and past-due logs. Should these be deleted?

    The WooCommerce database seems to be constantly updating.

    Any ideas on what could be causing the sync issue between Square and WooCommerce? We migrated the WordPress site from EasyWP with Namecheap to their Shared hosting and that has not resolved the syncing issues.

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Saif

    (@babylon1999)

    Hello @debtalbot,

    Any ideas on what could be causing the sync issue between Square and WooCommerce? We migrated the WordPress site from EasyWP with Namecheap to their Shared hosting and that has not resolved the syncing issues.

    Thank you for sharing all these details!

    Some shared hosting providers run a script that terminates processes taking longer than a certain time (for example 60 seconds) which might stop the sync process.

    I recommend contacting NameCheap and asking them to disable those scripts temporarily. This way, you can confirm if they were causing the issue.

    If that didn’t help, then please share a copy of your site’s System Status so we can look further into this.

    You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.  Once you’ve done that, paste it here in your response or a Gist.

    It’s also worth checking if there are any error logs related to Square as highlighted in the screenshot below:


    Link to image: https://d.pr/i/qCusZB

    Let us know how it goes!

    Thread Starter debtalbot

    (@debtalbot)

    thanks you for your prompt response.

    I did contact NameCheap recently and they suggested installing the Heartbeat Control by WP Rocket plug in but that hasnt made any difference.

    Here is a copy of the System Report. I note there is a reference to

    Must Use Plugins (1)

    EasyWP Plugin: by Namecheap
    Inc. – 1.0.1.1

    I can raise this with NameCheap as we migrated from EasyWP Plugin to their Shared Hosting which was to see if it resolved the syncing issue. Not sure why there is a reference to this particular plugin if we are now using Shared Hosting.

    WordPress Environment
    
    WordPress address (URL): https://fifthelementorgonenergy.com
    Site address (URL): https://fifthelementorgonenergy.com
    WC Version: 7.5.1
    REST API Version: ✔ 7.5.1
    WC Blocks Version: ✔ 9.6.6
    Action Scheduler Version: ✔ 3.5.4
    Log Directory Writable: ✔
    WP Version: 6.2
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: ✔ Server Environment Server Info: LiteSpeed
    PHP Version: 8.0.28
    PHP Post Max Size: 2 GB
    PHP Time Limit: 1500
    PHP Max Input Vars: 10000
    cURL Version: 7.84.0
    OpenSSL/1.1.1p SUHOSIN Installed: –
    MySQL Version: 10.3.38-MariaDB-cll-lve
    Max Upload Size: 2 GB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔ Database WC Database Version: 7.4.1
    WC Database Prefix: wpvg_
    Total Database Size: 53.15MB
    Database Data Size: 41.91MB
    Database Index Size: 11.24MB
    wpvg_woocommerce_sessions: Data: 0.03MB + Index: 0.02MB + Engine InnoDB
    wpvg_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvg_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvg_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_actionscheduler_actions: Data: 2.52MB + Index: 1.70MB + Engine InnoDB
    wpvg_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_actionscheduler_logs: Data: 3.52MB + Index: 1.91MB + Engine InnoDB
    wpvg_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_ce4wp_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wpvg_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
    wpvg_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpvg_loginizer_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_mailpoet_automation_runs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wpvg_mailpoet_scheduled_tasks: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpvg_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpvg_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvg_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
    wpvg_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_options: Data: 2.17MB + Index: 0.16MB + Engine InnoDB
    wpvg_postmeta: Data: 1.50MB + Index: 0.23MB + Engine InnoDB
    wpvg_posts: Data: 3.39MB + Index: 0.06MB + Engine InnoDB
    wpvg_shortpixel_folders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_shortpixel_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_shortpixel_postmeta: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpvg_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_trp_gettext_en_us: Data: 1.52MB + Index: 1.94MB + Engine InnoDB
    wpvg_trp_gettext_original_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_trp_gettext_original_strings: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    wpvg_trp_original_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_trp_original_strings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_usermeta: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
    wpvg_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wpvg_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvg_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wpvg_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wfblockediplog: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wpvg_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_wfconfig: Data: 0.47MB + Index: 0.00MB + Engine InnoDB
    wpvg_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wffilemods: Data: 10.55MB + Index: 0.00MB + Engine InnoDB
    wpvg_wfhits: Data: 1.09MB + Index: 0.08MB + Engine InnoDB
    wpvg_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvg_wfknownfilelist: Data: 7.52MB + Index: 0.00MB + Engine InnoDB
    wpvg_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wflogins: Data: 0.41MB + Index: 0.16MB + Engine InnoDB
    wpvg_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
    wpvg_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvg_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_wfstatus: Data: 0.17MB + Index: 0.13MB + Engine InnoDB
    wpvg_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_wpmailsmtp_debug_events: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wpvg_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvg_yoast_indexable: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    wpvg_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvg_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvg_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvg_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts attachment: 106
    custom_css: 1
    et_pb_layout: 27
    language_switcher: 2
    mailpoet_page: 1
    nav_menu_item: 7
    page: 13
    post: 13
    product: 73
    revision: 121
    shop_order: 1
    wp_global_styles: 1
    wpforms: 1 Security Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔ Active Plugins (26) Akismet Anti-Spam: by Automattic – 5.1
    Better Search Replace: by WP Engine – 1.4.2
    Divi Background Plus: by BeSuperfly – 2.3
    DiviMenus: by DonDivi – 2.16.0
    Facebook for WooCommerce: by Facebook – 3.0.17
    Google Listings and Ads: by WooCommerce – 2.4.2
    Site Kit by Google: by Google – 1.96.0
    Heartbeat Control by WP Rocket: by WP Rocket – 2.0
    Hello Dolly: by Matt Mullenweg – 1.7.2
    Jetpack Boost: by Automattic - Jetpack Site Speed team – 1.7.0
    Jetpack: by Automattic – 12.0
    LiteSpeed Cache: by LiteSpeed Technologies – 5.3.3
    Really Simple SSL: by Really Simple Plugins – 6.2.3
    TranslatePress - Multilingual: by Cozmoslabs
    Razvan Mocanu
    Madalin Ungureanu
    Cristophor Hurduban – 2.5.1 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.23.3 WooCommerce Stripe Gateway: by WooCommerce – 7.2.0
    WooCommerce Payments: by Automattic – 5.7.0
    WooCommerce Shipping & Tax: by WooCommerce – 2.2.4
    WooCommerce Square: by WooCommerce – 3.7.0
    WooCommerce: by Automattic – 7.5.1
    Wordfence Security: by Wordfence – 7.9.2
    Yoast SEO: by Team Yoast – 20.4
    WP File Manager: by mndpsingh287 – 7.1.8
    WP Mail SMTP: by WPForms – 3.7.0
    Smush: by WPMU DEV – 3.12.6
    WPForms Lite: by WPForms – 1.8.1.1 Inactive Plugins (2) Loginizer: by Softaculous – 1.7.7
    MailPoet: by MailPoet – 4.11.0 Dropin Plugins (1) object-cache.php: Redis Object Cache Drop-In Must Use Plugins (1) EasyWP Plugin: by Namecheap
    Inc. – 1.0.1.1 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) 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: ✔
    Order datastore: WC_Order_Data_Store_CPT WC Pages Shop base: #5 - /shop/
    Cart: #6 - /cart/
    Checkout: #7 - /checkout/
    My account: #8 - /my-account/
    Terms and conditions: #9 - /refund_returns/ Theme Name: Divi
    Version: 4.20.2
    Author URL: http://www.elegantthemes.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: – 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
    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
    product-variation-management
    settings Daily Cron: ✔ Next scheduled: 2023-03-05 23:40:02 +09:30
    Options: ✔
    Notes: 68
    Onboarding: completed WooCommerce Payments Version: 5.7.0
    Connected to WPCOM: No
    Blog ID: -
    Account ID: - Action Scheduler Complete: 4,583
    Oldest: 2023-02-06 18:39:12 +1030
    Newest: 2023-04-02 20:26:03 +0930 Pending: 271
    Oldest: 2023-03-09 08:37:18 +1030
    Newest: 2023-04-09 20:26:03 +0930 Failed: 2,795
    Oldest: 2023-01-19 05:10:28 +1030
    Newest: 2023-03-09 08:31:42 +1030 Canceled: 12
    Oldest: -0001-11-30 09:14:20 +0914
    Newest: -0001-11-30 09:14:20 +0914 Status report information Generated at: 2023-04-08 10:08:59 +09:30
    `

    I note there is a X re the Theme, however, we have not changed any part of the theme for WooCommerce.

    Any assistance would be greatly appreciated.

    Saif

    (@babylon1999)

    Square

    Environment: Production
    Tokenization Enabled: –
    Debug Mode: Off

    I noticed Square’s debug mode is turned off, in order to get a better idea of the problem we need to see if there are any error messages in the Square logs.

    To enable debug mode, navigate to WooCommerce > Settings > Square .


    Link to image: https://d.pr/i/PLk90N

    Once it’s activated, try manually syncing the products again. This should throw an error in WooCommerce > Status > Log. The log will hopefully contain some information on what happened during the sync, please copy&past it here.

    Look forward to hearing back from you.

    Hello,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

    Thanks.

    Thread Starter debtalbot

    (@debtalbot)

    My apologies, I missed your previous response. Thanks for the email notification to prompt me.

    Ive enabled the Debug mode and this is most recent error log. Ive removed some location information for security reasons.

    It appears to be an issue with the payment received. I have confirmed with the owner that they have received the payment via Square. So I have changed the status of the payment transaction which was showing as Pending to Completed. But it still seems to be an issue. Any ideas what I need to change so that this error does not keep repeating everytime there is a scheduled sync?

    Hello,

    You can update your WooCommerce and database versions as explained here:

    https://woocommerce.com/document/how-to-update-woocommerce/

    Once update them, check if that resolves the issue, if not, you can perform the sync again to see if it works as expected. Also, You can switch the site theme to Storefront temporarily, and then disable all plugins except WooCommerce and Square for WooCommerce? Check again to see if the issue persists after running a sync, if not, it means there is a conflict, and you can then switch back your theme to the original one, and then reactivate the rest of the plugins one by one (checking again after each plugin reactivation), until you find the culprit.

    You can find a more detailed explanation on how to do a conflict test here.

    If that does not make a difference, please provide us the error logs in text format. Feel free to redact any sensitive information you would not like to share in public.

    Thanks.

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

The topic ‘Woocommerce and Square sync issues’ is closed to new replies.