MailChimp for WooCommerce - Won't Sync

[jessiebrown]

• User meets all of our min system requirements
• 0 products and 0 orders sync
• Changing themes and disabling other installed plugins does not resolve
• Resync button disappears. Please feel free to also add cases where the resync button does not disappear, and please indicate which situation applies

Example System Report: original-system-report.txt

[michaelrimbach]

same here

[khungate-zz]

@michaelrimbach did the sync eventually start/finish? If not, can you confirm you have the latest version of the plugin and provide a Woo system status report?

[johnschneider89]

Same here. It's as if the sync never starts. It remains at 0/xxx for both Products and Orders

[khungate-zz]

@johnschneider89 did the sync eventually start/finish? sometimes it takes a few page loads on the site itself to trigger. If not, can you confirm you have the latest version of the plugin and provide a Woo system status report?

[khungate-zz]

Hi, @michaelrimbach @johnschneider89 we've been working on an updated version of the plugin that changes the processing behavior of the queue on initial install.

We like what we see with our internal testing but would like to have a few folks try things out before moving to our production build. Would either of you all be interested in giving it a go? This plugin is a beta version, so please take necessary precautions when testing.

[michaelrimbach]

@khungate no, thanks. We are using the plugin from mc4wp.com and it's working fine.

[kokomomtl]

We are having the same issue. It never syncs. Would be open to testing the beta version if available

[khungate-zz]

Sorry to hear that @kokomomtl, you're welcome to try the queue branch we've been working on. If that doesn't solve the issue, there is a more technical option using WP-CLI that we can also try.

[kokomomtl]

Thank-you @khungate, the queue version solved this issue.

[kokomomtl]

Actually it seems to have stopped after 3 orders, with the following error in the debug:

2018-01-27T03:50:34+00:00 ERROR order_submit.error :: addStoreOrder :: SG-7633 ::

: Required fields were not provided: lines

on 1310 in /home/111331.cloudwaysapps.com/wpjvtqzayh/public_html/wp-content/plugins/mc-woocommerce-queue/includes/api/class-mailchimp-api.php

[khungate-zz]

@kokomomtl did the sync stop altogether or is it still processing? That error just means that the order did not have any line items on it to submit.

[kokomomtl]

You are right. It was slow but it ended up completing

[khungate-zz]

Ok great! Yes, it's not always a super fast process because of how the native WP queue system works. Also, if you have a store with a good amount of products or orders (or both), that can add time to the sync process. Just out of curiosity how many products/orders did you have?

You'll want to switch to our master plugin version in a future release. I'll be glad to ping you back when it's ready.

[kokomomtl]

5 products / 10 orders. Took about an hour.

[khungate-zz]

@kokomomtl appreciate you providing that information and it's definitely not the speed we're looking for - it should've only taken a few seconds with that many products/orders.

If you're able, please post a system report from your Woo install (Status > Get System Report). I'd like to see if there's anything jumping out that could've caused the slowdown.

[kokomomtl]

Here it is:

