• Resolved carboxyalic

    (@raheemmurtaza)


    Im trying to sync my woo commerce inventory to my square account and it keeps failing. Debug file shows the following error:

    07-05-2022 @ 09:22:20 - Request
     Request
    method:
    uri: batchUpsertCatalogObjects
    user-agent: WooCommerce-Square/3.1.0 (WooCommerce/6.6.1; WordPress/6.0)
    headers: Array
    (
    )
    body:
    duration: 7.49202s
    
    07-05-2022 @ 09:22:20 - Response
     Response
    code: 400
    message:
    headers: Array
    (
        [0] => HTTP/1.1 400 Bad Request
        [Content-Encoding] => gzip
        [Content-Type] => application/json
        [Square-Version] => 2021-10-20
        [Vary] => Origin, Accept-Encoding
        [X-Content-Type-Options] => nosniff
        [X-Download-Options] => noopen
        [X-Frame-Options] => SAMEORIGIN
        [X-Permitted-Cross-Domain-Policies] => none
        [X-Speleo-Traceid] => JGjSNPCehJhAT
        [X-Xss-Protection] => 1; mode=block
        [Date] => Tue, 05 Jul 2022 15:22:20 GMT
        [Content-Length] => 159
        [X-Sq-Dc] => sjc2b
        [X-Sq-Region] => sjc2b
        [Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
    )
    body: Array
    (
        [0] => Square\Models\Error Object
            (
                [category:Square\Models\Error:private] => INVALID_REQUEST_ERROR
                [code:Square\Models\Error:private] => VERSION_MISMATCH
                [detail:Square\Models\Error:private] => Object version does not match latest database version.
                [field:Square\Models\Error:private] => version
            )
    
    )
    
    07-05-2022 @ 09:22:20 - Failed step cycle: update_matched_products (47.32s) -

    I’ve also tried deleting the wc_square_category_map from the database but the problem persist!!!

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hey @raheemmurtaza

    To get a better understanding of your site setup can you provide us with the System Status: You can find it via WooCommerce > Status. Select ‘Get system report’ and then ‘Copy for support’. Once you do this, you can paste your response here.

    Thread Starter carboxyalic

    (@raheemmurtaza)

    Hi @danndumia , here’s the report:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://knotjustyarn.com
    Site address (URL): https://knotjustyarn.com
    WC Version: 6.6.1
    REST API Version: ✔ 6.6.1
    WC Blocks Version: ✔ 7.6.2
    Action Scheduler Version: ✔ 3.4.0
    Log Directory Writable: ✔
    WP Version: 6.0
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.25 (Debian)
    PHP Version: 7.3.33-4+0~20220627.98+debian9~1.gbp40b3e4
    PHP Post Max Size: 10 MB
    PHP Time Limit: 60
    PHP Max Input Vars: 2500
    cURL Version: 7.52.1
    OpenSSL/1.0.2u
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.1.48-MariaDB-1~stretch
    Max Upload Size: 10 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.6.1
    WC Database Prefix: wp_
    Total Database Size: 282.77MB
    Database Data Size: 186.05MB
    Database Index Size: 96.72MB
    wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.50MB + Index: 0.41MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 23.55MB + Index: 22.05MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 46.58MB + Index: 23.06MB + Engine InnoDB
    wp_amwscp_amazon_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_amwscp_amazon_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_amwscp_amazon_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_amwscp_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_amwscp_feed_product_record: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
    wp_amwscp_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_amwscp_template_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_bv_fw_requests: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_bv_ip_store: Data: 0.17MB + Index: 0.11MB + Engine InnoDB
    wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 1.31MB + Index: 0.36MB + Engine InnoDB
    wp_ddp_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fsmpt_email_logs: Data: 3.02MB + Index: 0.00MB + Engine InnoDB
    wp_inventory_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_inventory_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_inventory_terms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 29.20MB + Index: 8.03MB + Engine InnoDB
    wp_postmeta: Data: 46.56MB + Index: 27.70MB + Engine InnoDB
    wp_posts: Data: 7.47MB + Index: 3.39MB + Engine InnoDB
    wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_redirection_items: Data: 0.11MB + Index: 0.16MB + Engine InnoDB
    wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_termmeta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.23MB + Index: 0.13MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 1.09MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 1.52MB + Index: 1.61MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_square_customers: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_indexable: Data: 15.44MB + Index: 6.47MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 2.27MB + Index: 1.91MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    acf-field: 33
    acf-field-group: 4
    attachment: 7409
    flamingo_contact: 15
    flamingo_inbound: 1
    nav_menu_item: 22
    page: 16
    post: 11
    product: 779
    product_variation: 5055
    revision: 633
    shop_coupon: 18
    shop_order: 534
    shop_order_refund: 44
    tribe_events: 497
    tribe_organizer: 2
    tribe_venue: 2
    wc_stamps_label: 150
    wp_global_styles: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (22) ###
    
    Advanced Custom Fields PRO: by Delicious Brains – 5.12.2
    Breeze: by Cloudways – 2.0.6
    Delivery Fees for WooCommerce: by Devio Digital – 1.5.1
    The Events Calendar PRO: by The Events Calendar – 5.14.2.1
    Facebook for WooCommerce: by Facebook – 2.6.16
    FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.1.1
    Jetpack: by Automattic – 11.0
    Klaviyo: by Klaviyo
    Inc. – 3.0.3
    
    MalCare WordPress Security Plugin - Malware Scanner, Cleaner, Security Firewall: by MalCare Security – 4.78
    Pinterest for WooCommerce: by WooCommerce – 1.2.1
    WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 3.0.2
    Redirection: by John Godley – 5.2.3
    The Events Calendar: by The Events Calendar – 5.16.1.1
    CTX Feed: by WebAppick – 4.4.68
    WooCommerce PayPal Payments: by WooCommerce – 1.9.0
    WooCommerce Shipping & Tax: by WooCommerce – 1.26.1 (update to version 1.26.2 is available)
    WooCommerce Stamps.com API integration: by WooCommerce – 1.3.26
    WooCommerce Square: by WooCommerce – 3.1.0
    WooCommerce: by Automattic – 6.6.1
    Yoast SEO: by Team Yoast – 19.2
    WP File Manager: by mndpsingh287 – 7.1.5
    WP Last Modified Info: by Sayan Datta – 1.8.3
    
    ### Inactive Plugins (4) ###
    
    Checkout Field Editor for WooCommerce: by ThemeHigh – 1.6.1
    Fix for Square Version Mismatch: by John Coy – 0.1.0
    Flexible Shipping: by WP Desk – 4.11.9
    Regenerate product lookup table for WooCommerce: by Suman Bhattarai – 1.0.2
    
    ### 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: ✔
    Enforce Approved Product Download Directories: –
    
    ### WC Pages ###
    
    Shop base: #31 - /shop/
    Cart: #32 - /cart/
    Checkout: #33 - /checkout/
    My account: #34 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: storefront child theme
    Version: 1.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Storefront
    Parent Theme Version: 4.1.0 – 4.1.1 is available
    Parent Theme Author URL: https://woocommerce.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ✔
    Shop country code: US
    WooCommerce currency supported: ✔
    PayPal card processing available in country: ✔
    Pay Later messaging available in country: ✔
    Webhook status: –
    Vault enabled: ✔
    Logging enabled: –
    Reference Transactions: –
    Used PayPal Checkout plugin: –
    
    ### 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
    homescreen
    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
    wc-pay-promotion
    wc-pay-welcome-page
    wc-pay-subscriptions-page
    
    Disabled Features: minified-js
    settings
    
    Daily Cron: ✔ Next scheduled: 2022-07-05 20:14:07 -06:00
    Options: ✔
    Notes: 73
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Canceled: 72
    Oldest: 2022-06-24 07:28:06 -0600
    Newest: 2022-07-04 09:05:03 -0600
    
    Complete: 56,530
    Oldest: 2022-06-24 06:46:39 -0600
    Newest: 2022-07-05 13:38:14 -0600
    
    Failed: 8,439
    Oldest: 2021-11-17 16:47:35 -0700
    Newest: 2022-06-24 08:39:48 -0600
    
    Pending: 11
    Oldest: 2022-07-05 13:47:14 -0600
    Newest: 2022-07-11 10:04:08 -0600
    
    ### Status report information ###
    
    Generated at: 2022-07-05 13:47:24 -06:00
    
    • This reply was modified 3 years, 9 months ago by carboxyalic.

    Hello,

    Can you please check this thread:
    https://wordpress.org/support/topic/version_mismatch-when-syncing/

    Does the solution presented on there work for you? Before making any change be sure to back up your site.

    Let us know how it goes.

    Thread Starter carboxyalic

    (@raheemmurtaza)

    Hi @ihereira , i’ve already tried this approach and the problem persist.

    Thread Starter carboxyalic

    (@raheemmurtaza)

    Manual sync fails after reaching 34%

    Plugin Support Tamirat B. (a11n)

    (@tamirat22)

    Hello @raheemmurtaza!

    Thanks for getting back to us!

    To better help you with this issue, please open a ticket with us and include a link to this thread.

    You can open a ticket at: https://woocommerce.com/my-account/create-a-ticket/

    Thanks!

    Thread Starter carboxyalic

    (@raheemmurtaza)

    Okay

    Thread Starter carboxyalic

    (@raheemmurtaza)

    Any idea about this following error? :

    07-06-2022 @ 07:21:01 - Request
     Request
    method:
    uri: batchUpsertCatalogObjects
    user-agent: WooCommerce-Square/3.1.0 (WooCommerce/6.6.1; WordPress/6.0)
    headers: Array
    (
    )
    body:
    duration: s
    
    07-06-2022 @ 07:21:01 - Response
     Response
    code:
    message:
    headers:
    body:
    
    07-06-2022 @ 07:21:01 - Failed step cycle: update_matched_products (93.36s) - Operation timed out after 60000 milliseconds with 0 bytes received
    07-06-2022 @ 07:21:01 - Operation timed out after 60000 milliseconds with 0 bytes received

    Hi @raheemmurtaza

    Thanks for the update.

    Operation timed out after 60000 milliseconds error indicates shortage of time allotted. It is due to the following parameter on your site:

    PHP Time Limit: 60

    This is the amount of time in seconds that your site spends on a single operation before timing out. We recommend increasing it to around 1200. You may need to ask your hosts to make this change for you. You can read more on this here.

    I hope this helps!

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

The topic ‘Square Syncing Version Mismatch’ is closed to new replies.