Mailchimp Stuck on Syncing List

[brunompbarbosa]

Hello,

I've been struggling with an issue trying to implement the e-commerce automation for Mailchimp on a WooCommerce store.

I was able to connect the store to mailchimp and all products have synced normally, but i had to use wp-cli to achieve it (the store has around 2000 products). However, no orders are being synced to mailchimp, and the status icon on the "Connected Sites" page on the mailchimp account has been showing " List settings - Syncing list: ListName since the store was originally connected, about two weeks ago.

The Mailchimp API Calls table shows that all calls have been made successfully, with none of them having any response text.

The Plugin page shows "Orders Synced: 0" under the sync tab, and no info shows on the Logs tab, even though it is currently set to "Standard".

I've been searching the plugin page on wordpress but have not come up with any working solution. Also, i was having this issue with v2.1.4, but it is still happening after updating to 2.1.5.

Any idea what could be causing this?

Thanks in advance,

[khungate-zz]

@brunompbarbosa before we try to speculate too much on the syncing, would you care to perform a fresh install? Completely deactivate/delete the plugin and try again with 2.1.5.

Also, it's possible with the latest release you won't need to use the CLI version since much of the release was focused on improving the queue and syncing process. If you do use CLI, please refer to these instructions to ensure your setup is still current in #158.

I have a feeling if we can get a good install, you should be able to create new automations as mentioned in #213.

Please let us know how it goes.

[brunompbarbosa]

@khungate Thanks for your quick reply.

I have tried removing the store connection and completely uninstalling the plugin. I then installed it again and it started syncing the store as normal.
It seems to be exhibiting the same behaviour - although i have now noticed that not all products are being synced - its currently stopped at 1856, and the store has 2120 published products in total.

Also, there are no orders being synced as well.

One thing i noticed, when adding the "&resync=1" parameter to the sync page url and clicking the button, this only runs normally if the logs are disabled - if either the debug or standard options are selected, the resync process fails returning a 500 error page.

I have no idea what is going on here, and no solid direction to move to in trying to figure this out.

Do you have any other possible ideas on what could be going unexpectedly in all this?

Thanks,

Bruno

[ryanhungate]

@brunompbarbosa what you are seeing is certainly not expected - but I know we can figure out what the issue is.

I see that you had the WP CLI version at one point - are you still using that? Did you also add the DISABLE_WP_HTTP_WORKER constant? If you're using the CLI you enable that... otherwise you disable it for the normal queue worker to do its job. Just making sure you don't have something preventing the queue from running

[brunompbarbosa]

@ryanhungate yes, i had added the constant the first time around, but i removed it this time. Still experiencing same behaviour, it seems to be syncing more products now, but at a very slow rate.

[khungate-zz]

@brunompbarbosa wanted following up, did everything finally go through?

[brunompbarbosa]

At the moment it has synced 1909 products in total.
I checked the store again and it currently has 2216 - 1718 published, 498 drafts and 17 in the trash.
I was under the impression that the syncing was going really slowly, but after looking at the graph for the API calls on my mailchimp account, it seems to only add the products when i force the resync.

Unfortunately, there is still no sign of the orders being synced, and the status on the "Connected Sites" page still appears as "Syncing List".

[ryanhungate]

Hey @brunompbarbosa sorry to hear that - sounds strange. Do you see anything popping up in your server error logs? Anything 'fatal' going on that we just can't see? If you've tried to re-sync the store, there may be something happening before the plugin does a try/catch so can we start by first checking your error logs for the server and or woo?

[brunompbarbosa]

here's my woocommerce status:

