This topic can no longer be replied to because it has been locked.

Order Details not passed - Automation not working
Gravatar
Joined: 2017-03-09
Posts: 13
I'm trying to get Mail Chimp automation to work - customer buys a product then a day later gets an email sent automatically offering them an upgrade.

Although Mail Chimp appears to be working OK, it appears that order details are not being sent across - numbers have looked like this for a week

Total subscribers: 38339
Ecommerce Data uploaded to MailChimp:
Total Customers: 38836
Total Products: 4543
Total Orders: 0
Total Carts: 26

Mail Chimp support have given up on me and referred me to this forum - has anyone got automation working, if so, how?
Gravatar
Joined: 2012-03-08
Posts: 843
Hi Phil,

thanks for choosing our extension.
Please read at this to help us to help you

Best
Gravatar
Joined: 2017-03-09
Posts: 13
Hi hopefully this helps further;

Version 1.9.2.4 (Magento) 1.1.5(MailChimp)

Extract from mailchip error log :
2017-03-14T11:40:04+00:00 DEBUG (7): SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento`.`catalog_product_entity_datetime`, CONSTRAINT `FK_CAT_PRD_ENTT_DTIME_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELE), query was: INSERT INTO `catalog_product_entity_datetime` (`entity_type_id`,`attribute_id`,`store_id`,`value`) VALUES (?, ?, ?, '2017-03-14 11:40:04') ON DUPLICATE KEY UPDATE `value` = VALUES(`value`)

Extract from magento log :
2017-03-14T11:14:43+00:00 ERR (3): Notice: Undefined index: action in /home/magento/public_html/app/code/community/Ebizmarts/MailChimp/Model/ProcessWebhook.php on line 142

Error in newsletter -> mailchimp
tax_total : Schema describes number, NULL found instead / shipping_total : Schema describes number, NULL found instead
Gravatar
Joined: 2017-03-15
Posts: 16
Phil,

Did you get an answer on the issue. I have similar issue and looking for solution.
Gravatar
Joined: 2017-03-09
Posts: 13
No reply at all

Support on this issue has been abysmal so looking to ditch MailChimp completely
Gravatar
Joined: 2016-06-09
Posts: 1020
See https://ebizmarts.com/forums/topics/view/25139

NEWSLETTER

Subscribe to our newsletter to receive emails and useful news articles