Sync not Working
-
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!
-
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.
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
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!
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-fipsSUHOSIN 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.1WP 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-ordersAccount 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 +0000Complete: 5,362
Oldest: 2021-12-17 02:00:09 +0000
Newest: 2022-01-17 00:31:02 +0000Failed: 224
Oldest: 2020-06-09 23:02:04 +0100
Newest: 2021-12-30 03:00:05 +0000In-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
- This reply was modified 2 years, 10 months ago by chariotsofthyer.
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.
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
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!
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
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.
- The topic ‘Sync not Working’ is closed to new replies.