`### WordPress Environment ###

WC Version: 2.6.14
Log Directory Writable: ✔
WP Version: 4.8.5
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US

Server Environment

Server Info: Apache
PHP Version: 7.0.28
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.58.0
OpenSSL/1.0.2n

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

Database

WC Database Version: 2.6.14
:
woocommerce_sessions: ✔
woocommerce_api_keys: ✔
woocommerce_attribute_taxonomies: ✔
woocommerce_downloadable_product_permissions: ✔
woocommerce_order_items: ✔
woocommerce_order_itemmeta: ✔
woocommerce_tax_rates: ✔
woocommerce_tax_rate_locations: ✔
woocommerce_shipping_zones: ✔
woocommerce_shipping_zone_locations: ✔
woocommerce_shipping_zone_methods: ✔
woocommerce_payment_tokens: ✔
woocommerce_payment_tokenmeta: ✔

Active Plugins (31)

iThemes Security: by iThemes – 6.6.1
Contact Form 7: by Takayuki Miyoshi – 4.8.1
Cookie Notice: by dFactory – 1.2.38
DHL Express/DHL Paket WooCommerce Shipping with Print Label: by Xadapter – 3.0.3
Salient Visual Composer: by Michael M - WPBakery.com | Modified by ThemeNectar – 5.0.1
MailChimp for WooCommerce: by MailChimp – 2.1.5
MailChimp for WordPress: by ibericode – 4.1.15
MainWP Child: by MainWP – 3.4.3
Multibanco (IfthenPay gateway) for WooCommerce: by Webdados – 1.9.2
Popping Content Light: by OTWthemes – 1.8
Portugal States (Distritos) for WooCommerce: by Webdados – 1.5.2
WooCommerce Product Filter: by Mihajlovic Nenad – 6.4.1
Product Category Tree: by TOGI Data – 1.0.2
Woocommerce Quick Edit Products Pro: by FinalThemes – 1.0.9
Re-add text underline and justify: by Brice Capobianco – 0.1.4
Really Simple SSL: by Rogier Lankhorst – 2.5.17
WPML Multilingual CMS: by OnTheGoSystems – 3.6.3
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.13.4

WooCommerce Checkout Field Editor Pro: by ThemeHiGH – 2.7.7
WooCommerce Conditional Shipping and Payments: by WooThemes – 1.2.5
WooCommerce Stripe Gateway: by WooCommerce – 3.2.0
WooCommerce Multilingual: by OnTheGoSystems – 4.1.2
WooCommerce Pretty Emails: by MB Création – 1.8.2
WooCommerce Variation Swatches and Photos: by Lucas Stark – 3.0.0
WooCommerce: by WooThemes – 2.6.14
Yoast SEO: by Team Yoast – 5.5
WP Fastest Cache: by Emre Vona – 0.8.7.6
WPML Media: by OnTheGoSystems – 2.1.24
WPML String Translation: by OnTheGoSystems – 2.5.2
WPML Translation Management: by OnTheGoSystems – 2.2.7
YITH Infinite Scrolling Premium: by YITHEMES – 1.1.0

Settings

Force SSL: ✔
Currency: EUR (€)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2

API

API Enabled: ✔

WC Pages

Shop Base: #8 - /shop/
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My Account: #42529 - /my-account/

Taxonomies

Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Theme

Name: A Calçada Child
Version: 1
Author URL: http:%20//acalcada.com/
Child Theme: ✔
Parent Theme Name:
Parent Theme Version: – 0 is available
Parent Theme Author URL:
WooCommerce Support: ✔

Templates

Overrides: acalcada/woocommerce/cart/cart-shipping.php
acalcada/woocommerce/cart/cart-totals.php
acalcada/woocommerce/cart/cart.php
acalcada/woocommerce/cart/shipping-calculator.php
acalcada/woocommerce/checkout/form-checkout.php
acalcada/woocommerce/checkout/form-shipping.php
acalcada/woocommerce/checkout/review-order.php
acalcada/woocommerce/checkout/terms.php
acalcada/woocommerce/content-product.php
acalcada/woocommerce/content-single-product.php
acalcada/woocommerce/loop/add-to-cart.php
acalcada/woocommerce/loop/loop-start.php
acalcada/woocommerce/myaccount/form-login.php
acalcada/woocommerce/single-product/product-image.php
acalcada/woocommerce/single-product/tabs/description.php
acalcada/woocommerce/single-product/tabs/tabs.php`

and here is the current system log (this is the only information it has at the moment:)

[20-Mar-2018 10:17:59 UTC] PHP Warning: Error while sending QUERY packet. PID=26273 in /home/projectstore/public_html/wp-includes/wp-db.php on line 1942
[20-Mar-2018 10:20:00 UTC] PHP Warning: Error while sending QUERY packet. PID=26911 in /home/projectstore/public_html/wp-includes/wp-db.php on line 1942
[20-Mar-2018 10:21:01 UTC] PHP Warning: Error while sending QUERY packet. PID=26913 in /home/projectstore/public_html/wp-includes/wp-db.php on line 1942
[20-Mar-2018 10:22:04 UTC] PHP Warning: Error while sending QUERY packet. PID=28002 in /home/projectstore/public_html/wp-includes/wp-db.php on line 1942