`

WordPress Environment

Home URL: https://staging.noasleep.com Site URL: https://staging.noasleep.com WC Version: 3.2.6 Log Directory Writable: ✔ WP Version: 4.9.2 WP Multisite: ✔ WP Memory Limit: 700 MB WP Debug Mode: ✔ WP Cron: ✔ Language: en_US

Server Environment

Server Info: Apache/2.4.10 (Debian) PHP Version: 7.0.27-1~dotdeb+8.1 PHP Post Max Size: 10 MB PHP Time Limit: 60 PHP Max Input Vars: 5000 cURL Version: 7.38.0 OpenSSL/1.0.1t

SUHOSIN Installed: – Max Upload Size: 1 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔

Database

WC Database Version: 3.2.6 WC Database Prefix: wpa37abbae2a MaxMind GeoIP Database: ✔ Total Database Size: 72.89MB Database Data Size: 54.29MB Database Index Size: 18.60MB wp_a37abbae2a_woocommerce_sessions: Data: 0.17MB + Index: 0.02MB wp_a37abbae2a_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB wp_a37abbae2a_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_woocommerce_log: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_ac_abandoned_cart_history_lite: Data: 0.13MB + Index: 0.00MB wp_a37abbae2a_27_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_commentmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_27_comments: Data: 0.14MB + Index: 0.09MB wp_a37abbae2a_27_duplicator_packages: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_icl_string_pages: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_icl_string_urls: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_mw_wc_qbo_sync_customer_pairs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_log: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_paymentmethod_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_payment_id_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_product_pairs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_promo_code_product_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_qbo_customers: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_qbo_items: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_real_time_sync_history: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_real_time_sync_queue: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_shipping_product_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_tax_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_variation_pairs: Data: 0.00MB + Index: 0.00MB wp_a37abbae2a_27_mw_wc_qbo_sync_wq_cf_map: Data: 0.00MB + Index: 0.00MB wp_a37abbae2a_27_options: Data: 1.42MB + Index: 0.08MB wp_a37abbae2a_27_postmeta: Data: 1.52MB + Index: 0.52MB wp_a37abbae2a_27_posts: Data: 1.52MB + Index: 0.06MB wp_a37abbae2a_27_revslider_css: Data: 0.13MB + Index: 0.00MB wp_a37abbae2a_27_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_revslider_navigations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_revslider_sliders: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_revslider_slides: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_revslider_static_slides: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_snp_log: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_snp_stats: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_27_termmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_27_terms: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_27_term_relationships: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_term_taxonomy: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_27_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_27_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_27_woocommerce_log: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_woocommerce_order_itemmeta: Data: 0.09MB + Index: 0.09MB wp_a37abbae2a_27_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_27_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_27_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_27_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB wp_a37abbae2a_27_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_27_yoast_seo_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_27_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_commentmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_28_comments: Data: 0.02MB + Index: 0.09MB wp_a37abbae2a_28_duplicator_packages: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_icl_string_pages: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_icl_string_urls: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_options: Data: 1.52MB + Index: 0.05MB wp_a37abbae2a_28_postmeta: Data: 0.23MB + Index: 0.17MB wp_a37abbae2a_28_posts: Data: 3.52MB + Index: 0.06MB wp_a37abbae2a_28_revslider_css: Data: 0.13MB + Index: 0.00MB wp_a37abbae2a_28_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_revslider_navigations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_revslider_sliders: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_revslider_slides: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_revslider_static_slides: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_smush_dir_images: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_28_snp_log: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_snp_stats: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_28_termmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_28_terms: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_28_term_relationships: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_term_taxonomy: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_28_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_28_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_28_woocommerce_log: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_28_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_28_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_woocommerce_sessions: Data: 0.22MB + Index: 0.02MB wp_a37abbae2a_28_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_28_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_28_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB wp_a37abbae2a_28_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_28_yoast_seo_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_28_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_ac_abandoned_cart_history_lite: Data: 0.31MB + Index: 0.00MB wp_a37abbae2a_29_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_commentmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_comments: Data: 0.13MB + Index: 0.09MB wp_a37abbae2a_29_icl_string_pages: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_icl_string_urls: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_mw_wc_qbo_sync_customer_pairs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_log: Data: 0.08MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_paymentmethod_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_payment_id_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_product_pairs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_promo_code_product_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_qbo_customers: Data: 0.06MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_qbo_items: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_real_time_sync_history: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_real_time_sync_queue: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_shipping_product_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_tax_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_variation_pairs: Data: 0.00MB + Index: 0.00MB wp_a37abbae2a_29_mw_wc_qbo_sync_wq_cf_map: Data: 0.00MB + Index: 0.00MB wp_a37abbae2a_29_options: Data: 2.52MB + Index: 0.27MB wp_a37abbae2a_29_postmeta: Data: 0.34MB + Index: 0.31MB wp_a37abbae2a_29_posts: Data: 1.52MB + Index: 0.06MB wp_a37abbae2a_29_revslider_css: Data: 0.13MB + Index: 0.00MB wp_a37abbae2a_29_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_revslider_navigations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_revslider_sliders: Data: 0.03MB + Index: 0.00MB wp_a37abbae2a_29_revslider_slides: Data: 0.11MB + Index: 0.00MB wp_a37abbae2a_29_revslider_static_slides: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_smush_dir_images: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_snp_log: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_snp_stats: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_29_termmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_terms: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_term_relationships: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_term_taxonomy: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_wfBadLeechers: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfBlocks: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_wfBlocksAdv: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfConfig: Data: 0.28MB + Index: 0.00MB wp_a37abbae2a_29_wfCrawlers: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfFileMods: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfHits: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_29_wfHoover: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_wfIssues: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfKnownFileList: Data: 1.52MB + Index: 0.00MB wp_a37abbae2a_29_wfLeechers: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfLockedOut: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfLocs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfLogins: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_wfNet404s: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_wfNotifications: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfPendingIssues: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfReverseCache: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfScanners: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_wfSNIPCache: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_29_wfStatus: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_wfThrottleLog: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_wfVulnScanners: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_29_woocommerce_log: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.03MB wp_a37abbae2a_29_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_29_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_woocommerce_sessions: Data: 1.52MB + Index: 0.05MB wp_a37abbae2a_29_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_29_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_29_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB wp_a37abbae2a_29_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_29_yoast_seo_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_29_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_ac_abandoned_cart_history_lite: Data: 0.39MB + Index: 0.00MB wp_a37abbae2a_6_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_commentmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_6_comments: Data: 0.19MB + Index: 0.09MB wp_a37abbae2a_6_duplicator_packages: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_icl_string_pages: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_icl_string_urls: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_mw_wc_qbo_sync_customer_pairs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_log: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_paymentmethod_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_payment_id_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_product_pairs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_promo_code_product_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_qbo_customers: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_qbo_items: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_real_time_sync_history: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_real_time_sync_queue: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_shipping_product_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_tax_map: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_variation_pairs: Data: 0.00MB + Index: 0.00MB wp_a37abbae2a_6_mw_wc_qbo_sync_wq_cf_map: Data: 0.00MB + Index: 0.00MB wp_a37abbae2a_6_options: Data: 2.42MB + Index: 0.08MB wp_a37abbae2a_6_postmeta: Data: 1.52MB + Index: 1.97MB wp_a37abbae2a_6_posts: Data: 1.52MB + Index: 0.09MB wp_a37abbae2a_6_revslider_css: Data: 0.13MB + Index: 0.00MB wp_a37abbae2a_6_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_revslider_navigations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_revslider_sliders: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_revslider_slides: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_revslider_static_slides: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_smush_dir_images: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_6_snp_log: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_snp_stats: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_6_termmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_6_terms: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_6_term_relationships: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_term_taxonomy: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_6_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_6_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_6_woocommerce_log: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_woocommerce_order_itemmeta: Data: 0.20MB + Index: 0.22MB wp_a37abbae2a_6_woocommerce_order_items: Data: 0.06MB + Index: 0.02MB wp_a37abbae2a_6_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_6_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_6_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_6_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB wp_a37abbae2a_6_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_6_yoast_seo_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_6_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_ac_abandoned_cart_history_lite: Data: 2.52MB + Index: 0.00MB wp_a37abbae2a_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_blogs: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_blog_versions: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_commentmeta: Data: 0.05MB + Index: 0.03MB wp_a37abbae2a_comments: Data: 1.09MB + Index: 0.09MB wp_a37abbae2a_failed_jobs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_icl_string_pages: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_icl_string_urls: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_mailchimp_carts: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_mc4wp_log: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_options: Data: 2.39MB + Index: 0.06MB wp_a37abbae2a_osapi_last_modified: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_postmeta: Data: 4.23MB + Index: 6.09MB wp_a37abbae2a_posts: Data: 6.08MB + Index: 0.09MB wp_a37abbae2a_queue: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_registration_log: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_revslider_css: Data: 0.13MB + Index: 0.00MB wp_a37abbae2a_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_revslider_navigations: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_revslider_sliders: Data: 0.03MB + Index: 0.00MB wp_a37abbae2a_revslider_slides: Data: 0.11MB + Index: 0.00MB wp_a37abbae2a_revslider_static_slides: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_signups: Data: 0.02MB + Index: 0.06MB wp_a37abbae2a_site: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_sitemeta: Data: 0.14MB + Index: 0.03MB wp_a37abbae2a_smush_dir_images: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_snp_log: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_snp_stats: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_termmeta: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_terms: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_term_relationships: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_term_taxonomy: Data: 0.02MB + Index: 0.03MB wp_a37abbae2a_usermeta: Data: 1.52MB + Index: 3.00MB wp_a37abbae2a_users: Data: 0.09MB + Index: 0.05MB wp_a37abbae2a_wfBadLeechers: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfBlockedCommentLog: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfBlocks: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_wfBlocks7: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_wfBlocksAdv: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfConfig: Data: 0.30MB + Index: 0.00MB wp_a37abbae2a_wfCrawlers: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfFileChanges: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfFileMods: Data: 2.52MB + Index: 0.00MB wp_a37abbae2a_wfHits: Data: 0.20MB + Index: 0.08MB wp_a37abbae2a_wfHoover: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_wfIssues: Data: 0.02MB + Index: 0.06MB wp_a37abbae2a_wfKnownFileList: Data: 1.52MB + Index: 0.00MB wp_a37abbae2a_wfLeechers: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfLockedOut: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfLocs: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfLogins: Data: 0.13MB + Index: 0.03MB wp_a37abbae2a_wfNet404s: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_wfNotifications: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfPendingIssues: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfReverseCache: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfScanners: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_wfSNIPCache: Data: 0.02MB + Index: 0.05MB wp_a37abbae2a_wfStatus: Data: 0.13MB + Index: 0.13MB wp_a37abbae2a_wfThrottleLog: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_wfVulnScanners: Data: 0.02MB + Index: 0.00MB wp_a37abbae2a_yoast_seo_links: Data: 0.02MB + Index: 0.02MB wp_a37abbae2a_yoast_seo_meta: Data: 0.09MB + Index: 0.00MB wp_commentmeta: Data: 0.02MB + Index: 0.03MB wp_comments: Data: 0.02MB + Index: 0.08MB wp_links: Data: 0.02MB + Index: 0.02MB wp_options: Data: 0.05MB + Index: 0.02MB wp_postmeta: Data: 0.02MB + Index: 0.03MB wp_posts: Data: 0.02MB + Index: 0.06MB wp_termmeta: Data: 0.02MB + Index: 0.03MB wp_terms: Data: 0.02MB + Index: 0.03MB wp_term_relationships: Data: 0.02MB + Index: 0.02MB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB wp_usermeta: Data: 0.02MB + Index: 0.03MB wp_users: Data: 0.02MB + Index: 0.05MB

Post Type Counts

acf: 1 acf-field: 12 acf-field-group: 3 attachment: 134 mc4wp-form: 3 megamenu_profile: 2 nav_menu_item: 23 noa-video: 3 page: 16 post: 2 product: 5 product_variation: 14 revision: 234 shop_coupon: 1 shop_order: 3 snp_popups: 2 testimonial: 5 vc_grid_item: 1 wpcf7_contact_form: 3

Security

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

Active Plugins (52)

Redux Framework: by Team Redux – 3.6.7.7 CMB2: by CMB2 team – 2.3.0 Color and Image Swatches for Variable Product Attributes: by Phoeniixx – 1.2.7 Contact Form 7: by Takayuki Miyoshi – 4.9.2 XStore Core: by 8theme – 1.0.11 WPBakery Page Builder: by Michael M - WPBakery.com – 5.4.4 MailChimp for WordPress: by ibericode – 4.1.14 MailChimp for WooCommerce: by MailChimp – 2.1.3 – Not tested with the active version of WooCommerce MailChimp for WordPress - Premium: by ibericode – 3.3.26 Slider Revolution: by ThemePunch – 5.4.5.1 SendGrid: by SendGrid – 1.11.7 SVG Support: by Benbodhi – 2.3.11 Commission Factory for WooCommerce: by Commission Factory Pty Ltd – 1.0 – Not tested with the active version of WooCommerce WooCommerce Email Test: by RaiserWeb – 1.8 – Not tested with the active version of WooCommerce Netbanx (Optimal Payments) - WooCommerce Gateway: by Yojance Rabelo – 1.0.0 – Not tested with the active version of WooCommerce WooCommerce: by Automattic – 3.2.6 WordPress Importer: by wordpressdotorg – 0.6.3 Query Monitor: by John Blackbourn – 2.17.0 CMB2: by CMB2 team – 2.3.0 Color and Image Swatches for Variable Product Attributes: by Phoeniixx – 1.2.7 Contact Form 7: by Takayuki Miyoshi – 4.9.2 Netbanx (Optimal Payments) - WooCommerce Gateway: by Yojance Rabelo – 1.0.0 – Not tested with the active version of WooCommerce Redux Framework: by Team Redux – 3.6.7.7 Slider Revolution: by ThemePunch – 5.4.5.1 SVG Support: by Benbodhi – 2.3.11 WooCommerce: by Automattic – 3.2.6 WooCommerce Email Test: by RaiserWeb – 1.8 – Not tested with the active version of WooCommerce XStore Core: by 8theme – 1.0.11 NS Cloner - Site Copier: by Never Settle – 3.0.8 SendGrid: by SendGrid – 1.11.7 Yoast SEO: by Team Yoast – 6.2 WooCommerce Google Analytics Integration: by WooCommerce – 1.4.3 – Not tested with the active version of WooCommerce WP Facebook Pixel: by Night Shift Apps – 4.5 Zendesk Chat Widget: by Zendesk – 1.4.12 Wordfence Security: by Wordfence – 7.0.1 Advanced Custom Fields: by Elliot Condon – 4.4.12 Enable Media Replace: by Måns Jonasson – 3.1.1 WooCommerce Notification: by Andy Ha (villatheme.com) – 1.1.4 – Not tested with the active version of WooCommerce WooCommerce PayPal Express Checkout Gateway: by WooCommerce – 1.5.0 Advanced Custom Fields PRO: by Elliot Condon – 5.6.5 WP-Sweep: by Lester 'GaMerZ' Chan – 1.0.12 Redis Object Cache: by Till Krüss – 1.3.5 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.14.3

OneSaas Connect: by OneSaas – 2.0.6.44 – Not tested with the active version of WooCommerce Cloudways WordPress Migrator: by Cloudways – 1.48 WPBakery Page Builder: by Michael M - WPBakery.com – 5.4.4 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.0.1 Noa core: by Thierry Lavergne – 1.0 Duplicate Post: by Enrico Battocchi – 3.2.1 WooCommerce Side Cart Premium: by XootiX – 1.0.1 – Not tested with the active version of WooCommerce SIP Reviews Shortcode Pro WooCommerce: by ShopitPress – 1.4.0 – Not tested with the active version of WooCommerce Woo Discount Rules: by Flycart Technologies LLP – 1.4.32 – Not tested with the active version of WooCommerce

Settings

API Enabled: ✔ Force SSL: ✔ Currency: SGD (S$) 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)

WC Pages

Shop base: ❌ Page not set Cart: #8 - /cart/ Checkout: #9 - /checkout/ My account: #10 - /my-account/ Terms and conditions: ❌ Page not set

Theme

Name: Noa Version: 1.0.1481772930 Author URL: https://www.kokomoweb.com Child Theme: ✔ Parent Theme Name: XStore Parent Theme Version: 4.9 Parent Theme Author URL: http://www.8theme.com WooCommerce Support: ✔

Templates

Overrides: xstore/woocommerce/archive-product.php xstore/woocommerce/cart/cart-empty.php xstore/woocommerce/cart/cart-item-data.php noa/woocommerce/cart/cart-totals.php xstore/woocommerce/cart/cart.php xstore/woocommerce/cart/cross-sells.php xstore/woocommerce/cart/mini-cart.php xstore/woocommerce/checkout/form-billing.php xstore/woocommerce/checkout/form-checkout.php noa/woocommerce/checkout/form-shipping.php version 2.2.0 is out of date. The core version is 3.0.9 noa/woocommerce/checkout/review-order.php noa/woocommerce/checkout/thankyou.php version 2.2.0 is out of date. The core version is 3.2.0 xstore/woocommerce/content-product.php xstore/woocommerce/content-product_cat.php xstore/woocommerce/content-single-product.php xstore/woocommerce/content-widget-product.php noa/woocommerce/emails/customer-completed-order.php noa/woocommerce/emails/customer-new-account.php noa/woocommerce/emails/customer-processing-order.php noa/woocommerce/emails/customer-refunded-order.php noa/woocommerce/emails/customer-reset-password.php xstore/woocommerce/global/breadcrumb.php xstore/woocommerce/global/form-login.php xstore/woocommerce/global/quantity-input.php xstore/woocommerce/global/wrapper-end.php xstore/woocommerce/global/wrapper-start.php xstore/woocommerce/loop/loop-end.php xstore/woocommerce/loop/loop-start.php xstore/woocommerce/loop/no-products-found.php xstore/woocommerce/loop/pagination.php xstore/woocommerce/loop/sale-flash.php noa/woocommerce/myaccount/orders.php version 2.6.0 is out of date. The core version is 3.2.0 xstore/woocommerce/single-product/add-to-cart/simple.php noa/woocommerce/single-product/product-image.php noa/woocommerce/single-product/rating.php version 2.3.2 is out of date. The core version is 3.1.0 xstore/woocommerce/single-product/related.php xstore/woocommerce/single-product/sale-flash.php xstore/woocommerce/single-product/short-description.php xstore/woocommerce/single-product/tabs/additional-information.php xstore/woocommerce/single-product/tabs/description.php xstore/woocommerce/single-product/tabs/tabs.php noa/woocommerce/single-product/title.php xstore/woocommerce/single-product/up-sells.php xstore/woocommerce/single-product.php

Outdated Templates: ❌Learn how to update `

