surveysayz
Forum Replies Created
-
“If the STORE failed to be created we should have a message in there.”
Well… BIG lesson learned and
errors.store_infoa great resource for troubleshooting.<p>email_address: This email address looks fake or invalid. Please enter a real email address.</p>Since the email address seemed valid and has always sent and received mail, I never thought it would be an issue. Changed address and connections status is no longer N/A, syncs properly, and updates the Mailchimp account. Problem solved.
You my friend, @ryanhungate are both a scholar and a gentleman. It’s been a pleasure troubleshooting with you. THANK YOU!
I have no doubt, @ryanhungate. Thank you for your time and assistance. Definitely, Shared IP. I came across that post, but hadn’t tried it based on the shared IP and that I was not blocked from Akamai after the 200 response.
Thanks, @ryanhungate. I absolutely get it, first thing I tried, and happy to try it again. The results are the same. Check it out:
The store ID is not found in the response, nor is the store URL, only the store URLs from locally synced sites (different names entirely). Which lines up with what I see when logged into the mailchimp account-> connections.
@ryanhungate, ah yes, I’m familiar with this post, tried it the other day and got a 200 response. Please let me know if I should paste the rest below ‘keep-alive.’ Here it is:
curl -v -X GET https://us2.api.mailchimp.com/3.0/ecommerce/stores?apikey=***masked***
Note: Unnecessary use of -X or –request, GET is already inferred.
* Trying 23.7.90.229…
* Connected to us2.api.mailchimp.com (23.7.90.229) port 443 (#0)
* Cipher selection: ALL:!EXPORT:!EXPORT40:!EXPORT56:!aNULL:!LOW:!RC4:@STRENGTH
* successfully set certificate verify locations:
* CAfile: /etc/pki/tls/certs/ca-bundle.crt
CApath: none
* TLSv1.2 (OUT), TLS handshake, Client hello (1):
* TLSv1.2 (IN), TLS handshake, Server hello (2):
* NPN, negotiated HTTP1.1
* TLSv1.2 (IN), TLS handshake, Certificate (11):
* TLSv1.2 (IN), TLS handshake, Server key exchange (12):
* TLSv1.2 (IN), TLS handshake, Server finished (14):
* TLSv1.2 (OUT), TLS handshake, Client key exchange (16):
* TLSv1.2 (OUT), TLS change cipher, Client hello (1):
* TLSv1.2 (OUT), TLS handshake, Unknown (67):
* TLSv1.2 (OUT), TLS handshake, Finished (20):
* TLSv1.2 (IN), TLS change cipher, Client hello (1):
* TLSv1.2 (IN), TLS handshake, Finished (20):
* SSL connection using TLSv1.2 / **** masked ****
* Server certificate:
* subject: C=US; ST=Georgia; L=Atlanta; O=The Rocket Science Group, LLC; OU=IT; CN=*.api.mailchimp.com
* start date: May 10 00:00:00 2019 GMT
* expire date: Aug 8 12:00:00 2020 GMT
* subjectAltName: host “us2.api.mailchimp.com” matched cert’s “*.api.mailchimp.com”
* issuer: C=US; O=DigiCert Inc; OU=www.digicert.com; CN=GeoTrust RSA CA 2018
* SSL certificate verify ok.
> GET /3.0/ecommerce/stores?apikey=***masked*** HTTP/1.1
> Host: us2.api.mailchimp.com
> User-Agent: curl/7.48.0
> Accept: */*
>
< HTTP/1.1 200 OK
< Server: openresty
< Content-Type: application/json; charset=utf-8
< Vary: Accept-Encoding
< X-Request-Id: ***masked***
< Link: <https://us2.api.mailchimp.com/schema/3.0/Ecommerce/Stores/Collection.json>; rel=”describedBy”
< Date: Wed, 13 May 2020 19:08:18 GMT
< Content-Length: 10258
< Connection: keep-aliveMailchimp plugin log:
2020-05-13T18:31:39+00:00 NOTICE mailchimp-woocommerce-sync.started :: Starting Sync :: Wed, May 13, 2020 6:31 PM
2020-05-13T18:31:39+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Coupons queued :: page 1
2020-05-13T18:32:51+00:00 DEBUG MailChimp_WooCommerce_Process_Coupons@handle :: coupons :: completing now!
2020-05-13T18:32:51+00:00 NOTICE coupon_sync.completed :: Done with the coupon queueing.
2020-05-13T18:32:51+00:00 NOTICE sync.full_sync_manager.queue :: Starting PRODUCTS queueing.
2020-05-13T18:32:51+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Products queued :: page 1
2020-05-13T18:32:51+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Products queued :: page 2
2020-05-13T18:32:51+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Single_Product queued :: obj_id 39
2020-05-13T18:32:53+00:00 DEBUG MailChimp_WooCommerce_Process_Products@handle :: products :: completing now!
2020-05-13T18:32:53+00:00 NOTICE product_sync.completed :: Done with the product queuing
2020-05-13T18:32:53+00:00 DEBUG product_submit.debug :: #39 :: Array
(
[id] => 39
[title] => foo
[handle] => foo
[url] => http://testsite.com/?product=foo
[variants] => Array
(
[0] => Array
(
[id] => 39
[title] => foo
[url] => http://testsite.com/?product=foo
[inventory_quantity] => 0
[backorders] => false
[visibility] => visible
))
[published_at_foreign] => 2020-05-10 00:56:17
)2020-05-13T18:32:54+00:00 NOTICE product_submit.error :: addStoreProduct :: #39 :: Error Code 404 :: Resource Not Found :: The requested resource could not be found. on 1789 in /home/bacon/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-api.php
2020-05-13T18:32:54+00:00 DEBUG action_scheduler.process_job.fail :: MailChimp_WooCommerce_Single_Product :: obj_id 39 :: MailChimp_WooCommerce_Error – Resource Not Found :: The requested resource could not be found.
2020-05-13T18:40:24+00:00 NOTICE mailchimp-woocommerce-sync.started :: Starting Sync :: Wed, May 13, 2020 6:40 PM
2020-05-13T18:40:24+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Coupons queued :: page 1
2020-05-13T18:40:39+00:00 NOTICE coupon_sync.completed :: Done with the coupon queueing.
2020-05-13T18:40:39+00:00 NOTICE sync.full_sync_manager.queue :: Starting PRODUCTS queueing.
2020-05-13T18:40:39+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Products queued :: page 1
2020-05-13T18:40:39+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Products queued :: page 2
2020-05-13T18:40:39+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Single_Product queued :: obj_id 39
2020-05-13T18:40:41+00:00 NOTICE product_sync.completed :: Done with the product queuing
2020-05-13T18:40:41+00:00 NOTICE product_submit.error :: addStoreProduct :: #39 :: Error Code 404 :: Resource Not Found :: The requested resource could not be found. on 1789 in /home/bacon/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-api.php
2020-05-13T18:41:13+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Orders queued :: page 1
2020-05-13T18:41:13+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Orders queued :: page 2
2020-05-13T18:41:13+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Single_Order queued :: obj_id 40
2020-05-13T18:41:15+00:00 NOTICE order_sync.completed :: Done with the order queueing.
2020-05-13T18:41:16+00:00 NOTICE api.add_product.error :: Resource Not Found :: The requested resource could not be found. :: Array
(
[submission] => Array
(
[id] => empty_line_item_placeholder
[title] => Empty Line Item Placeholder
[vendor] => deleted
[variants] => Array
(
[0] => Array
(
[id] => empty_line_item_placeholder
[title] => Empty Line Item Placeholder
[price] => 1
[inventory_quantity] => 0
[backorders] => false
[visibility] => hidden
))
)
)
2020-05-13T18:41:31+00:00 NOTICE sync.completed :: Finished Sync :: Wed, May 13, 2020 6:41 PM (total time: 00:01:07)
@ryanhungate, thanks again, please let me know if there is anything else I can provide. Standing by…
Saving the store settings and forcing a re-sync still shows n/a in the account name.
Uninstalled, verified in wp-admin/options.php there is nothing mailchimp related. Deleted and re-installed 2.4. Got all the way through setup, selected an audience list, then once on the overview screen where the sync begins, account N/A, claims to sync but no record under connections at Mailchimp.com.
Fatal Error:
2020-05-13T18:41:16+00:00 CRITICAL Uncaught Error: Call to a member function getId() on boolean in /home/bacon/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-single-order.php:261
Stack trace:
#0 /home/bacon/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-single-order.php(69): MailChimp_WooCommerce_Single_Order->process()
#1 /home/bacon/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/class-mailchimp-woocommerce-service.php(881): MailChimp_WooCommerce_Single_Order->handle()
#2 /home/bacon/public_html/wp-includes/class-wp-hook.php(287): MailChimp_Service->mailchimp_process_single_job(40)
#3 /home/bacon/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(”, Array)
#4 /home/bacon/public_html/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
#5 /home/bacon/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/actions/ActionScheduler_Action.php(22): do_a in /home/bacon/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/processes/class-mailchimp-woocommerce-single-order.php on line 261Using Serverpress to develop locally, but to be clear, the local installs do not mirror the install at the hosting provider.
Simply put, three fresh installs different domains, all connect, sync, and show under connections at mailchimp.com.
Three separate domains installed on hosting provider, none actually connect, all show N/A and nothing under connections from any of these domains at mailchimp.com.
I have tried, but will try again right now, steps 1 and 2 and report back with anything in the fatal logs…And @ryanhungate thank you so much, for your time and support!
Hi @khungate. I noticed yesterday, you posted a few questions to another user experiencing sync issues. I thought it would save us time if I also answered those questions here. Thank you very much for your help, I really appreciate it. I am standing by with test sites, ready to wipe and start over, nothing is sacred, whatever we need to do.
Mailchimp for WooCommerce 2.4
PHP 7.2.26
Log Errors: DEBUG action_scheduler.process_job.fail
WP_Cron confirmed enabled
Current process count: 6 it has not reached the limit.
Hosting provider running Nginx and they cannot exclude
Only 2 plugins, woocommerce and Mailchimp for WooCommerce– What plugin version are you using?
– What version of PHP are you using?
– Are there any fatal errors in WooCommerce? (WooCommerce -> Status -> Logs)
– If you’re using the current version of the plugin, it utilizes a queue powered by Action Scheduler. It depends on WP_CRON to be activated with your hosting provider. Can you confirm it’s enabled?
– If you’re using a host that makes use of CPU throttling, can you check to see if you’ve hit your limit after initiating the sync?
– Do you have any caching plugins or services running? If you’re using Redis, Nginx or MemCache, see if you or your hosting provider can exclude certain paths to the REST API and /wp-json/mailchimp-for-woocommerce.
– If you have a large number of plugins being used, you may need to bump up your memory limit on your server (1GB for example) to accommodate the initial sync.Forum: Plugins
In reply to: [EP Display Users] [Plugin: EP Display Users] layout broken on stock install