`
It now says it has 1985 products synced - but i have no idea when or how it has synced them.

[ryanhungate]

Hey @brunompbarbosa I noticed something in your active plugin list that might be causing confusion but in all honesty it's just a guess at this point - I see that you have:

MailChimp for WooCommerce: by MailChimp – 2.1.5 this is ours
MailChimp for WordPress: by ibericode – 4.1.15 not ours

I wonder if there is a conflict somewhere that we're not seeing. Is there a reason you have both installed at the same time?

Also - i'm not seeing the queue database table either. What database engine are you using? MySQL? Can we do a verification that you have the queue table as well? It's supposed to install it when the plugin is activated.

[brunompbarbosa]

@ryanhungate Thanks for your help - i really appreciate yours and @khungate 's help with this issue.

The MailChimp for WordPress: by ibericode – 4.1.15 plugin came with the site, it was a preexisting project that i am now maintaining. As far as i can tell it is being used only to generate a subscription form and not much else. I can try disabling it to see if there is any effect.

About the queue database table, i am using MySQL, and it does in fact have one - (wp_queue) currently with 743 records, 12 of them related to orders. 3 of those have "MailChimp_WooCommerce_Process_Orders" in the job column, the other 9 have "MailChimp_WooCommerce_Single_Order". All records on that table were created between March 19 and 20, if that information helps.

[ryanhungate]

Hey @brunompbarbosa yes it does help. If you don't mind - try turning off that plugin first - but also I needed to ask if you happen to have set a site constant of DISABLE_WP_HTTP_WORKER to true?

Strange that the queue is not processing jobs - makes me wonder if the CLI mode has been enabled. That would require you to have a background process of wp queue listen running at all times to process the jobs. By default it's not turned on but I just wonder if you've got yourself in a situation where someone tried to enable it for whatever reason and walked away from it?

[brunompbarbosa]

@ryanhungate about the DISABLE_WP_HTTP_WORKER function, i had it enabled initially when i did my first sync using wp_cli, but i have have removed it since i opened this issue and tried the sync again. it is still disabled as far as i can tell - but i'll have a look to see if it might still be enabled elsewhere.

I'll also try to disable the other plugin and reply with some feedback regarding on wether it had some impact or not on the sync.

[ryanhungate]

@brunompbarbosa thanks for the follow up - let us know what comes of your changes.

When you say that you had tried the WP CLI wp queue listen option, does that seem to process the jobs? If you have the ability to set up a background process or even a real cron schedule to verify the worker is working that should be good enough as well. We had made some pretty significant improvements to the default queue system which makes use of the admin-ajax file, but the cli process is certainly the better way to go about it if you have that option.

[brunompbarbosa]

hello @ryanhungate i have some developments.
Disabling the plugin changed nothing, so it should not be interfering with the queue. However, i've followed your tip on this last reply, and running wp-cli queue listen did nothing, but when i ran queue work i got a warning - "Warning: Failed: WP_Worker" on the console. After that, i've inspected the error logs and i found this:

[21-Mar-2018 16:39:44 UTC] PHP Fatal error: Uncaught Error: Call to undefined method WC_Order::get_date_created() in /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-orders.php:96 Stack trace: #0 /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-orders.php(42): MailChimp_WooCommerce_Transform_Orders->transform(Object(WP_Post)) #1 /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-api.php(70): MailChimp_WooCommerce_Transform_Orders->compile('1', 5) #2 /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-abstract-sync.php(208): MailChimp_WooCommerce_Api->paginate('orders', '1', 5) #3 /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-abstract-sync.php(94): MailChimp_WooCommerce_Abtstract_Sync->getResour in /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-orders.php on line 96

Is this information useful? It is at least something different from what i've been getting the past few days.

[ryanhungate]

@brunompbarbosa thank you - yes that does help tremendously. Looks like the function get_date_created does not exist in your WooCommerce Order class. I will suggest something here - since you're on an older version of Woo - this did not come up in our testing environments.

Only do this if you're comfortable editing a file - but you should be ok since the file will only be run while you're executing the queue job itself...

Replace this line with this below:

   if (method_exists($woo, 'get_date_created')) {
        $order->setProcessedAt($woo->get_date_created()->setTimezone(new \DateTimeZone('UTC')));
    } elseif (property_exists($woo, 'order_date')) {
        $date = new \WC_DateTime($woo->order_date);
        $date->setTimezone(new \DateTimeZone('UTC'));
        $order->setProcessedAt($date);
    } else {
        $date = new \WC_DateTime();
        $date->setTimezone(new \DateTimeZone('UTC'));
        $order->setProcessedAt($date);
    }

Then let me know if that fixes that problem for you 👍

[nailladynam]

I'm having the same issue with my installation for over a month now and still unable to find the problem. My site is hosted on WP, I've deactivated, reinstalled, reactivated countless times but nothing seems to work to fix the problem.

I currently only have 21 orders, and 28 products, which is a very small store by comparison, I've reverted to default theme, deactivated all other plugins... literally everything the MC, WC and WP teams have suggested and still NOTHING to fix the issue.

I am not an experienced developer, and am running my own site.

status:
`