[khungate-zz]

@kokomomtl @johnschneider89 the 2.1.4 release is out and it was focused on improving the queue job process. Do want to give things a try again?

[kokomomtl]

@khungate No improvements. We tried the plugin on our production site which has 700 orders. Our dedicated server crashes after about 30 minutes every time.

[khungate-zz]

@kokomomtl thanks for the feedback and I'm sorry you're still having issues. Since our last exchange, we've identified a few areas where the sync could get stuck in certain server environments and make excessive calls to the admin-ajax file. In our next release, we believe some small tweaks we've added will fix those isolated situations.

I don't have a date for the release of 2.1.5 yet, but it should be sometime in the near future. In the interim, if you'd like to try out the staging plugin that is being tested, feel free to grab it here.

As always, if you're not testing in a development area, please take the necessary steps to backup your site before installing. Otherwise, I'll be sure to let you know when 2.1.5 is official.

[kokomomtl]

Thank-you @khungate. My orders are almost ready to be finished syncing, so I might just wait for 2.1.5. In your experience, will the performance issues go away when it's done syncing?

[khungate-zz]

@kokomomtl It's difficult to say without knowing if your server configuration was one of the situations impacted. If you still have performance issues after the sync is complete, I'd recommend deactivating and trying the new version when it's live (since it contains those modifications for performance). Thanks again for your feedback and working through things with us.

