500 error when trying to put API to connect Mailchimp

Hey @alfaterra,

Thanks for the post! I’m sorry to hear about this and will to my best to help out.

In this case it might be best for the MailChimp support team to take a look to the connected MailChimp account. In order to allow them to do this, could you please contact their support team with a link to this post, the steps that were taken leading up to this issue (and a screenshot of the error, if at all possible) and a copy of your WooCommerce System Status Report (a txt file would be fine) ? That would allow them to take a peek at the API calls coming through and best diagnose the issue.

Thanks!

Pearl

Hello)

Unfortunately, I am a free user of Mailchimp, so I couldn’t get help from MailChimp support team.

Hey @alfaterra,

I understand. If you’d rather dig in as much as we can on our end, please feel free to send your WooCommerce System Status report and other requested details here and I will help out as much as I can on my end.

Cheers,

Pearl

Yes, please, I would love to make it work. That’s what I get from Woo System Status

### WordPress Environment ###

Home URL: https://howtoknowhow.ru
Site URL: https://howtoknowhow.ru
WC Version: 3.1.2
Log Directory Writable: ?
WP Version: 4.8.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: ru_RU

### Server Environment ###

Server Info: nginx/1.10.3
PHP Version: 7.0.22-0ubuntu0.16.04.1
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 
SUHOSIN Installed: –
MySQL Version: 5.7.19
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ? Your server does not support the mbstring functions - this is required for better character encoding. Some fallbacks will be used instead for it.
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.1.2
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 (16) ###

Contact Form 7: by Takayuki Miyoshi – 4.9
Disable Feeds: by Samir Shah
BBpress support by Matthew Sigley – 1.4.4

Envato WordPress Toolkit: by Envato – 1.7.3
EU Opt-In Compliance for MailChimp: by YIKES
Inc. – 1.1.2

I Recommend This: by themeist – 3.7.7
MailChimp for WooCommerce: by MailChimp – 2.0.1
NextPay: by NextPay.RU – 1.0.0
Uncode Core: by Undsgn – 1.4.2
Uncode Visual Composer: by Michael M - WPBakery.com – 5.2.1
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.13.7

Visual Composer Clipboard: by bitorbit – 3.24
VC Particles Background: by Boom-Apps – 1.2
WooCommerce Checkout Manager: by Visser Labs – 4.1.6
WooCommerce: by Automattic – 3.1.2
Yoast SEO: by Team Yoast – 5.4.1
Easy Forms for MailChimp: by YIKES
Inc. – 6.3.25

### Settings ###

API Enabled: ?
Force SSL: –
Currency: RUB (?)
Currency Position: right_space
Thousand Separator: 
Decimal Separator: ,
Number of Decimals: 0
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: #45877 - /shop/
Cart: #44521 - /shop/cart/
Checkout: #7 - /shop/checkout/
My account: #8 - /shop/my-account/

### Theme ###

Name: Uncode
Version: 1.6.3
Author URL: https://www.undsgn.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: uncode/woocommerce/archive-product.php
uncode/woocommerce/cart/mini-cart.php
uncode/woocommerce/content-product.php
uncode/woocommerce/content-product_cat.php
uncode/woocommerce/content-single-product.php
uncode/woocommerce/loop/loop-end.php
uncode/woocommerce/loop/loop-start.php
uncode/woocommerce/loop/pagination.php
uncode/woocommerce/myaccount/my-account.php
uncode/woocommerce/myaccount/navigation.php
uncode/woocommerce/notices/error.php
uncode/woocommerce/notices/notice.php
uncode/woocommerce/notices/success.php
uncode/woocommerce/order/order-details-customer.php
uncode/woocommerce/order/order-details.php
uncode/woocommerce/product-searchform.php
uncode/woocommerce/single-product/add-to-cart/external.php
uncode/woocommerce/single-product/add-to-cart/grouped.php
uncode/woocommerce/single-product/add-to-cart/simple.php
uncode/woocommerce/single-product/add-to-cart/variable.php
uncode/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
uncode/woocommerce/single-product/meta.php
uncode/woocommerce/single-product/price.php
uncode/woocommerce/single-product/product-image.php
uncode/woocommerce/single-product/product-thumbnails.php
uncode/woocommerce/single-product/related.php
uncode/woocommerce/single-product/review.php
uncode/woocommerce/single-product/share.php
uncode/woocommerce/single-product/tabs/additional-information.php
uncode/woocommerce/single-product/tabs/description.php
uncode/woocommerce/single-product/tabs/tabs.php
uncode/woocommerce/single-product/title.php
uncode/woocommerce/single-product/up-sells.php
uncode/woocommerce/single-product-reviews.php
uncode/woocommerce/single-product.php
uncode/woocommerce/taxonomy-product_cat.php