WordPress Environment

WC Version: 3.3.4
Log Directory Writable: ✔
WP Version: 4.9.4
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_ZA

Server Environment

Server Info: nginx
PHP Version: 7.0.28
PHP Post Max Size: 2 GB
PHP Time Limit: 1200
PHP Max Input Vars: 6144
cURL Version: 7.58.0
OpenSSL/1.0.1t

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

Database

WC Database Version: 3.3.4
WC Database Prefix: wp_113114317_
MaxMind GeoIP Database: ✔
Total Database Size: 23.24MB
Database Data Size: 21.57MB
Database Index Size: 1.67MB
wp_113114317_woocommerce_sessions: Data: 0.45MB + Index: 0.02MB
wp_113114317_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
wp_113114317_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
wp_113114317_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
wp_113114317_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
wp_113114317_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB
wp_113114317_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
wp_113114317_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
wp_113114317_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
wp_113114317_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
wp_113114317_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
wp_113114317_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
wp_113114317_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wp_113114317_woocommerce_log: Data: 0.02MB + Index: 0.02MB
vp_backup_wp_113114317_commentmeta: Data: 0.00MB + Index: 0.00MB
vp_backup_wp_113114317_comments: Data: 0.01MB + Index: 0.01MB
vp_backup_wp_113114317_content_tabs_ultimate_import: Data: 0.02MB + Index: 0.02MB
vp_backup_wp_113114317_content_tabs_ultimate_list: Data: 0.05MB + Index: 0.00MB
vp_backup_wp_113114317_content_tabs_ultimate_style: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_failed_jobs: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_formmaker: Data: 0.20MB + Index: 0.00MB
vp_backup_wp_113114317_formmaker_backup: Data: 1.52MB + Index: 0.00MB
vp_backup_wp_113114317_formmaker_blocked: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_formmaker_display_options: Data: 0.02MB + Index: 0.02MB
vp_backup_wp_113114317_formmaker_query: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_formmaker_sessions: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_formmaker_submits: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_formmaker_themes: Data: 0.14MB + Index: 0.00MB
vp_backup_wp_113114317_formmaker_views: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_hugeit_slider_slide: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_hugeit_slider_slider: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_links: Data: 0.00MB + Index: 0.00MB
vp_backup_wp_113114317_mailchimp_carts: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_maxbuttonsv3: Data: 0.09MB + Index: 0.00MB
vp_backup_wp_113114317_maxbuttons_collections: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_maxbuttons_collections_trans: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mlw_qm_audit_trail: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mlw_questions: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mlw_quizzes: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mlw_results: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mwd_display_options: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mwd_forms: Data: 0.05MB + Index: 0.00MB
vp_backup_wp_113114317_mwd_forms_backup: Data: 0.28MB + Index: 0.00MB
vp_backup_wp_113114317_mwd_forms_blocked: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mwd_forms_sessions: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mwd_forms_submits: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mwd_forms_views: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_mwd_themes: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_options: Data: 0.36MB + Index: 0.06MB
vp_backup_wp_113114317_postmeta: Data: 0.55MB + Index: 0.15MB
vp_backup_wp_113114317_posts: Data: 1.52MB + Index: 0.08MB
vp_backup_wp_113114317_queue: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_termmeta: Data: 0.00MB + Index: 0.00MB
vp_backup_wp_113114317_terms: Data: 0.00MB + Index: 0.01MB
vp_backup_wp_113114317_term_relationships: Data: 0.00MB + Index: 0.01MB
vp_backup_wp_113114317_term_taxonomy: Data: 0.01MB + Index: 0.01MB
vp_backup_wp_113114317_uam_accessgroups_1-5-1: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_uam_accessgroup_to_object_1-5-1: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_usermeta: Data: 0.05MB + Index: 0.04MB
vp_backup_wp_113114317_users: Data: 0.00MB + Index: 0.01MB
vp_backup_wp_113114317_wc_download_log: Data: 0.02MB + Index: 0.03MB
vp_backup_wp_113114317_wc_webhooks: Data: 0.02MB + Index: 0.02MB
vp_backup_wp_113114317_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
vp_backup_wp_113114317_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
vp_backup_wp_113114317_woocommerce_downloadable_product_permissi: Data: 0.02MB + Index: 0.05MB
vp_backup_wp_113114317_woocommerce_log: Data: 0.02MB + Index: 0.02MB
vp_backup_wp_113114317_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.03MB
vp_backup_wp_113114317_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
vp_backup_wp_113114317_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
vp_backup_wp_113114317_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
vp_backup_wp_113114317_woocommerce_sessions: Data: 0.05MB + Index: 0.02MB
vp_backup_wp_113114317_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
vp_backup_wp_113114317_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
vp_backup_wp_113114317_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
vp_backup_wp_113114317_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
wp_113114317_commentmeta: Data: 0.00MB + Index: 0.00MB
wp_113114317_comments: Data: 0.01MB + Index: 0.01MB
wp_113114317_content_tabs_ultimate_import: Data: 0.02MB + Index: 0.02MB
wp_113114317_content_tabs_ultimate_list: Data: 0.05MB + Index: 0.00MB
wp_113114317_content_tabs_ultimate_style: Data: 0.02MB + Index: 0.00MB
wp_113114317_failed_jobs: Data: 0.02MB + Index: 0.00MB
wp_113114317_formmaker: Data: 0.20MB + Index: 0.00MB
wp_113114317_formmaker_backup: Data: 1.52MB + Index: 0.00MB
wp_113114317_formmaker_blocked: Data: 0.02MB + Index: 0.00MB
wp_113114317_formmaker_display_options: Data: 0.02MB + Index: 0.02MB
wp_113114317_formmaker_query: Data: 0.02MB + Index: 0.00MB
wp_113114317_formmaker_sessions: Data: 0.02MB + Index: 0.00MB
wp_113114317_formmaker_submits: Data: 0.02MB + Index: 0.00MB
wp_113114317_formmaker_themes: Data: 0.14MB + Index: 0.00MB
wp_113114317_formmaker_views: Data: 0.02MB + Index: 0.00MB
wp_113114317_hugeit_slider_slide: Data: 0.02MB + Index: 0.00MB
wp_113114317_hugeit_slider_slider: Data: 0.02MB + Index: 0.00MB
wp_113114317_links: Data: 0.00MB + Index: 0.00MB
wp_113114317_mailchimp_carts: Data: 0.02MB + Index: 0.00MB
wp_113114317_maxbuttonsv3: Data: 0.09MB + Index: 0.00MB
wp_113114317_maxbuttons_collections: Data: 0.02MB + Index: 0.00MB
wp_113114317_maxbuttons_collections_trans: Data: 0.02MB + Index: 0.00MB
wp_113114317_mlw_qm_audit_trail: Data: 0.02MB + Index: 0.00MB
wp_113114317_mlw_questions: Data: 0.02MB + Index: 0.00MB
wp_113114317_mlw_quizzes: Data: 0.02MB + Index: 0.00MB
wp_113114317_mlw_results: Data: 0.02MB + Index: 0.00MB
wp_113114317_mwd_display_options: Data: 0.02MB + Index: 0.00MB
wp_113114317_mwd_forms: Data: 0.05MB + Index: 0.00MB
wp_113114317_mwd_forms_backup: Data: 0.28MB + Index: 0.00MB
wp_113114317_mwd_forms_blocked: Data: 0.02MB + Index: 0.00MB
wp_113114317_mwd_forms_sessions: Data: 0.02MB + Index: 0.00MB
wp_113114317_mwd_forms_submits: Data: 0.02MB + Index: 0.00MB
wp_113114317_mwd_forms_views: Data: 0.02MB + Index: 0.00MB
wp_113114317_mwd_themes: Data: 0.02MB + Index: 0.00MB
wp_113114317_options: Data: 9.91MB + Index: 0.06MB
wp_113114317_postmeta: Data: 0.57MB + Index: 0.15MB
wp_113114317_posts: Data: 1.62MB + Index: 0.08MB
wp_113114317_queue: Data: 0.02MB + Index: 0.00MB
wp_113114317_termmeta: Data: 0.00MB + Index: 0.00MB
wp_113114317_terms: Data: 0.00MB + Index: 0.01MB
wp_113114317_term_relationships: Data: 0.00MB + Index: 0.01MB
wp_113114317_term_taxonomy: Data: 0.01MB + Index: 0.01MB
wp_113114317_uam_accessgroups_1-5-1: Data: 0.02MB + Index: 0.00MB
wp_113114317_uam_accessgroup_to_object_1-5-1: Data: 0.02MB + Index: 0.00MB
wp_113114317_usermeta: Data: 0.07MB + Index: 0.05MB
wp_113114317_users: Data: 0.01MB + Index: 0.01MB
wp_113114317_wc_download_log: Data: 0.02MB + Index: 0.03MB
wp_113114317_wc_webhooks: Data: 0.02MB + Index: 0.02MB

