search

mailchimp / mc-woocommerce

MailChimp for Woocommerce Integration. Syncs all data (subscriber, customers, orders, products) and enables marketing automation with email campaigns, automations, ads, postcards and more.
https://wordpress.org/plugins/mailchimp-for-woocommerce/
GNU General Public License v2.0
82 stars 66 forks source link

MailChimp for WooCommerce - Disconnected Randomly and Unable to Reconnect #130

Closed jessiebrown closed 6 years ago

jessiebrown commented 7 years ago
ryanhungate commented 7 years ago

@jessiebrown do you have a support ticket I can take a look at? This is really difficult to answer as is. You mean WooCommerce just stopped working? Any details that I can work with?

jessiebrown commented 7 years ago

@ryanhungate I have some more info I can add. Let me know if you need anything else.

How the store appears in MC Connected Sites Page: disconnected

WordPress Environment

Home URL: http://beautyandthebees.net Site URL: https://beautyandthebees.net WC Version: 3.0.8 Log Directory Writable: ✔ WP Version: 4.7.5 WP Multisite: – WP Memory Limit: 384 MB WP Debug Mode: – WP Cron: – Language: en_US

Server Environment

Server Info: Apache PHP Version: 5.6.30 PHP Post Max Size: 128 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.45.0 OpenSSL/1.0.1e SUHOSIN Installed: – MySQL Version: 5.6.34 Max Upload Size: 128 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔

Database

WC Database Version: 3.0.8 WC Database Prefix: wp_ 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: ✔ MaxMind GeoIP Database: ✔

Security

Secure connection (HTTPS): ❌Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates. Hide errors from visitors: ✔

Active Plugins (47)

AddToAny Share Buttons: by AddToAny – 1.7.11 Admin Menu Editor: by Janis Elsts – 1.7.3 iThemes Security: by iThemes – 6.2.1 Contact Form 7: by Takayuki Miyoshi – 4.8 Display Product for WooCommerce: by Sureshopress – 1.8.3 FooBox HTML & Media Lightbox: by FooPlugins – 2.4.0.0 Genesis Columns Advanced: by Nick Diego – 2.0.3 Genesis Connect for WooCommerce: by StudioPress – 0.9.9 Genesis Extender: by The Cobalt Apps Team – 1.8.0 Genesis Title Toggle: by Bill Erickson – 1.7.1 GPL Kit: by GPL Kit – 1.0.6 Image Widget: by Modern Tribe Inc. – 4.4.4 Instagram Feed: by Smash Balloon – 1.4.9 MailChimp for WooCommerce: by MailChimp – 2.0.0 PayPal for WooCommerce: by Angell EYE – 1.4.5 WooCommerce Product Filter: by Mihajlovic Nenad – 5.1.0 Really Simple CAPTCHA: by Takayuki Miyoshi – 2.0 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 2.2.6 Restrict Widgets: by dFactory – 1.3.1 Reveal IDs: by Oliver Schlöbe – 1.5.1 ScrapeAZon: by James R. Hanback Jr. – 2.2.7 Shortcodes Ultimate: by Vladimir Anokhin – 4.9.9 Simple Follow Me Social Buttons Widget: by Lucy Tomás – 3.3.3 Slider PRO: by bqworks – 3.8 Social Media Feather: by socialmediafeather – 1.8.4 Toolset Types: by OnTheGoSystems – 2.2.12 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 2.13.4.21 WooCommerce Best Seller: by – 1.0.0 Widget Logic: by wpchefgadget alanft – 5.8.2 WooCommerce Colors: by WooThemes – 1.0.6 WooCommerce Conditional Content: by Lucas Stark – 2.0.0 – 2.0.2 is available WooCommerce Custom Product Tabs Lite: by SkyVerge – 1.6.1 WooCommerce Print Invoice & Delivery Note: by Triggvy Gunderson – 4.1.5 WooCommerce Dynamic Pricing: by Lucas Stark – 3.0.8 – 3.0.9 is available WooCommerce Amazon Pay Gateway: by WooCommerce – 1.7.1 WooCommerce PayPal Express Checkout Gateway: by WooCommerce – 1.4.0 WooCommerce AdWords Conversion Tracking: by Wolf+Bär GmbH – 1.3.5 WooCommerce Google Analytics Integration: by WooCommerce – 1.4.2 WooCommerce Product Bundles: by SomewhereWarm – 5.2.4 – 5.3.1 is available WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.14 WooCommerce - ShipStation Integration: by WooCommerce – 4.1.15 WooCommerce Table Rate Shipping: by Bolder Elements – 3.6.5 WooCommerce: by Automattic – 3.0.8 – 3.0.9 is available WooCommerce Helper: by WooCommerce – 1.7.2 – Network enabled Yoast SEO: by Team Yoast – 4.9 WP-Mail-SMTP: by Callum Macdonald – 0.10.1 WPS Hide Login: by Remy Perona for WPServeur – 1.1.7

