1. Matt
  2. CMC - Mailchimp for Joomla!
  3. Tuesday, 04 February 2020
  4.  Subscribe via email
Hello,
I just installed CMC - Mailchimp for Joomla. I added the token to the component, but I can't sync with my virtuemart store (v3.6.10). It just hangs on the "Shop synchronization in progress" pop up, No progress is indicated for any of the 4 categories to be sync'd. I do see this in my logs:
[03/Feb/2020:20:01:10 -0600] "GET /administrator/index.php?option=com_cmc&task=ecommerce.getsynctotalcount HTTP/1.1" 500 -

It looks like a 500 error is the cause, but there are no other errors reported.

Please advise, thanks!
-Matt
Responses (23)
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
I haven't tested the integration since we last wrote. It's possible that something has changed on the virtuemart front.

Will need to setup a test environment and test.

Regards,
Daniel
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 1
Accepted Answer Pending Moderation
I believe the latest version of VM (3.6) is the issue. Are you been able to test CMC successfully with 3.6?

Thanks for your help!
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 2
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
Just checked and it is crashing for me as well. Something has changed. Will need to debug.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 3
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
Things have changed... I'll need some time to figure out where stuff was moved and how we are supposed to read the products out.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 4
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
Ok, thanks to Max from VM I think that we can have a quick fix.
Go in administrator/components/com_cmc/libraries/shopsync/shops/virtuemart.php

on line 5 and 6 you have:

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php';
require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/vmmodel.php';


change it to

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php';
VmConfig::loadConfig();


now rerun the sync and it should work. (or at least it did for me with test data)

Regards,
Daniel
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 5
Accepted Answer Pending Moderation
Hi Daniel,

Thanks for looking into this. Max is a good guy!

I made the changes to the virtuemart.php file as you instructed and I see a little progress now. However, I am still getting an error while trying to sync (see attached image). We have ~275 products, but it came up as 0 then you can see the error behind the popup that says "Error Syncing Customers."

Let me know if I can provide any additional information.

Thanks,
-Matt
Attachments (1)
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 6
Accepted Answer Pending Moderation
Hi Dan,

I just wanted to follow up here as I am still having sync issues.

Thanks for all of your help,
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 7
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
Hi Matt,

Sorry, I guess I forgot to post my comment last time. Can I get access to your site to debug the issue live in there? I cannot reproduce the problem with the demo data form VM.

Regards,
Daniel
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 8
Accepted Answer Pending Moderation
Of course, I have setup access for you as an admin, how can I send this to you privately?
Thanks Dan,
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 9
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
Just use the forum.. At the bottom of the post input box is a "site details" tab. Enter the access credentials there and they are only visible to site moderators. After I'm ready with debugging you can remove them and change the credentials on your site.

Please give me ftp + it would be very good if I also have phpmyadmin access to the database to eventually inspect the raw data if necessary.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 10
Accepted Answer Pending Moderation
Hello Dan,
I have added the site url, user/pass. Ftp access is really difficult to set up, I can try to see if our WebOps team will do it. I have added mysql access to ftp for now. Can we work around ftp, happy to send any files you need.
Thanks,
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 11
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
Ok, at first glance I seem to be able to reproduce the issue on my machine. Will try to debug it tomorrow.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 12
Accepted Answer Pending Moderation
That is great news, thanks again for all of your help!
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 13
Accepted Answer Pending Moderation
Hi Daniel,

I wanted to reach out to see if you were able to debug this issue. Let me know how I can help!
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 14
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
I was traveling last week. Not sure if I'll find time for CMC this week, but I'll try to squeeze it somewhere when I get some free time.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 15
Accepted Answer Pending Moderation
Thanks Daniel, I appreciate the update.
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 16
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
Now in the corona times I should have some more time to look into this this week as I don't need to commute :)

Will let you know, once I've fixed it.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 17
Accepted Answer Pending Moderation
Thanks Daniel, be safe and be well!
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 18
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
So, okay! I had another look at this and I'm starting to doubt that we really have a problem.

Can you go in mailchimp click on your name -> connected sites -> do you see your site there?

click on it and remove it.

Then go in the joomla backend to CMC and re-sync.

In my case the error that I was seeing was -> something with store already synced. It seems that once a store is synced - you cannot resync it.

We have a plugin for virtuemart ecom360virtuemart that syncs products, users etc when you make modifications in virtuemart. So after initial sync there is no need to try to resync the store.

I tested this and it seems to work fine. I was able to create a newsletter and to pull a product from my VM store.

Before you turn on the ecom360 plugin you would have to make a 2 line change there as well. (things have changed in the latest vm version)

go to:
plugins/system/ecom360virtuemart/ecom360virtuemart.php

and change:


require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php';
require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/vmmodel.php';



to

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php';
VmConfig::loadConfig();


After that you can enable the plugin and the site should work. (if you don't do this change you'll see a white screen and your site won't work)

Regards,
Daniel
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 19
Accepted Answer Pending Moderation
Hi Daniel,
Thanks for working on this, I have followed the steps you outlined above and I have made some progress. The site does now sync, however, it shows 0 products. Meanwhile we have over 300 active products.

Your help is greatly appreciated, I hope you are doing well.
-Matt
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 20
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Last questions

Errror on Google Captcha V3 in Matukio
Hi, I am experiencing spam-problems on contact-forms protected by google reCa...
0 Replies
Posted on Wednesday, 20 March 2024
Google map styles migrating......
Google are updating their map styles. Is there anything we need to do to migrate...
0 Replies
Posted on Monday, 18 March 2024
  • #google maps
  • #map styles
Latest Hotspots Makes Website Hang
When using the Latest Hotspot module, the webpage slows down and does not load....
3 Replies
Posted on Monday, 15 January 2024
Text ändern
Hallo in der Übersicht der Veranstaltungen kann man ja auf "Mehr Informati...
0 Replies
Posted on Thursday, 14 March 2024
When is CComment compatible with Joomla 5?
When is CComment compatible with Joomla 5?...
3 Replies
Posted on Tuesday, 05 December 2023
  • #CComment
  • #Joomla 5