Post Type Counts

attachment: 68
customize_changeset: 54
custom_css: 1
custom_dns: 1
dns_revision: 1
feedback: 1
fmemailverification: 1
form-maker: 1
jetpack_migration: 2
jp_img_sitemap: 2
jp_sitemap: 2
jp_sitemap_master: 2
mwd_optin_conf: 2
nav_menu_item: 26
page: 34
post: 10
product: 28
revision: 614
shop_coupon: 6
shop_order: 22
ufaq: 7

Security

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

Active Plugins (19)

Akismet Anti-Spam: by Automattic – 4.0.3
AMP: by Automattic – 0.6.2
Google Analytics Simplified: by Ankur Kumar – 1.4.2
Display Posts Shortcode: by Bill Erickson – 2.9.0
Duplicate Post: by Enrico Battocchi – 3.2.1
Facebook for WooCommerce: by Facebook – 1.6.6 – Not tested with the active version of WooCommerce
Form Maker Pro: by WebDorado Form Builder Team – 2.12.20
Jetpack by WordPress.com: by Automattic – 5.9
MailChimp for WooCommerce: by MailChimp – 2.1.5 – Not tested with the active version of WooCommerce
MaxButtons: by Max Foundry – 7.0
Quiz And Survey Master: by Frank Corso – 5.2.1
Storefront Product Sharing: by WooCommerce – 1.0.5
Ultimate FAQ: by Etoile Web Design – 1.6.19 – Not tested with the active version of WooCommerce
Tabs - Responsive Tabs with Accordions: by Biplob Adhikari – 2.1
WD manager: by WebDorado – 1.3.8
WooCommerce Services: by Automattic – 1.12.1
WooCommerce: by Automattic – 3.3.4
WP Gallery Custom Links: by johnogg – 1.12
WP SEO Structured Data Schema: by kcseopro – 2.4.1