Thank you in advance!

Hey @alfaterra,

Thanks for getting back to us with that additional information. Your setup appears to meet the WooCommerce Server Recommendations, which is a great start. To be sure that I have a good understanding of the workflow leading up to this issue – do you mind replying back with your exact steps taken before losing connection? Were there any recent changes to the theme or plugin set up, for example? At what step in the process does the white screen of death appear? That being said, I did notice that you have a few plugins installed that have caused issues for other folks – specifically contact form 7, yoast seo, and Easy forms for MailChimp. If functionality is restored by disabling any of these or other plugins please let us know so we can pass this information along to our developers.

Thanks! We look forward to your reply.

Sincerely,

Pearl

Hey, Pearl) Thanks for your reply!

I’ve disabled these plugins (contact form 7, yoast seo, and Easy forms for MailChimp), but result was the same: 500 error.

My steps were:
1. /wp-admin/options-general.php?page=mailchimp-woocommerce — I opened settings of Mailchimp for WooCommerce
2. Past in API information field my MailChimp API
3. Press “save changes”
4. 500 error (and /wp-admin/options.php in address line)

Recently I’ve moved to a new server, but everything else works fine. I am thinking that it might be something with access to options.php file, but don’t know, where to look for answers)

Hey again @alfaterra,

Thanks for helping us trouble shoot this matter – I’ve gone ahead and updated our developers with all of this information. Unfortunately this is not expected behavior, but it does sound similar to a handful of other cases that have been reported to us recently. Our developers are now digging in and working towards narrowing down the precise issue and working towards a resolution. Unfortunately I won’t be able to provide an ETA for resolution, but I will be sure to update this thread as soon as I am able.

Thanks for your patience, and thanks again for helping us investigate!

Pearl

Thank you!)

It seems that we solve the problem. We installed php-curl and it works!

Do you know, could I sync my store to MailChimp?
Now it says
Products: 4/5
Orders: 114/254

I’d love to all orders that were purchased at these disconnected days to be visible from MailChimp. Do you know, what could be done about it?

Hey @alfaterra,

That’s excellent news! To clarify a bit, we would expect MailChimp for WooCommerce to re-sync all products and orders once reconnected and backfill any orders that were placed while the integration was disconnected. This may take a bit of time, however – roughly one hour for every 5,000 records syncing. Also, could you please verify that all of the products expected to sync SHOULD sync – for example, are any of the products that aren’t syncing in draft mode?

Thanks!

Pearl

Hey, Pearl)

MailChimp synced all orders! thank you for your patience and help!

Do you know, how I could filter purchased orders from all of them? MailChimp seems to think that all placed orders were purchased and I couldn’t design automations based on commerce data because of it.

Thank you!

Hey @alfaterra,

Thanks for the reply – great to hear that the products and orders all back filled.
When you ask about filtering purchased orders from all of them – are you seeing canceled or invalid orders sync over into your MailChimp account as well? We would only expect completed orders to sync, so please let us know if you are seeing something else.

Thanks!

Pearl

Hello, Pearl)

Yes, I mean that in MailChimp I see orders that have
– pending payment,
– processing,
– complete
statuses. And even ones that in trash — they listed like orders in MailChimp.

I’d love to have ONLY completed/purchased orders in MailChimp

Hey @alfaterra,

Ah, thank you so much for clarifying that. I did some testing on my end as well and am seeing the same behavior in my testing environment. I agree that this is not ideal and I will bring this up internally with our developers. Thanks again for bringing this to our attention! Please feel free to reach back out at any time if you notice anything else interesting or have any additional questions about the plugin.

Sincerely,

Pearl

Thank you, Pearl)

Have a nice day