[Demuri]

Same problem - no data synced. List, orders, products - nothing. Tried to re-install or re-sync, turned off Cloudflare IP proxy - no success.

Sync Information
Started: Wed, Apr 4, 2018 10:15 PM
Account Connected: [***hidden***]
List Connected: 22G All customers
Products Synced: 0
Orders Synced: 0

Please find WooCommerce report attached. wc-status.txt

[khungate-zz]

@Demuri thanks for reaching out. Can you turn on your standard logging and try to resync? You may add this query parameter to your URL ?resync=1. Let us know if you see any errors in the logger once it starts.

[Demuri]

@khungate Thanks for rapid reply. Tried it right now, all I see in logger is 2018-04-04T23:08:14+00:00 NOTICE sync.started :: Starting Sync :: Wed, Apr 4, 2018 8:08 PM

[ryanhungate]

@Demuri looking at your plugin list - it shows that you have the MailChimp for Wordpress by Ibericode installed as well - I don't know if there is a conflict there causing this to be stuck.

Also - just out of curiosity are you on a hosted wordpress install, or is this a private server?

[Demuri]

@ryanhungate tried to deactivate MailChimp for WP and resync - no changes. BTW that plugin works fine. I'm on Vultr VPS

[Demuri]

@ryanhungate Both plugins use different API keys