Settings

API Enabled: ✔
Force SSL: ✔
Currency: ZAR (R)
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: #376 - /shop/
Basket: #379 - /cart/
Checkout: #382 - /checkout/
My account: #385 - /my-account/
Terms and conditions: #478 - /enrollment-agreement/

Theme

Name: Storefront
Version: 2.2.8
Author URL: https://woocommerce.com/
Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ✔

Templates

Overrides: –
`

I see that there are existing logs on my WooCommerce status panel, but they are dated 19 Feb 2018, with no option / button visible for me to get an updated log (unless I'm looking in the wrong place for it?)

I'm not an experienced developer, so I am reluctant to tweak anything in the plugin editor in case I break something. Support from all the big guys concerned (WordPress, MailChimp and WooCommerce) has so far not been helpful since they keep telling me to do the same thing, which keeps not working. I even paid a developer recommended by WooCommerce an exhorbitant amount of money to look into it with no result to the problem.

It's been 6 weeks now that I can't use my website properly and I'm really at my wit's end with frustration over this issue and would really appreciate a fix that works.

[brunompbarbosa]

@ryanhungate Thanks, i've tried what you've recommended but it still remains the same.

However i now have different errors on my log:

[23-Mar-2018 09:46:16 UTC] PHP Fatal error: Uncaught Error: Call to undefined method WC_Order::get_currency() in /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-orders.php:108 Stack trace: #0 /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-orders.php(42): MailChimp_WooCommerce_Transform_Orders->transform(Object(WP_Post)) #1 /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-api.php(70): MailChimp_WooCommerce_Transform_Orders->compile('1', 5) #2 /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-abstract-sync.php(208): MailChimp_WooCommerce_Api->paginate('orders', '1', 5) #3 /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-abstract-sync.php(94): MailChimp_WooCommerce_Abtstract_Sync->getResources in /public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-woocommerce-transform-orders.php on line 108

and i also noticed that there is a persistent item in the wp_queue table that simply won't go away -
id: 4317 job: O:36:"MailChimp_WooCommerce_Process_Orders":11:{s:9:"*action";s:36:"mailchimp_woocommerce_process_orders";s:5:"items";a:0:{}s:41:"MailChimp_WooCommerce_Abtstract_Syncapi";N;s:40:"MailChimp_WooCommerce_Abtstract_Syncmc";N;s:49:"MailChimp_WooCommerce_Abtstract_Syncplugin_name";s:21:"mailchimp-woocommerce";s:11:"*store_id";s:0:"";s:26:"should_kill_queue_listener";b:0;s:11:"WP_Jobjob";N;s:13:"WP_Jobdelay";i:0;s:15:"WP_Jobdeleted";b:0;s:16:"WP_Jobreleased";b:0;} attempts: 1 locked: 1 locked at: 2018-03-22 11:37:46 available_at: 2018-03-22 11:03:30 created_at: 2018-03-22 11:03:30

That is also the only item in the table that has any value in the "locked at" column.

Thanks,
Bruno

[ryanhungate]

@brunompbarbosa The last error you had shown tells us that we need to look into this particular version of woo and adjust the way it's handling the order transformations into MailChimp. We will get back to you here shortly but it looks as if this is incompatible with your version at the current point. We don't think this will be a hard fix to implement but will let you know when we've been able to test this ourselves. This is not production ready but this file in particular is what we're going to test out to see if it solves the < 3.0 install issues.

@nailladynam I think you might be experiencing something different - are you using the hosted WP on wordpress.com? If so, you need to be on a business plan - and also one other thing that came up recently was that you'll have to tell them to make sure your site does not have the plugin disabled with a constant of DISABLE_WP_HTTP_WORKER set to true. Please let me know if that helps.

[nailladynam]

thanks @ryanhungate - I'll have them look into it - I am on the WP hosted Business plan. Will let you know what they have to say, much appreciated!

[brunompbarbosa]

@ryanhungate thanks, i'll backup the database and give it a shot to see if it makes any difference. I'm also going to try and see if i can find the time to test upgrading the WooCommerce without breaking the site, and i'll come back to you with more information on that.

[khungate-zz]

Hi @brunompbarbosa @nailladynam we wanted to follow up and see if your issues have been resolved. Please let us know if we can be of any more assistance.

[khungate-zz]

Closing out this issue due to inactivity, please open up a new ticket if the issue happens again.

[gabiu]

Hi,
I run version 2.3.1 with WooCommerce 3.8.1 and it imported about 3469 of 9212 orders so far.
Not it's stuck to the same orders over and over again for some reason:

2020-02-10T00:27:28+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Orders starts in the next minute 2020-02-10T00:27:32+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771408 :: email: [email protected] 2020-02-10T00:27:33+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771404 :: email: [email protected] 2020-02-10T00:27:33+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771400 :: email: [email protected] 2020-02-10T00:27:34+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771396 :: email: [email protected] 2020-02-10T00:27:34+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771392 :: email: [email protected] 2020-02-10T00:27:35+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Orders starts in the next minute 2020-02-10T00:27:39+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771408 :: email: [email protected] 2020-02-10T00:27:39+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771404 :: email: [email protected] 2020-02-10T00:27:40+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771400 :: email: [email protected] 2020-02-10T00:27:40+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771396 :: email: [email protected] 2020-02-10T00:27:41+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771392 :: email: [email protected] 2020-02-10T00:27:41+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Orders starts in the next minute 2020-02-10T00:27:45+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771408 :: email: [email protected] 2020-02-10T00:27:46+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771404 :: email: [email protected] 2020-02-10T00:27:47+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771400 :: email: [email protected] 2020-02-10T00:27:47+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771396 :: email: [email protected] 2020-02-10T00:27:48+00:00 NOTICE order_submit.success :: updateStoreOrder :: #771392 :: email: [email protected]

It's like this for the past few days...