Settings

API Enabled: ✔ Force SSL: ✔ Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: bundle (bundle) composite (composite) 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: #282 - /products/ Cart: #48 - /cart/ Checkout: #49 - /checkout/ My account: #50 - /my-account/

Theme

Name: Bee Beauty Pro Theme Version: 2.0.4 Author URL: http://www.weavemedia.com.au/ Child Theme: ✔ Parent Theme Name: Genesis Parent Theme Version: 2.5.1 Parent Theme Author URL: https://www.studiopress.com/ WooCommerce Support: ✔

Templates

Overrides: beebeauty/woocommerce/myaccount/form-reset-password.php

ryanhungate commented 7 years ago

Hey @jessiebrown thanks for the info... this actually makes me feel like they might benefit the most from deleting our plugin and doing a re-install... do you know if they have done this? Not just 'disabling' but actually doing a delete?

It seems as if this customer has had the plugin for a while during the initial build out times and a lot of conflicts have been resolved over these months.

jessiebrown commented 7 years ago

@ryanhungate it looks like from the tickets, they've just all been disconnecting instead of fully deleting. I can have the users try that to see if it resolves the issue and update here when they've tried it.

jessiebrown commented 7 years ago

@ryanhungate the users did delete and re-install in all cases and it didn't resolve the issue.

ryanhungate commented 7 years ago

@jessiebrown this is really strange... I'm starting to think to get to the bottom of this, we may need to gain access to the webserver / database that this thing is hosted on. Sounds like we may have some stagnant data in the database that needs to be deleted before it's going to work. The weird part though is that the first record in the screenshot you showed me ( was the first time it was connected to you guys ) and it's still showing active... but yet the others are inactive. Don't know how to get this right without looking into the database.

ryanhungate commented 7 years ago

@jessiebrown they might just need to go to the PHPMyAdmin and delete anything beginning with mailchimp-woocommerce% to get a fresh setup going... really tough to say.

jessiebrown commented 7 years ago

@ryanhungate okay - I'll have them try that too. Thanks! If that doesn't work, I can see about getting the other information for you.

ryanhungate commented 7 years ago

@jessiebrown do we have any update on this one? The thing is, the plugin is supposed to do some auto cleanup when it's deleted / uninstalled etc... so I'm a bit confused on why this would still be happening.

jessiebrown commented 7 years ago

@ryanhungate sorry I missed this while I was out on vacation! I did followup with some of the users and one was able to check PHPMyAdmin and didn't see anything in there with a mailchimp-woocommerce% in there. Is there anything else that we can have them try on their end?

ryanhungate commented 7 years ago

@jessiebrown For cases like this, we may need to add some logging code to the plugin where we can send data back to us for troubleshooting. We may want to try to do something in the next release that would show any data related to the plugin meta we're saving because there could be a bad boolean in there somewhere which is not allowing the plugin to install. I'll think about that for a bit too.

jessiebrown commented 7 years ago

@ryanhungate we had one of the users write back in about this and here is some additional info I have for you if it helps.

The users stated there is nothing in PHPMyAdmin containing mailchimp-woocommerce%.

We additionally had them disconnect their connected sites and attempt to reconnect the integration with no luck. At this time, we noticed a large amount of failing API calls being made to the account. These can be found by looking at the API Stats for 7-21-2017 around 19:00 hrs. It's obvious from those that MC4Woocommerce attempted to perform a sync.

7-07-21_api_calls.xlsx

ryanhungate commented 7 years ago

@jessiebrown thanks for the list... I don't know if it's my computer or the document itself that doesn't show the exact URL's being called, but I can't see the store id. If we're getting a 404, it seems as if the 'store foreign id' that's being used is probably off somehow. What we need to do is look at the wordpress options table and do a query for all options LIKE mailchimp-woocommerce-% that will show you all of the options that are saved for the plugin, including the 'store_id' which is the one that should match up with a store foreign id on your side.

We need to grab the most recent store ID in MailChimp that's still 'active' and apply that to the 'store_id' option in the wordpress database to get the thing connected again. I'm pretty sure that this will solve the problem but the question is, how did it ever get messed up in the first place?