[ryanhungate]

@Demuri do you by chance have a constant DISABLE_WP_HTTP_WORKER set to true?

Do you see anything at all in your error logs for WooCommerce that show anything meaningful?

[Demuri]

@ryanhungate found nothing related in logs, HTTP Worker not disabled. But now I believe in miracles - it started to sync, currently syncing products! The only idea is about DNS propagation lag and Cloudflare IP proxy - disabled it about 3 hours ago

[ryanhungate]

@Demuri ha - good news. One other thing to note is that if you don't have a normal traffic coming to the site, the queue is not going to work properly. If you can, maybe add a site ping check that runs every minute, every 5 minutes etc. to make sure that the cron jobs will actually fire off. As you probably know the cron schedule for WP requires a site view. I suggest the every minute uptime checker if you can.

I am a little curious about the Cloudflare IP proxy. I'll see if I can find anything that stands out.

[Demuri]

@ryanhungate thanks for helping me. Sinced pretty much okay, just a few errors related to product variations, I'm ok with it :)

[ryanhungate]

@Demuri awesome - glad we could help. 👍

[jocjara]

I have the same problem.

_

Sync Information

Started: Sat, May 5, 2018 11:41 AM

Account Connected: Smartronic Smartphone

List Connected: Smartronic Smartphone

Products Synced: 0

Orders Synced: 0

_ Please help!!