• Resolved chariotsofthyer

    (@chariotsofthyer)


    Hi,

    I recently re-installed the Square plugin to have another attempt at using the product sync to make it easier for me to process my orders in person.

    Sadly, I am still experiencing issues with the sync. I have Woocommerce set as the system of record and I have enabled the inventory sync as well but the syncs stuck in a loop.

    I disconnected and re-connected Square again and got the error to do with category mappings but found a fix for that and have no overcome it. I can see that since trying to sync again the categories have come through but not any products and on woocommerce the sync is in an endless cycle.

    Please help me, this feature would be amazing if I can get it to work!

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hi @chariotsofthyer,

    Thanks for reaching out to WooCommerce Square support!

    I understand that the products are not being synced from your WooCommerce store to your Square account. You mentioned that the categories have been synced, is that correct?

    I’d recommend going over this doc Sync Issues and check if everything is setup correctly on your site.

    Looking forward to hearing back from you.

    Thread Starter chariotsofthyer

    (@chariotsofthyer)

    Hi @nagdy

    Thank you for your response. I can confirm that it is all setup correctly as per the guide.

    I completely wiped all items and categories from my Square account so that I could start fresh and after the “sync” had been running for about 2 days the only thing that is now showing is the categories but no products.

    Thanks

    Plugin Support Chris M. – a11n

    (@csmcneill)

    Hi again @chariotsofthyer,

    Thank you for your response. I can confirm that it is all setup correctly as per the guide.

    Thanks for confirming that!

    Have you checked with your host to ensure that background processing is enabled? Additionally, are SKUs set for all products?

    Lastly, could you please share a copy of your site’s System Status? 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.

    Looking forward to hearing from you!

    Thread Starter chariotsofthyer

    (@chariotsofthyer)

    Hello,

    From running the tests on wordpress themselves and from what I have read background processing is enabled for my site. I also have a unique SKU for every single product.

    ### WordPress Environment ###

    WordPress address (URL): https://www.bathtcg.co.uk
    Site address (URL): https://www.bathtcg.co.uk
    WC Version: 6.1.0
    REST API Version: ? 6.1.0
    WC Blocks Version: ? 6.7.1
    Action Scheduler Version: ? 3.4.0
    WC Admin Version: ? 3.0.3
    Log Directory Writable: ?
    WP Version: 5.8.3
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: –
    Language: en_GB
    External object cache: –

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 7.4.27
    PHP Post Max Size: 256 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 3000
    cURL Version: 7.66.0
    OpenSSL/1.1.1l-fips

    SUHOSIN Installed: –
    MySQL Version: 5.7.32-35-log
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 6.1.0
    WC Database Prefix: wp_
    Total Database Size: 385.75MB
    Database Data Size: 316.05MB
    Database Index Size: 69.70MB
    wp_woocommerce_sessions: Data: 3.02MB + Index: 0.06MB + 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: 1.52MB + Index: 0.22MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 7.52MB + Index: 6.03MB + 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.05MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 2.08MB + Index: 1.92MB + 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: 2.28MB + Index: 1.86MB + Engine InnoDB
    wp_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_campaigns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_referralmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_referrals: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_sales: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_visits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_atum_export_templates: Data: 0.16MB + Index: 0.03MB + Engine InnoDB
    wp_atum_inventories: Data: 0.17MB + Index: 0.17MB + Engine InnoDB
    wp_atum_inventory_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_atum_inventory_locations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_atum_inventory_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_atum_inventory_orders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_atum_inventory_regions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_atum_inventory_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_atum_product_data: Data: 0.17MB + Index: 0.06MB + Engine InnoDB
    wp_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 6.52MB + Index: 7.05MB + Engine InnoDB
    wp_ebay_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ebay_auctions: Data: 4.52MB + Index: 0.17MB + Engine InnoDB
    wp_ebay_categories: Data: 1.52MB + Index: 2.03MB + Engine InnoDB
    wp_ebay_jobs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_ebay_log: Data: 0.22MB + Index: 0.05MB + Engine InnoDB
    wp_ebay_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ebay_orders: Data: 5.52MB + Index: 0.03MB + Engine InnoDB
    wp_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ebay_profiles: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_ebay_shipping: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_ebay_sites: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_ebay_stocks_log: Data: 2.02MB + Index: 0.00MB + Engine InnoDB
    wp_ebay_store_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ebay_transactions: Data: 4.52MB + Index: 0.05MB + Engine InnoDB
    wp_edd_wallet: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_evf_entries: Data: 0.17MB + Index: 0.02MB + Engine InnoDB
    wp_evf_entrymeta: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
    wp_evf_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
    wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_followup_coupon_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_followup_customers: Data: 0.13MB + Index: 0.22MB + Engine InnoDB
    wp_followup_customer_carts: Data: 0.50MB + Index: 0.11MB + Engine InnoDB
    wp_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_followup_customer_orders: Data: 0.20MB + Index: 0.09MB + Engine InnoDB
    wp_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_followup_email_logs: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    wp_followup_email_orders: Data: 1.52MB + Index: 0.19MB + Engine InnoDB
    wp_followup_email_tracking: Data: 0.06MB + Index: 0.08MB + Engine InnoDB
    wp_followup_followup_history: Data: 0.22MB + Index: 0.05MB + Engine InnoDB
    wp_followup_order_categories: Data: 0.22MB + Index: 0.22MB + Engine InnoDB
    wp_followup_order_items: Data: 0.30MB + Index: 0.38MB + Engine InnoDB
    wp_followup_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
    wp_gla_merchant_issues: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
    wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_lmfwc_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_lmfwc_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_lmfwc_licenses: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_lmfwc_licenses_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailchimp_carts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_mailchimp_jobs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 11.33MB + Index: 1.45MB + Engine InnoDB
    wp_postmeta: Data: 39.56MB + Index: 24.06MB + Engine InnoDB
    wp_posts: Data: 6.52MB + Index: 1.17MB + Engine InnoDB
    wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_analytics_adsense: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_analytics_ga: Data: 0.47MB + Index: 0.33MB + Engine InnoDB
    wp_rank_math_analytics_gsc: Data: 1.52MB + Index: 2.34MB + Engine InnoDB
    wp_rank_math_analytics_keyword_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_analytics_objects: Data: 0.22MB + Index: 0.08MB + Engine InnoDB
    wp_rank_math_internal_links: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_redirections: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_redirections_cache: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_slides: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 1.52MB + Index: 0.64MB + Engine InnoDB
    wp_terms: Data: 0.25MB + Index: 0.22MB + Engine InnoDB
    wp_term_relationships: Data: 1.52MB + Index: 0.48MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.27MB + Index: 0.27MB + Engine InnoDB
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ups_shipping_accessorial: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_account: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_config: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_delivery_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_fallback_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_license: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_logs_api: Data: 137.61MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_log_frontend: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_package_default: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_retry_api: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_services: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_shipments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ups_shipping_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_usermeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
    wp_users: Data: 0.20MB + Index: 0.17MB + Engine InnoDB
    wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcsn_activations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcsn_serial_numbers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.28MB + Index: 0.19MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.55MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.45MB + Index: 0.33MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    wp_wc_points_rewards_user_points: Data: 0.17MB + Index: 0.17MB + Engine InnoDB
    wp_wc_points_rewards_user_points_log: Data: 0.39MB + Index: 0.33MB + Engine InnoDB
    wp_wc_point_of_sale_sale_reports: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_wc_pos_grid_tiles: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.14MB + Index: 0.30MB + 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_wfblockediplog: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfconfig: Data: 1.48MB + Index: 0.00MB + Engine InnoDB
    wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilemods: Data: 12.55MB + Index: 0.00MB + Engine InnoDB
    wp_wfhits: Data: 1.02MB + Index: 1.16MB + Engine InnoDB
    wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfknownfilelist: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wflogins: Data: 0.45MB + Index: 0.13MB + Engine InnoDB
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_exported_csv_items: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_gpf_google_taxonomy: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_software_activations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_software_licenses: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpf_filters: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wpf_meta_data: Data: 0.44MB + Index: 0.83MB + Engine InnoDB
    wp_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpf_meta_values: Data: 0.02MB + Index: 0.59MB + Engine InnoDB
    wp_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_emails_log: Data: 1.52MB + Index: 0.16MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpr_rucss_resources: Data: 6.48MB + Index: 0.11MB + Engine InnoDB
    wp_wpr_rucss_used_css: Data: 21.50MB + Index: 0.05MB + Engine InnoDB
    wp_wps_hit: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    wp_wps_index: Data: 3.52MB + Index: 4.55MB + Engine InnoDB
    wp_wps_key: Data: 0.23MB + Index: 0.14MB + Engine InnoDB
    wp_wps_object_term: Data: 1.52MB + Index: 1.48MB + Engine InnoDB
    wp_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wps_uri: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wtbp_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_pos_register_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcaf_affiliates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcaf_clicks: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcaf_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcaf_commission_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcaf_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcaf_payment_commission: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcaf_payment_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcan_filter_sessions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yith_ywrac_email_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_prominent_words: Data: 0.16MB + Index: 0.14MB + Engine InnoDB

    ### Post Type Counts ###

    amn_mi-lite: 1
    amn_wpforms-lite: 1
    attachment: 1875
    atum_inventory_log: 1
    atum_supplier: 4
    br_labels: 2
    custom_css: 6
    cwginstocknotifier: 1517
    e-landing-page: 1
    elementor_library: 13
    everest_form: 1
    follow_up_email: 17
    hf_shop_subscription: 1
    jet-smart-filters: 1
    jetpack_migration: 2
    jp_img_sitemap: 2
    jp_img_sitemap_index: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    mc4wp-form: 1
    nav_menu_item: 19
    oembed_cache: 87
    page: 24
    pos_outlet: 1
    pos_receipt: 1
    pos_register: 1
    pos_session: 16
    pos_temp_order: 5
    post: 46
    product: 1042
    product_variation: 29
    revision: 506
    shop_coupon: 19
    shop_order: 3855
    shop_order_refund: 243
    shop_subscription: 25
    ticket-meta-fieldset: 2
    tribe_events: 5
    tribe_organizer: 1
    tribe_rsvp_tickets: 1
    tribe_venue: 1
    wc_order_email: 1
    wc_order_status: 9
    wc_zapier_feed: 1
    wcpf_item: 5
    wcpf_project: 1
    wcps: 1
    wcs_ruleset: 7
    wcsn_notification: 1
    wpforms: 1
    yith_wcan_preset: 1
    yith-pos-receipt: 1
    yith-pos-register: 1
    yith-pos-store: 1
    yith-wcbm-badge: 2
    yith-wcdppm-rule: 2
    ywdpd_discount: 2

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (56) ###

    FiboSearch – AJAX Search for WooCommerce: by FiboSearch Team – 1.15.0
    ATUM Export Pro: by Stock Management Labs? – 1.3.9
    ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.9.9
    PublishPress Capabilities: by PublishPress – 2.3.3
    Conditional Shipping for WooCommerce: by Lauri Karisola / WooElements.com – 2.2.3
    Elementor Pro: by Elementor.com – 3.5.2
    Elementor: by Elementor.com – 3.5.3
    Everest Forms: by WPEverest – 1.8.2.3
    Facebook for WooCommerce: by Facebook – 2.6.9
    Google Listings and Ads: by WooCommerce – 1.10.0
    Health Check & Troubleshooting: by The www.ads-software.com community – 1.4.5
    Jetpack: by Automattic – 10.5
    License Manager for WooCommerce: by wpexpertsio – 2.2.5
    Mailchimp for WooCommerce: by Mailchimp – 2.5.4
    Perfect Brands for WooCommerce: by QuadLayers – 2.0.3
    Perfmatters: by forgemedia – 1.8.4
    Rank Math SEO PRO: by Rank Math – 3.0.1
    Rank Math SEO: by Rank Math – 1.0.80
    Theme Customisations: by WooThemes – 1.0.0
    Trustpilot-reviews: by Trustpilot – 2.5.888
    Fix for Square Version Mismatch: by John Coy – 0.1.0
    Ajax add to cart for WooCommerce: by QuadLayers – 1.2.7
    WooCommerce Blocks: by Automattic – 6.7.1
    Advanced Order Export For WooCommerce: by AlgolPlus – 3.2.2
    Product Filter by WooBeWoo: by WooBeWoo – 2.0.5
    Woocommerce Sidebar Category Accordion: by Marc Randall – 1.1.3
    WooCommerce Account Funds: by Themesquad – 2.6.1
    WooCommerce Checkout Field Editor: by WooCommerce – 1.7.0
    WooCommerce Conditional Shipping and Payments: by WooCommerce – 1.11.0
    WooCommerce Cost of Goods: by SkyVerge – 2.11.0
    WooCommerce Email Validation: by Hugh Lashbrooke – 2.1.1
    Follow-Up Emails: by WooCommerce – 4.9.16 (update to version 4.9.17 is available)
    WooCommerce Stripe Gateway: by WooCommerce – 6.0.0
    WooCommerce Min/Max Quantities: by WooCommerce – 2.4.24
    WooCommerce MSRP Pricing: by Ademti Software Ltd. – 3.4.3
    WooCommerce Order Status Control: by SkyVerge – 1.14.0
    WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.11.4
    Point of Sale for WooCommerce: by Actuality Extensions – 5.5.3 (update to version 5.5.4 is available)
    WooCommerce Points and Rewards: by WooCommerce – 1.7.4 (update to version 1.7.5 is available)
    WooCommerce Pre-Orders: by WooCommerce – 1.5.30
    PPOM for WooCommerce by N-MEDIA: by Najeeb Ahmad – 24.1
    WooCommerce Royal Mail: by WooCommerce – 2.5.39
    WooCommerce Square: by WooCommerce – 2.7.0
    WooCommerce Store Credit: by Themesquad – 3.9.4
    WooCommerce Subscriptions: by WooCommerce – 3.1.6
    WooCommerce Waitlist: by Neil Pie – 2.3.2
    WooCommerce Xero Integration: by WooCommerce – 1.7.40
    WooCommerce: by Automattic – 6.1.0
    Woo Product Filter PRO: by WooBeWoo – 2.0.5
    Wordfence Security: by Wordfence – 7.5.7
    WP Crontrol: by John Blackbourn & contributors – 1.12.0
    WP-Lister Pro for eBay: by WP Lab – 3.1.4
    WP Mail SMTP Pro: by WPForms – 3.2.0
    WP-Optimize Premium – Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.2.1

    WP Rocket: by WP Media – 3.10.6
    YITH WooCommerce Affiliates Premium: by YITH – 1.8.5

    ### Inactive Plugins (0) ###

    ### Dropin Plugins (1) ###

    advanced-cache.php: advanced-cache.php

    ### Must Use Plugins (2) ###

    Health Check Troubleshooting Mode: by – 1.7.2
    Perfmatters MU: by forgemedia – 1.8.4

    ### 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)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)

    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)
    yith_pos (yith_pos)

    Connected to WooCommerce.com: ?

    ### WC Pages ###

    Shop base: #11965 – /shop/
    Basket: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
    Checkout: #15 – /checkout/
    My account: #16 – /my-account/
    Terms and conditions: #329 – /terms-and-conditions/

    ### Theme ###

    Name:
    Version: (update to version 0 is available)
    Author URL:
    Child Theme: ?
    Parent Theme Name:
    Parent Theme Version: – 0 is available
    Parent Theme Author URL:
    WooCommerce Support: ?

    ### Templates ###

    Overrides: –

    ### Store Setup ###

    Country / State: United Kingdom (UK)

    ### Subscriptions by Payment Gateway ###

    Stripe: wc-cancelled: 10
    wc-on-hold: 15

    ### Payment Gateway Support ###

    Stripe: products
    refunds
    tokenization
    add_payment_method
    subscriptions
    subscription_cancellation
    subscription_suspension
    subscription_reactivation
    subscription_amount_changes
    subscription_date_changes
    subscription_payment_method_change
    subscription_payment_method_change_customer
    subscription_payment_method_change_admin
    multiple_subscriptions
    pre-orders

    Account Funds: products
    refunds
    subscriptions
    subscription_cancellation
    subscription_reactivation
    subscription_suspension
    subscription_amount_changes
    subscription_date_changes
    subscription_payment_method_change
    subscription_payment_method_change_customer
    subscription_payment_method_change_admin

    ### Action Scheduler ###

    Canceled: 119
    Oldest: 2021-12-20 14:30:04 +0000
    Newest: 2022-01-17 00:38:58 +0000

    Complete: 5,362
    Oldest: 2021-12-17 02:00:09 +0000
    Newest: 2022-01-17 00:31:02 +0000

    Failed: 224
    Oldest: 2020-06-09 23:02:04 +0100
    Newest: 2021-12-30 03:00:05 +0000

    In-progress: 2
    Oldest: –
    Newest: –

    Pending: 219
    Oldest: -0001-11-29 23:58:45 -0001
    Newest: 2022-01-24 00:15:06 +0000

    ### Account Funds ###

    Partial funds payment: ?
    Enabled My Account Top-up: ?
    Minimum Top-up: 10
    Maximum Top-up: –
    Give discount: ?
    Discount type: fixed
    Discount amount: –

    ### Status report information ###

    Generated at: 2022-01-17 00:39:23 +00:00

    My system report is above for you.

    Thanks

    Plugin Support wpnomad a11n

    (@wpnomad)

    Hi @chariotsofthyer ,

    Thanks for sharing the status report. In the status report, I see that Cron is not enabled on your site, please see: https://d.pr/i/xWSh9p

    Cron is required to automatically initiate background sync on the site, can you please check with your web host and get WP Cron enabled?

    Also, when you reach out to your web host, please confirm with them if background processing is enabled on your server.

    If cron and background processing are both enabled, but the sync still fails, then I recommend conducting a conflict test on the site per the steps here: https://docs.woocommerce.com/document/woocommerce-self-service-guide/#section-4

    Do let us know how that goes and if you need any further help from us.

    Thread Starter chariotsofthyer

    (@chariotsofthyer)

    Hi,

    Cron is enable externally as it was recommended by my host and many different people as a way of improving the performance of the site.

    My host has confirmed that background processing is enabled on my server.

    I did have some success last night with a sync after wiping everything and starting fresh but I was missing a number of products and categories. I then wiped again and now I am only getting categories through.

    I will run a conflict test and have already experimented with disabling wordfence etc but no changes to the sync after doing this.

    Thanks

    Plugin Support 3 Sons Development – a11n

    (@3sonsdevelopment)

    Hey @chariotsofthyer,

    Thank you for all the testing that you’ve done so far. At this point, it would be helpful to have you open up a ticket at WooCommerce.com. We’ll likely need to log into the site and that can be handled securely with a ticket.

    https://woocommerce.com/my-account/create-a-ticket/

    Please include a URL to this thread in your ticket too.

    Thanks!

    Thread Starter chariotsofthyer

    (@chariotsofthyer)

    Hi,

    I have managed to get the sync to work, just ended up adding smaller batches of products at a time.

    I am having some other issues with inventory syncs between square, woo and ebay but feel that would be for another post after I have monitored it for a while.

    Thanks,

    Ben

    Plugin Support nicw.a11n

    (@nicw)

    Hi @chariotsofthyer

    It’s great to hear you have managed to get the sync to work by reducing the size of the sync batch.

    We’ll be happy to assist on your other issues once you have more information logged. You’d be welcome to contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

    In the meantime, I am going to mark this thread as resolved.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Sync not Working’ is closed to new replies.