store not syncing
Gravatar
Joined: 2018-07-23
Posts: 1
All we recently upgraded our Ebizmart > Mailchimp for Magento integration to 1.1.13.


- We have a multi store Magento model with 5 store integrated with Mailchimp
- Prior to upgrade everything was working fine for all 5 stores
- After the upgrade, 3 stores are syncing with mailchimp and 2 stores are not
- All stores are configured the same way

Here is what I have done to troubleshoot so far
1. Cleared all mailchimp errors
2. Ensured all batches completed successfully
3. Resent Ecommerece data
4. checked core config data to make sure everything was correct
5. cleared cache
6. The cron is configured correctly (otherwise the other 3 stores would not process)

At this point, for the 2 stores that are not syncing, when I check mailchimp_ecommerce_sync_data the data is not even loading.

Please assist
Gravatar
Joined: 2014-08-07
Posts: 2624
This is being handled in our ticket system.
Once the solution is found I will post it here.

Kind Regards,
Santiago.
Gravatar
Joined: 2013-01-03
Posts: 36
this is happening to us as well after upgrading to 1.1.13. We've now upgraded again to 1.1.14 and reset the store... nothing is being sent to Mailchimp
Gravatar
Joined: 2014-08-07
Posts: 2624
SOLUTION: There seems to be a problem when a store with the extension disabled does not have an API Key set and it does not inherit it from the parent scope.
Even if there is one store view or any scope with the extension disabled please leave the Use parent configuration check box ticked for the API Key field.

Kind Regards,
Santiago,
Gravatar
Joined: 2013-01-03
Posts: 36
That doesn't seem to have fixed it for us. However the log is filling up with the following store view error:

2019-01-24T15:30:03+00:00 DEBUG (7): Invalid attribute name: mailchimp_store_view
Gravatar
Joined: 2014-08-07
Posts: 2624
Hello Jonathan,

That means one of the database update script was not correctly executed.
You can get that script to be executed again in two steps.
1. Run the sql query: DELETE FROM core_resource WHERE code='mailchimp_setup';
2. Refresh Magento cache.

Kind Regards,
Santiago.
Gravatar
Joined: 2013-01-03
Posts: 36
I think that did it! I'm now seeing this (which I haven't seen before)

The store data is currently being migrated to the new version. This process might take a while depending on the amount of data in Magento.
Gravatar
Joined: 2014-08-07
Posts: 2624
Yeah, that is something that should disappear after 3 cron runs (15 minutes).
You can force it by running the following sql query: DELETE FROM conre_config_data WHERE path LIKE 'mailchimp/general/migrate%';

Refresh Magento cache afterwards.

Kind Regards,
Santiago.

NEWSLETTER

Subscribe to our newsletter to receive emails and useful news articles